Oracle error "ORA-06550" when running imrexport.bat

Document ID : KB000026661
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

We are getting the following errors when runing imrexport.bat:


[DEBUG]Inserting into imreport
[ERROR]Exception caught during insert into table imreport: ORA-06550: line 1, co
lumn 7:
PLS-00201: identifier 'INSERTINTOIMREPORT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

[ERROR]Failed to execute ExportObjCmd as report Id is NULL

 

Solution:

The CA documentation instructs the customer to create a "report_user" in the Oracle database and then run the script "ims_oracle_report.sql" to create database tables for the Identity Manager reports. This means that the "report_user" is the schema owner and has full access to the tables without using qualification. The documentation instructs the customer to use the "report_user" to run the "imrexport.bat "script. The imrexport.bat script is only intended to run using the "report_user".

The problem:

This customer has a strict policy to use application users (non schema owners) to access all data in the Oracle database. When the imrexport.bat program is run using an application user, the script does not work because this user does not have access to the tables or stored procedures.

Workaround:

You can use a workaround on the Oracle side to grant the needed access to the "application user". Create Oracle "public synonyms" that act as aliases to stored procedures and table names. Then use the "ims_oracle_report.sql" as a guide and created aliases for table names and stored procedures that would forward all request of &lttable_name> to &ltschema_owner>.&lttable_name>.

CA does not give specific instructions on how to create the public synonyms. Please see your Oracle DBA or the Oracle documentation for instructions.