Error: APT_TeraSync: could not create operator sync table

cbres00 · Post by **cbres00** » Wed Nov 17, 2004 12:26 pm

I'm trying to use Row Generator to load a test table in Teradata.
I get this strange 'APT_TeraSync: could not create operator sync table' error message.

Any ideas on what this means??

We're on DS 7.1.

Regards,
Cathy

richdhan · Post by **richdhan** » Tue Nov 23, 2004 5:05 am

Hi Cathy,

In the Teradata API stage there is an option to specify the table name. Here you can specify the table name as Database_Name.Table_Name. I think this should solve your problem.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

yannish · Post by **yannish** » Tue Nov 23, 2004 6:19 am

Hi Cathy,

You stated that you have write priviledges on the target database - do you also have create priviledges? Teradata Enterprise stage creates terasync-table in the database to store basically the SQL statements you use and it seems that you don't have permissions to create that table.

Cheers,

Janne