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.

Monday, April 11, 2011

Intro to back to work

I am starting this blog to note down the lessons learnt from my day to day IT work.. Mainly it will contain the troubleshooting steps for various technical errors I have seen during the course of my work.
Hopefully this steps will help you as well.