Unable to access data store due to security reasons while starting Messaging Engine
WebSphere Application Server (WAS) Messaging Engine is not starting and the following errors are thrown in the SystemOut.log:
CWSIS1501E, SQL30082N with database security error codes 08001 and -30,082.
WSIS0002E: The messaging engine encountered an exception while starting. Exception: com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data source has produced an
unexpected exception: java.sql.SQLException: SQL30082N Attempt to establish connection failed
with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
DSRA0010E: SQL State = 08001, Error Code = -30,082
UserID or password is incorrect.
Resolving the problem
Verify the component managed authentication alias. The authentication alias must contain a valid user name and password combination that has appropriate access privileges for the database. This alias can be specified for a data source definition, or for a messaging engine definition.
If specified at the messaging engine, you can find the authentication alias specification by performing the following steps in administrative console:
1. Select Service integration Buses. (Service integration -> Buses)
2. Click bus name.
3. Under Additional Properties, click Messaging engines. (on V8, Messaging Engines is under "Topology")
4. Click messaging engine name.
5. Under Additional Properties, click Data store. (on V8 Data store is named "Message store")
If specified at the data source, you can find the authentication alias specification by performing the following steps:
1. Select Resources -> JDBC providers.
2. Select proper scope.
3. Select JDBC provider from list.
4. Under Additional Properties, click Data sources.
5. Select data source name.
Data Store Connectivity Problems and Solutions
Data store life cycle
Data store tables
Diagnosing problems with data store exclusive access lo
Messaging engine troubleshooting tips
Bus member is removed and re-added to the same bus
|Business Integration||WebSphere MQ||Service Integration Technologies /SIB||AIX, HP-UX, Linux, Linux on Power, Solaris, Windows, UNIX||7.5, 7.1, 7.0, 6.0||Standard|
|Business Integration||WebSphere Service Registry and Repository||AIX, HP-UX, Linux, Linux pSeries, Linux/x86, Solaris, Windows||22.214.171.124, 8.0, 7.0||Standard|
WebSphere Application Server WAS SIB SIBUS SI BUS
More support for:
WebSphere Application Server
Service Integration Technology
Software version: 6.1, 7.0, 8.0, 8.5
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1610262
Modified date: 20 November 2012