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

Technote (troubleshooting)


Problem(Abstract)

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.


Related information

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

Cross reference information
Segment Product Component Platform Version Edition
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 8.0.0.1, 8.0, 7.0 Standard

Product Alias/Synonym

WebSphere Application Server WAS SIB SIBUS SI BUS

Rate this page:

(0 users)Average rating

Add comments

Document information


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:

2012-11-20

Translate my page

Machine Translation

Content navigation