Page 1 of 1

Job failing with bulk update using TPT how to get log file

Posted: Tue Jan 27, 2009 11:34 pm
by pankajp123
Hi,

My Job failing with bulk update using Teradata connector stage with access method bulk and load option update "Caught unknown exception from runLocally()" thoygh data is getting inerted in the table. some time we are getting below problem.
Session Error
-----------------
tpt_target,0: ?? (IIS-CONN-TERA-005004; RDBMS code 304: CLI2: NOSESSION(304): Specified session does not exist.
SQL statement: INSERT INTO emp_testL(empno,empname,salary) VALUES(:empno,:empname,:salary); CC_TeraParallelTransporter; checkpoint; CC_TeraParallelTransporter.cpp; 1,674) .
How do we get log file when we use Teradata connector update load type where it load when we run job of datastage.

thanks and regards,
Pankaj Pathak

Posted: Wed Jan 28, 2009 3:57 am
by hamzaqk
there is no log file created with the TPT stage. Although the detailed information can be seen in the director log of the job. what is the number of maximum sessions and sleep defined in the stage?