Page 1 of 1
teradata stage view data error
Posted: Mon Apr 03, 2006 10:09 pm
by 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
Re: teradata stage view data error
Posted: Mon Apr 03, 2006 11:48 pm
by 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
scorpion wrote: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
Posted: Tue Apr 04, 2006 12:28 am
by 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.
Posted: Tue Apr 04, 2006 1:47 am
by ray.wurlod
Search the Forum. You may need to add them, using the Administrator client.
Posted: Tue Apr 04, 2006 2:15 am
by 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]
Posted: Tue Apr 04, 2006 3:53 am
by scorpion
can any one please respond !
Posted: Tue Apr 04, 2006 4:25 am
by anujgarg
scorpion wrote: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.
Posted: Tue Apr 04, 2006 4:26 am
by kumar_s
Posted: Tue Apr 04, 2006 5:40 am
by 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
Posted: Tue Apr 04, 2006 2:41 pm
by ray.wurlod
scorpion wrote: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.