BI publisher errors - oracle.xdo.servlet.CreateException
Date: Thu, 6 Aug 2020 17:06:00 +0000
Message-ID: <CH2PR02MB666415F08F19D48254EC3111D4480_at_CH2PR02MB6664.namprd02.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 06 2020 - 19:06:00 CEST