Unable to startup the IS 7 With Oracle Rac DB

[asekawa]

Describe the issue:

Unable to startup the IS 7 With Oracle Rac DB , due to getting following error traces

[2024-06-03 16:34:28,216] []  INFO {org.opensaml.core.config.InitializationService} - Initializing OpenSAML using the Java Services API
[2024-06-03 16:34:52,144] [] ERROR {org.wso2.identity.apps.common.internal.AppsCommonServiceComponent} - Failed to activate identity apps common service component. org.wso2.carbon.identity.application.common.IdentityApplicationManagementException: Error occured while assigning administrator role to the admin user.
    at org.wso2.identity.apps.common.util.AppPortalUtils.initiatePortals(AppPortalUtils.java:343)
    at org.wso2.identity.apps.common.util.AppPortalUtils.initiatePortals(AppPortalUtils.java:267)

How to reproduce:

A guide to setup a oracle rac db and reproducing can be assist

Reference https://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:

[asekawa]

The above exception could be throwing from this function here

https://github.com/wso2/carbon-identity-framework/blob/0f850f34dcff73ebf76229a751d4ad6447415b85/components/role-mgt/org.wso2.carbon.identity.role.v2.mgt.core/src/main/java/org/wso2/carbon/identity/role/v2/mgt/core/dao/RoleDAOImpl.java#L210

[bhagyasakalanka]

Maybe Database tables or columns are missing in the oracle instance

[asekawa]

Maybe Database tables or columns are missing in the oracle instance

Executed DB scripts and using sqldeveloper and all the scripts were executed successfully without any issues.

[Xaldelare]

It s same problem on: Product version: IS 7 rc7, Database: postgres. OS: linux rocky 8

@asekawa your link reference target version 6 not 7.

but it work fine with H2.

[Xaldelare]

for me i tryed to put script in specifique schema. if i put all in public it work well.

[asekawa]

It s same problem on: Product version: IS 7 rc7, Database: postgres. OS: linux rocky 8

@asekawa your link reference target version 6 not 7.

but it work fine with H2.

Updated the reference version

[shanggeeth]

Closing this since the fix is delivered with https://github.com/wso2/carbon-identity-framework/pull/5796