Error in table load

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
tvsuresh
Participant
Posts: 1
Joined: Thu Aug 13, 2009 3:01 am
Location: Chennai

Error in table load

Post by tvsuresh »

HI,

We are loading a table in our job from a sequential file.
Logic used in job: Seq file(Seq partitionin) -> Transformer(Auto Partitionin) -> DB2 Enterprise(DB2 Partitionin)
No routines used or no surrogate key generation done in this job.
The job ran fine in dev but the job failed in another env with the following error
"main_program: Internal Error: (k == numNodes): db2partutils.C: 773
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH"
We are using upsert SQL to load the table.

Can you please let me know how to resolve this issue?

Thanks
TVS
mgendy
Premium Member
Premium Member
Posts: 44
Joined: Thu Sep 10, 2009 5:30 am
Contact:

Post by mgendy »

How many records are read ? try to take sample od the file about 10 records , save them in a new file and then run your job on the sample data to check that the problem is not in number of records
Mohmmed Elgendy
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
Post Reply