11G Report Data Source Showing " Undefined " In The Catalog Folders When Migrated From One Instance to Another (Doc ID 2018573.1)

Last updated on SEPTEMBER 02, 2015

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

After migrating a report from Test to Production, the " Undefined " error is observed.

The report runs fine without any issue, but the data source is shown as " Undefined " in a migrated target instance.

Changes

The DATA SOURCE name provided in the DATA MODEL of one instance is different from the other instance.

This can be reproduced with the following steps :-


Login to XMLP QA as Administrator
=======================================
Navigate to Catalog ==> Shared Folders ==>Custom Folder ==> Custom Reports

Select SML0016 report and click more ==> download Download the SML0016.xdoz in local directory Select SML0016 data source and click more ==> download Download the SML0016.xdmz in local directory

Login to XMLP PROD as Administrator
=======================================
Navigate to Catalog ==> Shared Folders ==>Custom Folder ==> Custom Reports

In the tasks section, click Upload and upload the files SML0016.xdoz and SML0016.xdmz . In both the cases check the box "Ovewrite existing files", note the "Upload Completed" message.

Select the SML0016 data source and click edit.

Modify the default data source to "PRODAPS" and save the data source. The data model status is good at this moment.

Login to the production server backend from putty.

Navigate to to the directory “/u01/oracle/obiee11/mwhome/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Reports/XXXXXX Folder/XXXXXX Reports/SML0016.xdm”

Edit the data model _datamodel.xdm file of the report and replace ICPQA with PRODAPS.

Save the changes and run the report. It still says that it has ICPQA as data source.

Go back to SMPL0016 data model on the application front end and while editing, it shows PRODAPS; refresh it and save it. Run the report and it runs.

Check the SML0016 data model and it has “Undefined” status.


 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms