All Forums Tools
bahadirbabacan 2 posts Joined 06/12
30 Aug 2013
Bteq didn't give error message

Hi everyone,
We are calling stored procedure from bteq, sometimes it exits with bteq exit code 8 but it doesn't give any error messages.
Here is the bteq log:
 

.logon TD_2700/TPTLoader,

 

 *** Logon successfully completed.

 *** Teradata Database Release is 14.00.03.03

 *** Teradata Database Version is 14.00.03.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

call  TRANSFORM_GN(136914);

 *** Total elapsed time was 45 seconds.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

.LOGOFF

 *** You are now logged off from the DBC.

+---------+---------+---------+---------+---------+--- ------+---------+----

.EXIT

 *** Exiting BTEQ...

 *** RC (return code) = 8

BTEQ 14.00.00.05 Fri Aug 30 00:53:41 2013

 

bahadirbabacan 2 posts Joined 06/12
31 Aug 2013

When I queried from qrylog table for error code, it gave partition violation error but we couldn't see the error in bteq session.

You must sign in to leave a comment.