Hi, I am getting this error when we are running a job called Post load scripts In datastage. From routines we are calling the shellscripts then the Shells scripts calling thejavaclass followed by stored procedures SPs.
[03:29:43,221] Property 'backupdb.name' could not be found in any of the property files
[03:29:43,432] DAOException caught
com.ibm.nl.openweb.dao.DAOException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:366)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.call(C allableDBUtils.java:171)
at com.ibm.services.tools.citrus.tech.db.DbUtilsProxy .call(DbUtilsProxy.java:165)
at com.ibm.services.tools.citrus.tech.common.BatchDB2 DAOImpl.getSupportCentersForBatchNr(BatchDB2DAOImp l.java:92)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:149)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.processBatchApplication(POSta teControlBatch.java:221)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:299)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:255)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.main(POStateControlBatch.java :344)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:192)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java:423)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java:545)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Conne ction.java:428)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.ibm.nl.openweb.dao.jdbc.JDBCConnectionProvider .getConnection(JDBCConnectionProvider.java:69)
at com.ibm.nl.openweb.dao.jdbc.NamedParameterConnecti onProvider.getConnection(NamedParameterConnectionP rovider.java:36)
at com.ibm.nl.openweb.dao.jdbc.DBUtils.getConnection( DBUtils.java:75)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.getCon nection(CallableDBUtils.java:874)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:240)
... 8 more
[03:29:43,443] AGREEMENTMANAGER_ERROR
com.ibm.services.tools.citrus.tech.exceptions.Citr usFatalException: AGREEMENTMANAGER_ERROR
at com.ibm.services.tools.citrus.tech.common.CitrusEx ceptionHandlerImpl.handleDAOException(CitrusExcept ionHandlerImpl.java:103)
at com.ibm.services.tools.citrus.tech.common.CitrusEx ceptionHandlerImpl.handleDAOException(CitrusExcept ionHandlerImpl.java:280)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:154)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.processBatchApplication(POSta teControlBatch.java:221)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:299)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:255)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.main(POStateControlBatch.java :344)
Caused by: com.ibm.nl.openweb.dao.DAOException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:366)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.call(C allableDBUtils.java:171)
at com.ibm.services.tools.citrus.tech.db.DbUtilsProxy .call(DbUtilsProxy.java:165)
at com.ibm.services.tools.citrus.tech.common.BatchDB2 DAOImpl.getSupportCentersForBatchNr(BatchDB2DAOImp l.java:92)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:149)
... 4 more
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:192)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java:423)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java:545)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Conne ction.java:428)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.ibm.nl.openweb.dao.jdbc.JDBCConnectionProvider .getConnection(JDBCConnectionProvider.java:69)
at com.ibm.nl.openweb.dao.jdbc.NamedParameterConnecti onProvider.getConnection(NamedParameterConnectionP rovider.java:36)
at com.ibm.nl.openweb.dao.jdbc.DBUtils.getConnection( DBUtils.java:75)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.getCon nection(CallableDBUtils.java:874)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:240)
... 8 more
[03:29:43,621] AGREEMENTMANAGER_ERROR
[03:29:44,236] Property 'backupdb.name' could not be found in any of the property files
[03:29:44,401] DAOException caught
com.ibm.nl.openweb.dao.DAOException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:366)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.call(C allableDBUtils.java:171)
at com.ibm.services.tools.citrus.tech.db.DbUtilsProxy .call(DbUtilsProxy.java:165)
at com.ibm.services.tools.citrus.tech.common.BatchDB2 DAOImpl.getSupportCentersForBatchNr(BatchDB2DAOImp l.java:92)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:149)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.processBatchApplication(POSta teControlBatch.java:221)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:299)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:255)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.main(POStateControlBatch.java :344)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:192)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java:423)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java:545)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Conne ction.java:428)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.ibm.nl.openweb.dao.jdbc.JDBCConnectionProvider .getConnection(JDBCConnectionProvider.java:69)
at com.ibm.nl.openweb.dao.jdbc.NamedParameterConnecti onProvider.getConnection(NamedParameterConnectionP rovider.java:36)
at com.ibm.nl.openweb.dao.jdbc.DBUtils.getConnection( DBUtils.java:75)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.getCon nection(CallableDBUtils.java:874)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:240)
... 8 more
[03:29:44,412] AGREEMENTMANAGER_ERROR
com.ibm.services.tools.citrus.tech.exceptions.Citr usFatalException: AGREEMENTMANAGER_ERROR
at com.ibm.services.tools.citrus.tech.common.CitrusEx ceptionHandlerImpl.handleDAOException(CitrusExcept ionHandlerImpl.java:103)
at com.ibm.services.tools.citrus.tech.common.CitrusEx ceptionHandlerImpl.handleDAOException(CitrusExcept ionHandlerImpl.java:280)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:154)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.processBatchApplication(POSta teControlBatch.java:221)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:299)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.start(POStateControlBatch.jav a:255)
at com.ibm.services.tools.citrus.buss.agreement.batch .POStateControlBatch.main(POStateControlBatch.java :344)
Caused by: com.ibm.nl.openweb.dao.DAOException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:366)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.call(C allableDBUtils.java:171)
at com.ibm.services.tools.citrus.tech.db.DbUtilsProxy .call(DbUtilsProxy.java:165)
at com.ibm.services.tools.citrus.tech.common.BatchDB2 DAOImpl.getSupportCentersForBatchNr(BatchDB2DAOImp l.java:92)
at com.ibm.services.tools.citrus.buss.agreement.bs.Ag reementManagerBS.getCSCsForBatchNumber(AgreementMa nagerBS.java:149)
... 4 more
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:192)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java:423)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java:545)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Conne ction.java:428)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.ibm.nl.openweb.dao.jdbc.JDBCConnectionProvider .getConnection(JDBCConnectionProvider.java:69)
at com.ibm.nl.openweb.dao.jdbc.NamedParameterConnecti onProvider.getConnection(NamedParameterConnectionP rovider.java:36)
at com.ibm.nl.openweb.dao.jdbc.DBUtils.getConnection( DBUtils.java:75)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.getCon nection(CallableDBUtils.java:874)
at com.ibm.nl.openweb.dao.jdbc.CallableDBUtils.proces sCall(CallableDBUtils.java:240)
... 8 more
[03:29:44,576] AGREEMENTMANAGER_ERROR
i am unable to find the username and password used by this scripts.please help me