Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Informatica database driver error using teradata .
 
From:   Anomy Anom

<-- 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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016