DSXchange

I am attempting to both read and load to the same view of a table within a DataStage job, using Multiload and getting an error which DataStage gives as "APT_TeraSync: could not create operator sync table".


any ideas ?

hamzaqk wrote:I am attempting to both read and load to the same view of a table within a DataStage job, using Multiload and getting an error which DataStage gives as "APT_TeraSync: could not create operator sync table".


any ideas ?

Hi there,

while doing multiload datastage try to create temp tables , so if you have given DB_OPTION = "Database name" and the user dosen't have access to create the tables in that database , it will give you terasync error.

so you can try giving a databse name in which you have access or maybe use API stage if you donn have much huge no of records.

Trinity

try running the generated multiload script from os prompt, does it run successfully??

from the error message it i guess, you are using Teradata enterprise stage, not multiload stage..

Check that you have privileges to create the table in the temporary workspace (or wherever else you may have specified).

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there any parameter that exists which can point to a different database for creating work tables in Teradata Enterprise stage?

Kindly Provide your suggestion.

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there any parameter that exists which can point to a different database for creating work tables in Teradata Enterprise stage?[



quote="Trinity"]

hamzaqk wrote:I am attempting to both read and load to the same view of a table within a DataStage job, using Multiload and getting an error which DataStage gives as "APT_TeraSync: could not create operator sync table".


any ideas ?

Hi there,

while doing multiload datastage try to create temp tables , so if you have given DB_OPTION = "Database name" and the user dosen't have access to create the tables in that database , it will give you terasync error.

so you can try giving a databse name in which you have access or maybe use API stage if you donn have much huge no of records.

Trinity[/quote]