My Oracle Support Banner

Error 'Unable to load schema information. Ensure that this connection is active' When Attempting to Create a Report with BI Publisher (Doc ID 2483800.1)

Last updated on OCTOBER 21, 2019

Applies to:

Primavera Unifier Cloud Service - Version 18.8 and later
BI Publisher (formerly XML Publisher) - Version 11.1.1.9.x and later
Information in this document applies to any platform.

Symptoms

When attempting to create a report with BI Publisher, he table details are not loaded in the Query Builder and the Catalog drop-down list is also empty, and the following error occurs.

Unable to load schema information. Ensure that this connection is active.

 

The issue can be reproduced at will with the following steps:

  1. Sign into BI Publisher.
  2. Go to Data Model.
  3. Click on Data Sets > Diagram > SQL Query.
  4. Select Data Source as UNIFIERSOURCE or XX and click the Query Builder button.
  5. Observe the reported issue.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.