Archives of the TeradataForum

Message Posted: Tue, 03 Jul 2007 @ 14:37:13 GMT

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

<-- Anonymously Posted: Tuesday, July 03, 2007 08:04 -->

Hi,

We have teradata load jobs execeuting simultaneously with same userid ?through informatica. we have a teradata stored procedures? in every table load job to track the? begingig and ending?execution ?times ?in to teradata table.

Some times we are getting error message in informatica session log like

     MAPPING> TE_7022 TShmWriter: Initialized

     MAPPING> TM_6007 DTM initialized successfully for session
     s_m_shm_shmt_addl_ref_142]

     MASTER> PETL_24004 Starting pre-session tasks.

     PRE-SESS> Mon Jul 02 10:12:49 2007

     PRE-SESS> CMN_1022 Database driver error...

     PRE-SESS> Mon Jul 02 10:12:49 2007

     PRE-SESS> TM_6182 An error occurred while connecting to [c_dba01_b1e1]
     for stored procedure [DBAPR001(SHMDBP10,SHMTB142,SHM0001.US000,TP)].

     MASTER> PETL_24026 Pre-session task completed with failure.

Is any one got this type of issue any knowledge share appreciated

Thanks

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