table dropping
Posted: Tue Dec 21, 2010 7:47 am
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
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