My Oracle Support Banner

Error While Loading Schema Objects In Query Builder (Doc ID 2728181.1)

Last updated on NOVEMBER 12, 2020

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

On : Oracle BI Publisher 12.2.1.3.0 version, Production environment.


Unable to load schema objects from Query Builder in data model.
Following message is seen.

ERROR
-----------------------
Could not load schema information. Please make sure that this connection is active.


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

1. Login to BI Publisher.
2. Click new from Home page and select 'Data Model'.
3. Click Data Source and select 'SQL Query'.
4. Click on 'Query Builder'. This opens the Query Builder interface and above mentioned message is seen.



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
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.