Thought I'd share my first learning experience with BI Publisher in case anyone
else runs into the same issue.
We recently began moving db backups to recently-purchased ZDLRAs and in the
process Oracle recommended setting up a few custom BI reports for the RA
(2247391.1 and 2247392.1). I'm new to BI so I followed the instructions
closely and gave them a shot. Both failed immediately with:
oracle.xdo.servlet.CreateException: oracle.xdo.servlet.CreateException:
oracle.xdo.servlet.CreateException: oracle.xdo.servlet.CreateException: Data
Model definition not found:/~sysman/ZDLRA - NEW BI REPORTS (Wave2)/....xdm
It looked like something was hardcoded wrong or just didn't get updated in the
process, so I opened an SR since I knew nothing about BI. Oracle had me
increase BI memory parameters a few times, then gave up and sent the issue to
development as a bug. Today I got tired of waiting so I poked around and found
each report has a file like "$EM_HOME/.../bipublisher/repository/.../<report
name>/_report.xdo". Within this file is a line like:
<dataModel url="/~sysman/ZDLRA - NEW BI REPORTS (Wave2)/Recovery Appliance
Active Incidents.xdm"/>
I compared with this "_report.xdo" for other BI reports and found what the
correct path should be in our env, updated the "_report.xdo" files and now the
reports work fine. The correct value is:
<dataModel url="/Enterprise Manager Cloud Control/EM_Datamodels/Recovery
Appliance Active Incidents.xdm"/>
Kind of funny that this wasn't obvious to Oracle immediately because the
instructions explicitly say to upload the first file into the "EM_Datamodels"
directory.
HTH.
Regards,
Dave