Tera Data APT_TeraSync Error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
Tera Data APT_TeraSync Error
Hi All,
When I am using teradata enterprise stage in PX. I am getting the following error
Fatal Error: APT_TeraSync: Could not create operator Sync Table.
Operating Sytem is Sun Solaris and we are using DataStage 7.1. Any help is appreciated.
Regards,
Anand.
When I am using teradata enterprise stage in PX. I am getting the following error
Fatal Error: APT_TeraSync: Could not create operator Sync Table.
Operating Sytem is Sun Solaris and we are using DataStage 7.1. Any help is appreciated.
Regards,
Anand.
-
- Participant
- Posts: 25
- Joined: Thu Oct 02, 2003 8:57 am
Hi
I think this is possibly due to the database name missing - if there is no explicit database named in teradata i think that it looks to the default "user" database.
Did you specify the database name in the TD enterprise stage? If not, in the stage, click on "Connection" and you will see "database" as an available property.
Hope this helps
L
I think this is possibly due to the database name missing - if there is no explicit database named in teradata i think that it looks to the default "user" database.
Did you specify the database name in the TD enterprise stage? If not, in the stage, click on "Connection" and you will see "database" as an available property.
Hope this helps
L
-
- Charter Member
- Posts: 23
- Joined: Mon Dec 29, 2003 7:38 am
- Location: Finland, Northern Europe
Hi Anand,
I suspect that you are using the Teradata Enterprise stage to read Teradata. I come across this problem myself few months ago and found out the following: When using TDE stage to read it creates a special terasync table to the source database and if you don't have create and write priviledges in that db you will encounter this error. The way to do it is to point TDE stage to write the terasync in an other place in the db where you have enough priviledges.
The way to do it is to set couple of env parameters:
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
Hope this helps.
Yours,
Janne
I suspect that you are using the Teradata Enterprise stage to read Teradata. I come across this problem myself few months ago and found out the following: When using TDE stage to read it creates a special terasync table to the source database and if you don't have create and write priviledges in that db you will encounter this error. The way to do it is to point TDE stage to write the terasync in an other place in the db where you have enough priviledges.
The way to do it is to set couple of env parameters:
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
Hope this helps.
Yours,
Janne
-
- Participant
- Posts: 17
- Joined: Fri Jul 30, 2004 1:16 am
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
Hi Guys,
We are on 7.5.1.A and I have run into the same issue and when I try to set the env variables below , I can not find them in our project ! Do we have to folow specific steps to add them to the project?
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
Thanks
We are on 7.5.1.A and I have run into the same issue and when I try to set the env variables below , I can not find them in our project ! Do we have to folow specific steps to add them to the project?
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
Thanks
ALISO
We use 7.5.1A as well. We had to add these as User Defined variables, even though they are referenced in the Ascential documentation. Once you add them, though, they work as advertised.
To add them to the available variable list go to the Job Properties button and select the Parameters tab. Click on the Add Environment Variables button then select New to open the form. Once they are created you can add them to your project.
Adam
To add them to the available variable list go to the Job Properties button and select the Parameters tab. Click on the Add Environment Variables button then select New to open the form. Once they are created you can add them to your project.
Adam
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 1
- Joined: Mon Feb 07, 2005 5:26 pm
Need more information on setting the SeesionsPerPlayer
Hi,
Could you please elaborate on setting the SessionsPerPlayer and RequestedSessions options.
Thanks,
Balaji
Could you please elaborate on setting the SessionsPerPlayer and RequestedSessions options.
Thanks,
Balaji
anandkumarm wrote:l_homme_de_rio wrote:Hi,
Be really careful using TD
It s mandatory to add cnx option
Numbersessionsof players etc ...
All the best
L homme
Thanks every one for the replies
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Your question is not really related to the topic of this thread. Would you please being a new thread, rather than hijack one that's already some years old?
Your question is not really related to the topic of this thread. Would you please being a new thread, rather than hijack one that's already some years old?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Missing parameters - APT_TeraSync: could not create
yannish,
I too have the same problems. As per your advise I checked the environment variables to set them but could not get the four variables in the environment variables list. Is it a user defined variable or Operator specific. Can you let me know how this variables can be added to the list. Once added we can put the values to the list.
thanks,
Praveen
I too have the same problems. As per your advise I checked the environment variables to set them but could not get the four variables in the environment variables list. Is it a user defined variable or Operator specific. Can you let me know how this variables can be added to the list. Once added we can put the values to the list.
thanks,
Praveen
yannish wrote:Hi Anand,
I suspect that you are using the Teradata Enterprise stage to read Teradata. I come across this problem myself few months ago and found out the following: When using TDE stage to read it creates a special terasync table to the source database and if you don't have create and write priviledges in that db you will encounter this error. The way to do it is to point TDE stage to write the terasync in an other place in the db where you have enough priviledges.
The way to do it is to set couple of env parameters:
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
Hope this helps.
Yours,
Janne