Friday, April 15, 2011

Datastage & Teradata Error

In one of my datastage job, we were using Teradata Enterprise stage and after running the job, we got following DS Log fatal error and job was aborted

"main_program: Fatal Error: APT_TeraSync: could not create operator sync table."

This was happening because we had not created Terasync table in the teradata databse which Teradata Enterprise stage was referring to.

If Terasync table is present in that database then we need to check if correct Database is mentioned in the connections or else it will try to take default database.

No comments:

Post a Comment