USERNAME AND/OR PASSWORD INVALID
Posted: Mon Sep 27, 2010 7:29 am
Hi All,
I have a issue, and i tried myself to trace the problem but it didn't work.
Issue:- I have a px job and have 3 environments(Dev, Test, Stage). Job running fine in Dev and Test, but it's keep on failing in Stage with below fatal error.
[IIS-CONN-DB2-000004] DB2 function SQLConnect failed: SQLSTATE = 08001: Native Error Code = -30,082: Msg = [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 644)
All the username and password are coming from environment and we don't have any acces to change in Test or Stage. If i pass coreect userid and password while trigggering individual job also i have the same issue.
And next i was imported the job into Dev environment and did the catalog to stage database and ran that job, still have the same issue. but if i run in dev or test, it's running fine.
At the last, i was redesigned a new job and whenever i run it also have the same problem.
Note:- Some other jobs poinitng to stage database are running fine with same credentilas.
I am almost sure that this is not the code issue. Please let me know is it issue with datastage environment or with database.
Thank u in Advance.
I have a issue, and i tried myself to trace the problem but it didn't work.
Issue:- I have a px job and have 3 environments(Dev, Test, Stage). Job running fine in Dev and Test, but it's keep on failing in Stage with below fatal error.
[IIS-CONN-DB2-000004] DB2 function SQLConnect failed: SQLSTATE = 08001: Native Error Code = -30,082: Msg = [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 644)
All the username and password are coming from environment and we don't have any acces to change in Test or Stage. If i pass coreect userid and password while trigggering individual job also i have the same issue.
And next i was imported the job into Dev environment and did the catalog to stage database and ran that job, still have the same issue. but if i run in dev or test, it's running fine.
At the last, i was redesigned a new job and whenever i run it also have the same problem.
Note:- Some other jobs poinitng to stage database are running fine with same credentilas.
I am almost sure that this is not the code issue. Please let me know is it issue with datastage environment or with database.
Thank u in Advance.