Hi, All
I try to use Teradata Enterprise Stage to insert data, I set correct user name and password in job properties, also add user defined variables in DS Administrator Environment variable. I can compile this job without any problem. but while run, it aborted along with error message below :
Teradata_Enterprise_5: TeraSync:DB Call Error(success check) Info = 0, Code = 3003, Message = Invalid password.error code = 1
TeraSync:DB Call Error(success check) Info = 0, Code = 3003, Message = Invalid password. error code = 1
DBCAREA msg_txt: Completed successfully. CLI Error Message: Completed successfully.
APT_TeraSync::connect: connect (0) failed. server = " abc01", Default db = "PTEMP"
", user = "dummy1", password = "****"
I can log into Teradatabase using this user name and password. also, I ensure that I typed correct password in the job parameters.
Does anybody experience this problem before ? can anybody advice any solution ?
Thanks in advance
xli
Teradata_Enterprise issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Re: Teradata_Enterprise issue
Hi,
Try running the job with hardcoded Username,password in the stage rather than suppling it through Parameters.
Try running the job with hardcoded Username,password in the stage rather than suppling it through Parameters.
Sakthi
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
Re: Teradata_Enterprise issue
Hi, are u using correct database to log in to? We have a Property called Database in terada Enterprise to submit the database name? are u passing that value? Double check the parameters passed from the DSJobs. After checking all that try to view data by clicking on the view data in the Enterprise stage itself......Or else as was suggested, u can hardcode the values in UID n PWD fields and see whether u r able to view data before running the job......
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio