TERADATA...what does it mean by DB option.
Posted: Tue Oct 30, 2007 10:16 pm
Hi all,
i have to extract the data from teradata and load into dataset.
It,s straight dumping of data from teradata to dataset. but i ahve facing one issue ..i am getting this error everytime i am running the job But same jobs ran well for last month.i ahve to run the jobs on monthly basis.
warning=Teradata_Enterprise_0: There will be some skew in the usage of the server because the number of players (1) is not evenly
divided by the number of available nodes ( 4).
Fatal error=Teradata_Enterprise_0: TeraSync:
DB Call Failure(success check) Info = 0, Code = 3153,
Message = TWM Workload violation: User Limit of 2 concurrent sessions,
For object NO_NOR_ANJALI, Regulation applies from 00:00 to 24:00error code = 1
TeraSync:DB Call Failure(success check) Info = 0, Code = 3153,
Message = TWM Workload violation: User Limit of 2 concurrent sessions, For object NO_NOR_ANJALI, Regulation applies from 00:00 to 24:00 error code = 1
DBCAREA msg_txt: Completed successfully. CLI Error Message: Completed successfully.
APT_TeraSync::connect: connect (0) failed. server = " manthan", Default db = "B_BusinessUser "
", user = "NO_NOR_ANJALI", password = "****"
some jobs error is=
main_program: Fatal Error:
APT_TeraSync: could not create operator sync table.
In DB option= user='NO_NOR_ANJALI',password='********',
SessionsPerPlayer=2,RequestedSessions=2
What does it mean by"SessionsPerPlayer=2,RequestedSessions=2"
that means i can ran singale job at one time...
Plz suggest me wht to do..
i have to extract the data from teradata and load into dataset.
It,s straight dumping of data from teradata to dataset. but i ahve facing one issue ..i am getting this error everytime i am running the job But same jobs ran well for last month.i ahve to run the jobs on monthly basis.
warning=Teradata_Enterprise_0: There will be some skew in the usage of the server because the number of players (1) is not evenly
divided by the number of available nodes ( 4).
Fatal error=Teradata_Enterprise_0: TeraSync:
DB Call Failure(success check) Info = 0, Code = 3153,
Message = TWM Workload violation: User Limit of 2 concurrent sessions,
For object NO_NOR_ANJALI, Regulation applies from 00:00 to 24:00error code = 1
TeraSync:DB Call Failure(success check) Info = 0, Code = 3153,
Message = TWM Workload violation: User Limit of 2 concurrent sessions, For object NO_NOR_ANJALI, Regulation applies from 00:00 to 24:00 error code = 1
DBCAREA msg_txt: Completed successfully. CLI Error Message: Completed successfully.
APT_TeraSync::connect: connect (0) failed. server = " manthan", Default db = "B_BusinessUser "
", user = "NO_NOR_ANJALI", password = "****"
some jobs error is=
main_program: Fatal Error:
APT_TeraSync: could not create operator sync table.
In DB option= user='NO_NOR_ANJALI',password='********',
SessionsPerPlayer=2,RequestedSessions=2
What does it mean by"SessionsPerPlayer=2,RequestedSessions=2"
that means i can ran singale job at one time...
Plz suggest me wht to do..