APT_TeraSync: could not create operator sync table

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
radarada
Participant
Posts: 17
Joined: Wed Jul 16, 2008 7:42 am

APT_TeraSync: could not create operator sync table

Post by radarada »

Ok I have read through all psotings on this subject and none of them appear to have my answer. Quick summary. We can pull the data from a server job no issues. We cannot pull using a parallel job. We have checked with the Teradata DBA and our user id has select access to the table we are accessing and our userid has the ability to create,update,insert,delete etc.. on our own id.

In the connection box of the stage we have values for the below...

Database....set to our userid (have tried this on and off same error)
Password...set to our password
User...set to our userid
Server...set to the teradata box we are connecting to
TeraSync Password...set to the same password (have tried this on and off same error)

Job also contains the below environment variables

APT_TERA_SYNC_DATABASE = username (or box name tried both)
APT_TERA_SYNC_USER = username
APT_TERA_SYNC_PASSWORD = password

What other issues would allow us to not be able to build the sync table?

thanks
throbinson
Charter Member
Charter Member
Posts: 299
Joined: Wed Nov 13, 2002 5:38 pm
Location: USA

Post by throbinson »

Can you create a table using another tool in the username database with the userid?
Post Reply