Upon logging to the Oracle Business Intelligence Application’s Configuration Manager system I was greeted with an error message stating the following: “Unable to access Oracle Data Integrator repository. You will not be able generate or execute load plans.”
Upon some triage I was able to determine a couple of possible root causes to my issue.
- Not using the BIAdmin user created during the install process, or, the BIAdmin user account was not created.
- Current session was initiated with a set of credentials that haven’t been granted the BIA_ADMINISTRATOR_DUTY role on weblogic security
- Additional roles are missing or not assigned to the credentials initiating the current session
After reviewing all possible options and confirming I am using a valid account with the proper roles and permissions I asked my system administrator to restart the server, this fixed my issue. I should have started there but at least I came out of the experience with a better understanding of the roles that control security in my installation of OBIA 11.1.1.7.0.
Last resort, if all else fails:
* Make sure after you have regenerated and moved the security files that the file odi.conf is updated to refer to jps-config-jse.xml.