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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pankajp123
Premium Member
Premium Member
Posts: 6
Joined: Wed Mar 26, 2008 11:20 pm

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

Post 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
hi
hamzaqk
Participant
Posts: 249
Joined: Tue Apr 17, 2007 5:50 am
Location: islamabad

Post 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?
Teradata Certified Master V2R5
Post Reply