SOI Tech Tip: registryloader.bat fails when SAMStore is moved from one Server to another

Document created by Britta_Hoffner Employee on Feb 15, 2017
Version 1Show Document
  • View in full screen mode

following Technical Document has been published:

 

Issue:

In SOI 4.0 SP2 after loading a SAMStore backup from another Server (problem occures also when SAMStore backup from the same server is loaded)

 

after the following steps:

 

Run DELETE FROM UM_USER_ROLE; DELETE FROM UM_USER; DELETE FROM REG_RESOURCE on the SAMStore DB

Run registryloader.bat from <SOI>/tomcat/registry folder on the MGR

Registryloader command fails with message:

2017-02-08 10:30:18,924 ERROR [SOICAT] ps.PersistentStorageWrapper$1.run(263) - Cannot establish Catalyst PersistenceService reference.
java.io.IOException: com.ca.ssa.registry.RegistryException: org.wso2.carbon.registry.core.secure.AuthorizationFailedException: Attempted to authenticate invalid user.
at com.ca.ssa.registry.protocol.registry.RegistryURLConnection.getInputStream(RegistryURLConnection.java:40)
at com.ca.ssa.sor.app.Bootstrap.boot(Bootstrap.java:73)

Environment:
SOI 4.0 SP2
Cause:

Run DELETE FROM UM_USER_ROLE; DELETE FROM UM_USER; DELETE FROM REG_RESOURCE on the SAMStore DB

Run registryloader.bat from <SOI>/tomcat/registry folder on the MGR

Registryloader command fails with message:

2017-02-08 10:30:18,924 ERROR [SOICAT] ps.PersistentStorageWrapper$1.run(263) - Cannot establish Catalyst PersistenceService reference.
java.io.IOException: com.ca.ssa.registry.RegistryException: org.wso2.carbon.registry.core.secure.AuthorizationFailedException: Attempted to authenticate invalid user.
at com.ca.ssa.registry.protocol.registry.RegistryURLConnection.getInputStream(RegistryURLConnection.java:40)
at com.ca.ssa.sor.app.Bootstrap.boot(Bootstrap.java:73)

Resolution:

1. Stop all services.

2. Execute below queries:

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

3. Execute following batch files:
C:\Program Files (x86)\CA\SOI\tomcat\registry\registryloader.bat
C:\Program Files (x86)\CA\SOI\tomcat\registry\registryupdater.bat

4. Start all Services.

 

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1484253.html

Attachments

    Outcomes