following Technical Document has been published:
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)
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