IBM Support

Unable to access data store due to security reasons while starting Messaging Engine

Troubleshooting


Problem

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

Cause

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.

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Service Integration Technology","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB36","label":"IBM Automation"}},{"Product":{"code":"SSFKSJ","label":"WebSphere MQ"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Service Integration Technologies \/SIB","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux on Power"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"","label":"UNIX"}],"Version":"7.5;7.1;7.0;6.0","Edition":"Standard","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux pSeries"},{"code":"","label":"Linux\/x86"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.0.0.1;8.0;7.0","Edition":"Standard","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

WebSphere Application Server WAS SIB SIBUS SI BUS

Document Information

Modified date:
15 June 2018

UID

swg21610262