I get the following error message when using a Teradata Enterprise stage.
"Fatal Error: APT_TeraSync: could not create operator sync table."
I am using a User defined SQL and am trying to select data from a view.
I am unable to figure out why I am getting this error. Appreciate and inputs/pointers.
Error: APT_TeraSync: could not create operator sync table
Moderators: chulett, rschirm, roy
i ran with the same problem. And here is the solution:bcarlson wrote:This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value
Brad.
1. if ur Read Method is set to "Table", and had specified the "Database" in Connection Category and had some privilige on the database.
I hadn't find the minium privilige set on the database required to avoid the error. In my situation, I created a new Database "odstest", and granted full privilige on it to the user. And the error msg disappeared.
2. or u can set Read Method to "User defined SQL", remove "Database" in Connection Category and fill it with sql statement like "select * from dwsdata.table".
Hope it works to u.
Thnx
josfar wrote:i ran with the same problem. And here is the solution:bcarlson wrote:This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value
Brad.
1. if ur Read Method is set to "Table", and had specified the "Database" in Connection Category and had some privilige on the database.
I hadn't find the minium privilige set on the database required to avoid the error. In my situation, I created a new Database "odstest", and granted full privilige on it to the user. And the error msg disappeared.
2. or u can set Read Method to "User defined SQL", remove "Database" in Connection Category and fill it with sql statement like "select * from dwsdata.table".
Hope it works to u.
Deepak