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 FEBRUARY 17, 2021

Applies to:

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


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.




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

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