SOI unable start up application via UI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We're having an issue getting the application started by seeing the following via Debugging window. 

1)  Database connectivity showing 'Server is still initializing'

2) SA Manager Triage Test show the folllowing didn't pass:

Under Manager Base:  Database Connection, Type repository started, Type repository loaded, TopLevelService present, 

Manager Services: Escalation Service Started, ServiceDesk Service Started

 

Next the log shows the following:

2021-09-13 10:08:10,362 ERROR [Source=, Thread=SOICAT] ps.PersistentStorageWrapper - Cannot establish Catalyst PersistenceService reference. . java.io.IOException: com.ca.ssa.registry.RegistryException: java.lang.Exception: Error occurred while executing :   IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'REG_PATH_IND_BY_PATH_VALUE') DROP INDEX REG_PATH.REG_PATH_IND_BY_PATH_VALUE CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)	at com.ca.ssa.registry.protocol.registry.RegistryURLConnection.getInputStream(RegistryURLConnection.java:40)	at com.ca.ssa.sor.app.Bootstrap.boot(Bootstrap.java:73)	at com.ca.sam.manager.catalyst.ps.PersistentStorageWrapper$1.run(PersistentStorageWrapper.java:227)Caused by: com.ca.ssa.registry.RegistryException: java.lang.Exception: Error occurred while executing :   IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'REG_PATH_IND_BY_PATH_VALUE') DROP INDEX REG_PATH.REG_PATH_IND_BY_PATH_VALUE CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)	at com.ca.ssa.registry.JDBCWSO2Registry.getRemoteRegistry(JDBCWSO2Registry.java:71)	at com.ca.ssa.registry.JDBCWSO2Registry.getResourceAsInputStream(JDBCWSO2Registry.java:147)	at com.ca.ssa.registry.protocol.registry.RegistryURLConnection.getInputStream(RegistryURLConnection.java:36)	... 2 moreCaused by: java.lang.Exception: Error occurred while executing :   IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'REG_PATH_IND_BY_PATH_VALUE') DROP INDEX REG_PATH.REG_PATH_IND_BY_PATH_VALUE CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)	at org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:170)	at org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:323)	at org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)	at com.ca.ssa.registry.JDBCWSO2Registry.getRemoteRegistry(JDBCWSO2Registry.java:65)	... 4 moreCaused by: java.sql.SQLException: Cannot find the object "REG_PATH.REG_PATH_IND_BY_PATH_VALUE" because it does not exist or you do not have permissions.	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:636)	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)	at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)	at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)	at org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:140)	... 7 more

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Something happened to the user permission on SQL.

User needed db_owner role