Tera Data APT_TeraSync Error

[anandkumarm]

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.

[leo_t_nice]

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

[yannish]

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

[l_homme_de_rio]

Hi,
Be really careful using TD
It s mandatory to add cnx option
Numbersessionsof players etc ...
All the best
L homme

[anandkumarm]

Thanks every one for the replies

[alisoviejo]

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

[joeyfan]

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

[alisoviejo]

What do you mean by created? so these are created at the project level?

[vinaymanchinila]

Got it !

[balu_garuda]

Hi,
Could you please elaborate on setting the SessionsPerPlayer and RequestedSessions options.

Thanks,
Balaji

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

[ray.wurlod]

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?

[npraveen]

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

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