This content has been marked as final. Show 9 replies
Thanks. No need to apply the patch, completing the update process in the admin ui resolves the issue.
However, when I try to run a report, the default data source has to be edited...I change to valid/tested data source and hit save, the admin ui sits there 'saving' and never completes...thoughts?
I have restarted wl/soa/oim/bip...but not the oracle database.
Note to self...when creating the jdbc connection, you HAVE to use the name 'OIM JDBC' ... I was using a different name:
Data Source Name OIM JDBC
Connection String jdbc:oracle:thin:@host:port:sid
Username Username for a database schema user that has access to Oracle Identity Manager.
Password Password for user identified in the Username field.
Database Drive Class oracle.jdbc.driver.OracleDriver
And when you select create new jdbc connection, the default database drive class is different from the instructions above.
After making these changes, any new OIM report automatically used the OIM JDBC data source. Although, if I make a change to a report's properties/settings, it again goes into a saving hang state.
Plus, when I click 'Get XML Output' none of the reports produce any data...thoughts?
Anyone seen this error...getting it from Organizationa Details.xdo...when searching on any existing organization in OIM?
The report cannot be rendered because of an error, please contact the administrator.
oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
After applying p14088000 of BIP 22.214.171.124.0 on top of OIM 126.96.36.199.4, the reports and EM started working. I realize tihs configuration is not certified...and I may revert to BIP 188.8.131.52.0 which is certified on OIM 184.108.40.206.4.
Has anyone got an OIM report working that shows all the OIM Identities pulled from a resource on a specific day/range?
Special thanks to Kevin for pointing out that date fields must be populated.
I rolled back bip 220.127.116.11 and installed 18.104.22.168.3 and setup the OIM 22.214.171.124.4 reports shipped with BP04. The data source and reports are setup.
However, none of the Role or Resource reports bring any data into the reports, where all the User reports work fine.
Anyone find the reason why OOTB OIM BP04 Role/Resource reports do not produce any data?
For example, running the user report shows users with the AD User resource assigned, yet running the Resource report return No Data.
Anyone with BIP 126.96.36.199.3 running with OIM 188.8.131.52.4 OIM reports have the Resource and Role reports working?
All the user reports work.
When I run any filter combination, no data is returned.
One issue is that the lookup table for the DBUM Role was successfully built, however, the UD_DB_ORA_R table is empty, I thought that was supposed to contain the roles from the lookup definition.
The answer is to open up the weblogic security schema for BIP and add a user account with the same name used to access OIM, then add the BI_Authors role. Save. Restart BIP. This got me the Resource Reports.
The DB Roles and Privs reports still don't work OOTB because the jobs don't update the UD_DB_ORA_P and _R tables. Still working on how to get that down. What's that...you know how...please do tell. Thanks :)