Issue with 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
siva.dwhbi
Participant
Posts: 7
Joined: Tue Aug 23, 2011 11:39 am
Location: Chennai

Issue with Teradata Enterprise Stage

Post by siva.dwhbi »

Hi,

I am using Teradata enterprise stage to extract source data from two different views. A particular view used in the source query is being loaded by some other operation. In this situation, if we try to run the job it will abort. But during my last run, it throwed below fatal error but job got finished with warnings.
Idealy it should have aborted. I would like to know why it has happened and also how to abort thos job in case of the failure.
Error Message:

Code: Select all

APT_TeraReadOperator:DB Call Failure(success check) Info = 0, Code = 2652,  
Message = Operation not allowed: Table is being Loaded. 2,652. ExecuteImmediate failed for " Given Query". Error Code = 2652 2,652

DBCAREA msg_txt: Completed successfully.CLI Error Message: Completed successfully.
Any suggestions would be highly appreciated.thanks in advance
Sivakumar Ganesan
-----------------------
Chennai, TN,India
Post Reply