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 ?
APT_TeraSync: connecting to Teradata ?
Moderators: chulett, rschirm, roy
Re: APT_TeraSync: connecting to Teradata ?
Hi there,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 ?
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
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Teradata Enterprise Error while Inserting the rows in Target
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.
Kindly Provide your suggestion.
Thanks & Regards
Arjun Kumar
Arjun Kumar
Re: APT_TeraSync: connecting to Teradata ?
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"]
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]
quote="Trinity"]
Hi there,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 ?
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]
Thanks & Regards
Arjun Kumar
Arjun Kumar