DSXchange

Posted: **Mon Jul 02, 2007 12:05 pm**

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.

Posted: **Mon Jul 02, 2007 3:00 pm**

This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value

Brad.

Posted: **Tue Jul 10, 2007 2:19 am**

Hi,

I am also getting the same error. Can the original poster please provide the resolution to this issue.

Thanks in advance.

Posted: **Wed Jul 11, 2007 1:59 am**

bcarlson wrote:This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value

Brad.

i ran with the same problem. And here is the solution:
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.

Posted: **Tue Sep 18, 2007 7:48 am**

josfar wrote:
bcarlson wrote:This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value

Brad.
i ran with the same problem. And here is the solution:
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.

Posted: **Tue Sep 18, 2007 7:54 am**

??

Ok, now I see - the subject of this post is "Thnx". FYI- people can only see that when they reply so it's not really an effective technique. And please, you don't need to quote the whole dang message just to say 'Thanks'.