Archives of the TeradataForum

Message Posted: Wed, 25 May 2011 @ 09:19:45 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Failure while a job was trying to call a

From:		madhu.priya

Hi ,

We have encountered a failure while a job was trying to call a procedure and it failed with the below error message:

     call produser.get_error_table_details('TEMPDB', 'TEMPDB_APPSUP');

      *** Failure 3668 get_error_table_details:A table listed in the Dictionary
          is not present.
      *** Total elapsed time was 11 seconds.

To resolve the issue we just re-submitted the job which completed successfully:

     call produser.get_error_table_details('TEMPDB', 'TEMPDB_APPSUP');

      *** Procedure has been executed.
      *** Total elapsed time was 3 seconds.
     history.wip
     .

Please could anyone advise on the reason for the initial failure?

Regards,

Madhu