teradata stage view data error
Moderators: chulett, rschirm, roy
teradata stage view data error
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
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
Thanx&Regards
scorpion
scorpion
Re: teradata stage view data error
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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]
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]
Thanx&Regards
scorpion
scorpion
Not sure whether you have searched completely.
viewtopic.php?t=88142&highlight=APT_TER ... AEMON_PROG
viewtopic.php?t=88142&highlight=APT_TER ... AEMON_PROG
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
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
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
kumar_s wrote:Not sure whether you have searched completely.
viewtopic.php?t=88142&highlight=APT_TER ... AEMON_PROG
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.scorpion wrote:can any one please respond !
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.