BI Publisher Reports Within the P6 Reports Folder Structure are Not Available; Expanding Folders Results in Logged Error: "Failure: Due to oracle.xdo.servlet.CreateException: Data Model definition not found:" (Doc ID 1551118.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2 1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a report within P6 (configured with BI Publisher), the Reports tab is available but the reports within the folder structure are not available; when running one of the same reports in BI Publisher as admin (the P6 user), the message in the web access log is:

javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReportDefinition Failure: Due to getAvailableValues for Parameter [p_project_id], oracle.xdo.servlet.data.DataException: [Hyperion][SQLServer JDBC Driver][SQLServer]Invalid object name 'p6project'.; Data source: P6SSRPT; Query: select id from p6project WHERE p6project.rpt_user_id = ? ORDER by id

Trying to view a report in the reports folder structure in P6 Web results in the following error in the WebAccess.html log file:

javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReportDefinition Failure: Due to oracle.xdo.servlet.CreateException: Data Model definition not found:/Activity Relationships.xdm

Note: Data Model definition name may vary

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