BTEQ: Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does not exist.

Tools & Utilities

BTEQ: Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does not exist.

I'm trying to run a bteq script from a Data Integrator Job. Basically, I generate a bteq file "on the fly" and run it. This is the bteq script generated:

.SET ERROROUT STDOUT;  
.LOGON XXX/ds_loader,XXXX;
.IF ERRORCODE != 0 THEN .QUIT 255;
CALL ds_loader.SP_GRABA_RESPUESTAS_DM ();
.IF ERRORCODE != 0 THEN .QUIT 255;
.EXIT 0

When it runs, it gives me the "Failure 5495 Stored Procedure  'ds_loader.SP_GRABA_RESPUESTAS_DM' does   not exist." error. The stored procedure exists in ds_loader. I copied the "CALL ds_loader.SP_GRABA_RESPUESTAS_DM()" line and executed in Teradata Assistant and ran OK. I'm missing something here? What could be happening?

I tried granting execute permissions on the SP, but i don't think this is the problem, and I don't know if it's right to grant to a user who owns the object:

GRANT EXECUTE PROCEDURE ON ds_loader.SP_GRABA_RESPUESTAS_DM TO ds_loader;

Hope someone can help me.

Here is My Log File:

...
*** Logon successfully completed.
*** Teradata Database Release is 13.00.01.31
*** Teradata Database Version is 13.00.01.32
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.

*** Set QUERY_BAND accepted.
*** Total elapsed time was 14 seconds.

*** Total elapsed time was 14 seconds.

+---------+---------+---------+---------+---------+---------+---------+----
.IF ERRORCODE != 0 THEN .QUIT 255;
+---------+---------+---------+---------+---------+---------+---------+----
CALL ds_loader.SP_GRABA_RESPUESTAS_DM ();
*** Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does
not exist.
Statement# 1, Info =0
*** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
.IF ERRORCODE != 0 THEN .QUIT 255;
.QUIT 255;
*** You are now logged off from the DBC.
*** Exiting BTEQ...
*** RC (return code) = 255
Thanks in advance
Tags (1)
3 REPLIES

Re: BTEQ: Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does not exist.

Hi all.. I am new for Teradata,, please help me..

I am trying to run BTEQ script.. in that script

.SET SESSION TRANSACTION BTET

.LOGON LOCALTD/TDUSER,TDUSER;

DATABSE SAMPLES;

SELECT ENAME

,SAL

,DEPTNO

FROM EMPLOYEE;

.QUIT

i save this script in D:\emp_scr.txt.. in Samples databse, i have my employee table..

in BTEQ, '.RUN FILE=D:\EMP_SCR.TXT', but after pressing ENTER key,

my screan automatically closed.. so i am not able to see the output.. can any one please tell me.. for out put what i have to do?
Junior Contributor

Re: BTEQ: Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does not exist.

How did you start BTEQ?

Directly entering BTEQ in Start -> Run - BTEQ?

Then remove the .QUIT

Or start it from command line: Start -> Run -> Cmd -> BTEQ

Dieter

Re: BTEQ: Failure 5495 Stored Procedure 'ds_loader.SP_GRABA_RESPUESTAS_DM' does not exist.

I'm still with the same problem. Also I've noticed it's an aleatory error. I ran the same job many times, and sometimes gives me the error, and sometimes no error. And it's the same job, same script, all the same.