Error in Teradata Enterprise Stage

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
nani1974
Premium Member
Premium Member
Posts: 52
Joined: Fri Aug 31, 2007 10:59 am

Error in Teradata Enterprise Stage

Post by nani1974 »

Hi,
I am getting the below error when i am running the change data capture job...
TeraEntp_ins: Error when checking operator: Table 'BUS_RETAIN_TRANS' does not exist! Cannot use append mode.
Transformer_36: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
TeraEntp_del: When checking operator: There will be some skew in the usage of the server because the number of players (18) is not evenly divided by the number of available nodes (4).
TeraEntp_ins: Error when checking operator: Cannot prepare target table.
My source is Seq Server and taget is Teradata where i am using two Enterprise stages for delete and insert after change capture and trasformer stages..table is there in the database but its saying table does not exist....
Thanks for you help
Kumar.
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Test your teredata connection from DataStage.

Check whether you entered the right database
You are the creator of your destiny - Swami Vivekananda
nani1974
Premium Member
Premium Member
Posts: 52
Joined: Fri Aug 31, 2007 10:59 am

Post by nani1974 »

Hi,
I checked everything, all the information is right, because i run the jobs with Mload stage before with same database,server and other settings.

Thanks
Kumar
mkkgupta
Premium Member
Premium Member
Posts: 17
Joined: Thu Jan 24, 2008 10:13 pm

Post by mkkgupta »

try writing to datasets and process your inserts/deletes in seperate job.
I think table lock maybe an issue.
or try adding sleep & tenacity
Regards
Kiran
Post Reply