table dropping

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
sunitha_cts
Participant
Posts: 98
Joined: Thu Feb 05, 2009 1:14 am
Location: visakhapatnam
Contact:

table dropping

Post by sunitha_cts »

Hi ,
we are loading some records from a dataset to a teradata stage.
At this point of time temp tables are created in teradata.
The job design is dataset ->transformer->teradatastage(write mode is truncate).
but the issue is job aborting and table dropped when data is loaded into the tablename1.
The log is as below
1)Operator terminated abnormally:runlocally did not return Apt_StatusOK

2)TERADATA write operator was run from a step which did not run to completion.The recovery which will take place depends on how far the write progressed.
teradata died before any recoverable work was completed automatic cleanup will be performed.The following tables will be deleted
Tablename1
Database.err_1128477747_1
database.err_1128477747_2

3)Terageneric query error:Request close failed:error code=305,Session return code =305,DBC return code=305,
DBC message:I:ER_MEMBLOCK(113)

Appreciatr your help.
Thanks
Sunitha
Post Reply