"Data source reference ‘Datasource Name’ cannot be found. Please select a new data source reference" error when accessing Contract Management BI Publisher data model (Doc ID 1477481.1)

Last updated on JANUARY 25, 2017

Applies to:

Primavera Contract Management - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to edit a data model associated with a Contract Mangement report, form or letter template in BI Publisher user interface, the following error occurs:

Data source reference ‘data source name’ cannot be found.
Please select a new data source reference. 

The default Contract Management reports, forms, and letter templates do not have functional JDBCs associated with them, only placeholders to non-existant JDBCs.  This is due to two reasons:

  • Contract Management and BI Publisher integrate without the use of a JDBC connection.  
  • Every environment is different, so there is no way to create a JDBC configuration that would work in all environments.
Depending on which set of default reports you are using, the following error message may appear:
  • US Oracle: Data source reference CM_US_ORCL cannot be found. Please select a new data source reference.
  • US Sql: Data source reference CM_US_SQL cannot be found. Please select a new data source reference. 
  • UK Oracle: Data source reference CM_UK_ORCL cannot be found. Please select a new data source reference.
  • UK Sql: Data source reference CM_UK_SQL cannot be found. Please select a new data source reference. 

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