SOI Manager doesn't start

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

After restoring a last saved SAMStore DB backup, SOI manager & UI doesn't start and manager logs shows below exceptions...

 "ModelUpdates: Error invoking job (updateAttribute 0x12c00000000002 0x30006) :"

 "AlarmUpdates: Error invoking job" 

 "ModelUpdates: Error invoking job"

UI Manager debug page shows "Type Repository" & other components failed

Environment

SOI 4.2

Cause

Guidance 

Resolution

Please execute following steps in the same order to address this problem

1. Stop all services on all Connectors & Manager & UI 
2. Run below SQL queries against SAMStore Db

• delete from dbo.REG_CLUSTER_LOCK ; 
• delete from dbo.REG_LOG ; 
• delete from dbo.REG_RESOURCE ; 
• delete from dbo.REG_PATH; 
• delete from dbo.REG_RESOURCE_HISTORY ; 
• delete from dbo.REG_CONTENT ; 
• delete from dbo.REG_CONTENT_HISTORY ; 
• delete from dbo.REG_COMMENT ; 
• delete from dbo.REG_RESOURCE_COMMENT ; 
• delete from dbo.REG_RATING ; 
• delete from dbo.REG_RESOURCE_RATING ; 
• delete from dbo.REG_TAG ; 
• delete from dbo.REG_RESOURCE_TAG ; 
• delete from dbo.REG_RESOURCE_PROPERTY ; 
• delete from dbo.REG_PROPERTY ; 
• delete from dbo.REG_ASSOCIATION ; 
• delete from dbo.REG_SNAPSHOT ; 
• delete from dbo.UM_TENANT ; 
• delete from dbo.UM_USER_ROLE ; 
• delete from dbo.UM_USER ; 
• delete from dbo.UM_USER_ATTRIBUTE ; 
• delete from dbo.UM_ROLE ; 
• delete from dbo.UM_ROLE_PERMISSION ; 
• delete from dbo.UM_USER_PERMISSION ; 
• delete from dbo.UM_PERMISSION ; 
• delete from dbo.UM_CLAIM_BEHAVIOR; 
• delete from dbo.UM_CLAIM; 
• delete from dbo.UM_DIALECT; 
• delete from dbo.UM_PROFILE_CONFIG; 
• delete from dbo.UM_HYBRID_ROLE; 
• delete from dbo.UM_HYBRID_USER_ROLE; 

3. Run "Registryloader.bat" on SOI Manager (Path: \SOI\tomcat\registry) 

4. Start "CA SOI MQ Server", "CA SOI Application Server", "CA SOI UCF Broker" &  "CA SOI WSO2 Carbon" services on SOI Manager 

5. Check 'Triage Tests' on the Manager debug page, if Manager initialization completes, then start the remaining services on the Manager 

6. Start UI services

7. Start Connector services one at a time