SOI Manager doesn't start

Document ID : KB000007244
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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