registryloader.bat fails when SAMStore is moved from one Server to another

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

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

Environment

SOI 4.0 SP2

Cause

After the following commands:

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

The Registryloader command fails with the 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.