In SAS Risk Governance Framework, problems might occur when you add a custom field to the User object. Specifically, the page with the custom field fails to load indefinitely.
When this issue occurs, the following error is reported in the <SASConfigFolder>/Lev1/Web/Logs/SASServer8_1/SASRiskGovernanceFrameworkMidTier.log file:
com.sas.oprisk.framework.server.persistence.PersistenceException: There was an error interacting with the database: ORA-00960: ambiguous column naming in select list
Caused by: java.sql.SQLSyntaxErrorException: ORA-00960: ambiguous column naming in select list
For example, if you add the x_MyUserCustomField custom field to the User table customization file and set this field to be sortable by adding the "orderBy" attribute in the customization file, the page fails to load.
This problem occurs only if you use the Oracle database for SAS Risk Governance Framework with a very specific User table customization, as described above.
To circumvent this issue, adjust the User table customization file to remove the “orderBy” attribute on the new custom field. Here an example of the suggested customization.