"An error occurred loading the fields for the form" when running the Default Provisioning Form in RSA Identity Governance & Lifecycle
Originally Published: 2019-06-03
Article Number
Applies To
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
Issue
If debug is enabled, the below error is seen in the/home/oracle/wildfly-10.1.0.Final/standalone/log/aveksaServer.log
06/01/2018 10:53:50.158 WARN (default task-45) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 600, SQLState: 60000 06/01/2018 10:53:50.159 ERROR (default task-45) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-00600: internal error code, arguments: [xtyGetBindMD:ctxbposp], [], [], [], [], [], [], [], [], [], [], [] Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [xtyGetBindMD:ctxbposp], [], [], [], [], [], [], [], [], [], [], [] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
06/01/2018 10:53:50.162 ERROR (default task-45) [com.aveksa.gui.components.table.core.TableModel] Unable to get groups for table ProvisioningSuggestedAccessAllTypesTable java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [select * from (SELECT COUNT AS NUM_ROWS, APPLICATION_NAME FROM (select * from (select x.*, suggest.percentage from ( select 'ent' as ENTITLEMENT_TYPE, ent.id as ENTITLEMENT_ID, nvl( ent.ALT_NAME, RESOURCE_NAME || ' : ' || ACTION_NAME) as ENTITLEMENT_NAME, ent.SHORT_DESC as ENTITLEMENT_SHORT_DESC, ent.LONG_DESC as ENTITLEMENT_LONG_DESC, ent.URL_REF as ENTITLEMENT_URL_REF, (RESOURCE_NAME || ' : ' || ACTION_NAME) as ENTITLEMENT_RAW_NAME,
06/01/2018 10:53:50.162 ERROR (default task-45) [com.aveksa.gui.components.table.core.TableModel] Unable to get groups for table ProvisioningSuggestedAccessAllTypesTable java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [select * from (SELECT COUNT AS NUM_ROWS, APPLICATION_NAME FROM (select * from (select x.*, suggest.percentage from ( select 'ent' as ENTITLEMENT_TYPE, ent.id as ENTITLEMENT_ID, nvl( ent.ALT_NAME, RESOURCE_NAME || ' : ' || ACTION_NAME) as ENTITLEMENT_NAME, ent.SHORT_DESC as ENTITLEMENT_SHORT_DESC, ent.LONG_DESC as ENTITLEMENT_LONG_DESC, ent.URL_REF as ENTITLEMENT_URL_REF, (RESOURCE_NAME || ' : ' || ACTION_NAME) as ENTITLEMENT_RAW_NAME,
With no debug enabled, the /home/oracle/wildfly-10.1.0.Final/standalone/log/aveksaServer.log has the following error:
02/20/2019 10:46:19.814 ERROR (default task-388) [com.aveksa.gui.components.table.core.TableModel] Unable to get groups for table ProvisioningSuggestedAccessAllTypesTable
java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: org.hibernate.TransactionException: JDBC commit failed
Cause
Resolution
Workaround
Please take a valid database backup before running the workaround.
- Run the following query as user SYS:
ALTER SYSTEM RESET cursor_sharing scope=spfile;
- Restart the Oracle instance. This is necessary because changing the parameter does not take effect until a database restart.
- Test the form.
Notes
The purpose of the CURSOR_SHARING=FORCE setting is required for Oracle 12c, it is needed to improve Oracle Optimizer CPU usage for statement parsing. So, setting it to the default EXACT value will affect Oracle performance and might become noticeable under load when CPU resources are depleted.
