ODI-10163: This OPSS user biadmin has different GUID than the one found in Oracle Data Integrator repository

After cloning ODI , We got this issue while trying to login OBIA ODI repository.

ODI-10163: This OPSS user biadmin has different GUID than the one found in Oracle Data Integrator repository
oracle.odi.core.security.BadCredentialsException: ODI-10163: This OPSS user biadmin has different GUID than the one found in Oracle Data Integrator repository.
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:511)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:252)
at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:208)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:662)
WARNING JPS-00167 Invalid xml content was found. SchemaLocation: schemaLocation value = 'http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd' must have even number of URI's. Location: line 2 column 272.
ERROR odi.core.security.SecurityManager.createAuthenthication(subject) detected OPSS user:biadmin has different guid ODI repos. The guid of the opss user is:A6EA4DE0AB5211E6BFDE3BA100F88679, the guid in repos is:926E89702AD011E5AF4471E40A0748AE

Cause: After cloning instance weblogic ldap users GUID were changed but those were not updated in ODI repository.

Resolution: Update GUID in SNP_USER table for OPSS user and then regenerate cwallet.sso and jps-config-jse.xml and place them into your client machine

Update GUID in SNP_USER table

UPDATE SNP_USER SET GUID_EXTERNAL='A6EA4DE0AB5211E6BFDE3BA100F88679' WHERE WUSER_NAME='biadmin'

Regenerate/Update ODI security files

Connect middleware server and execute below command in putty

<Middleware>/Oracle_BI1/common/bin/wlst.sh <Middleware>/Oracle_BI1/bifoundation/install/createJPSArtifactsODI.py embedded --ADMIN_USER_NAME weblogic --DOMAIN_HOSTNAME <mention_host_name> --DOMAIN_PORT 7001 --DOMAIN_HOME_PATH <Middleware>/user_projects/domains/bifoundation_domain

On successful execution ,you will see regenerated/updated cwallet and jps-config-jse file at below Middleware server location

<Middleware>/user_projects/domains/bifoundation_domain/odi-client-config/embedded

copy those cwallet.sso and jps-config-jse.xml to your client odi bin location. Usually it is

C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi\bin


Restart odi_server1 from the weblogic console to make the changes effective.