SQLSyntaxErrorException when clicking menu links
SQLSyntaxErrorException occurs when clicking menu links and does not generate SIB tables.
00000019 SibMessage E [ChordiantBusService:zeus01.000-ChordiantBusService] CWSIS0002E: 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.SQLSyntaxErrorException: ORA-01031: insufficient privileges
Steps to Reproduce
The Messaging Engine is not authorized to connect to its own datastore. When using Oracle for the Messaging Engine datastore, the SchemaName and the UserID specified in the Authentication Alias of the Data Source used by the Messaging Engine must be the same; if they are different, then, the UserID must have all the required privileges.
For more information, refer to:
ResolutionCorrect the Authentication Alias details for the Data Source used by the messaging engine.
Published October 6, 2017 - Updated October 8, 2020
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.