Unable to startup the IS 5.11 With Oracle Rac DB[19c]

[asekawa]

Describe the issue:

Unable to startup the IS 5.11 With Oracle Rac DB [19c], due to getting following error traces

[2024-06-25 16:30:02,511] [] ERROR {org.wso2.carbon.identity.scim.common.internal.SCIMCommonComponent} - Error occurred while setting SCIM attributes for the Admin org.wso2.carbon.user.core.UserStoreException: Error in adding SCIM metadata to the admin in tenant domain: carbon.super How to reproduce:

is.docs.wso2.com/en/latest/deploy/configure/databases/carbon-database/change-to-oracle-rac Expected behavior:

Environment information (Please complete the following information; remove any unnecessary fields) :

• Product Version: [e.g., IS 5.10.0, IS 5.9.0]
• OS: [e.g., Windows, Linux, Mac]
• Database: [e.g., MySQL, H2]
• Userstore: [e.g., LDAP, JDBC]

---

Optional Fields

Related issues:

Suggested labels:

[ThaminduR]

This issue is occurring because there are some missing entries in the IDN_CLAIM and IDN_CLAIM_MAPPING tables. Further investigation is needed to determine why these entries were not added during the server startup.

Once the missing entries were added, the server started up, but there were still missing records in different tables, indicating data loss during the initial server startup.

A possible cause could be the connection being terminated abruptly due to the slowness of the database instance itself.