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

Windows 2008 & 2012SOI 3.3 & 4.0

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 SAM Application Server" & "CA UCF Broker" services on SOI Manager 

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

6. Start UI services

7. Start Connector services one at a time