teradata stage view data error

[scorpion]

hi all,
when i try to view data from Teradata stage after supplying necessary connection information,i am getting error like,


Error executing View Data commanad:

##F TTER 000000 23:54:53(004) <main_program>FatalError:
APT_TeraSync: could not create operator sync table


can any one direct me to resolve this?

thanx in advance

[ghila]

Hello,

This is a quite frequent question when using Teradata and DS EE. DS EE use and create a table named "terasync". So you need to use a user with CREATE TABLE rights. By default the terasync table is created on the database you use in your stage. But you can use the DataStage environment variables APT_TERA_SYNC_USER / APT_TERA_SYNC_PASSWORD / APT_TERA_SYNC_DATABASE in order to select a specific location.

Hope this will help.

Regards

Daniel

hi all,
when i try to view data from Teradata stage after supplying necessary connection information,i am getting error like,


Error executing View Data commanad:

##F TTER 000000 23:54:53(004) <main_program>FatalError:
APT_TeraSync: could not create operator sync table


can any one direct me to resolve this?

thanx in advance

[scorpion]

Hi Daniel,

Thanks for your quick reply.

But where can I find these parameters

(APT_TERA_SYNC_USER / APT_TERA_SYNC_PASSWORD / APT_TERA_SYNC_DATABASE )

Are they userdefined or system defined.I couldnt find it in the environment variable list.

Thanks,
Scorpion.

[ray.wurlod]

Search the Forum. You may need to add them, using the Administrator client.

[scorpion]

hi Ray/Daniel,

Thanks a lot for the response,i searched the forum and i found a related topic.can you please advise me whether the below mentioned variables are enough to define or any thing more i need to define?

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]

[scorpion]

can any one please respond !

[anujgarg]

can any one please respond !

Can we supply the dsn information for this table in different database or it needs to be created in teradata itself.

[kumar_s]

Not sure whether you have searched completely.
viewtopic.php?t=88142&highlight=APT_TER ... AEMON_PROG

[ghila]

I only use the followings:

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]

In our configuration ( I mean Teradata configuration), there is no need to configure the APT_TERA_SYNC_DAEMON_PROG in DataStage.
You can try first to connect to the database with that username using the Teradata BTEQ comand line tool. ( do a .LOGON db/user and then enter password, that would be enough for testing ). Be sure all is working well outside DataStage first.

Regards

Daniel

Not sure whether you have searched completely.
viewtopic.php?t=88142&highlight=APT_TER ... AEMON_PROG

[ray.wurlod]

can any one please respond !

Some of us sleep occasionally. You waited only one hour before posting the above. If you require urgent support, contact your support provider and sign up for a premium support program.