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
APT_TeraSync: could not create operator sync table
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA