My Oracle Support Banner

OBIEE 12c: Modifying an RPD under Source Control Management Updates Many XML Files and Causes Missing Navigation Space Errors (Doc ID 2267695.1)

Last updated on AUGUST 18, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


An OBIEE environment is being migrated to (on Linux).

In 11g, modifications to the RPD were done under Source Control Management (SCM) as per:

After the 11g RPD was migrated to 12c, the (migrated) RPD is being modified under the same SCM process using the client-side Admin Tool (on MS Windows).

Two issues are encountered when using SCM in OBIEE 12c:

1. The Commit step causes many XML files - for objects that are not related to the actual change - to be updated (content is removed).
    For example: Add one new static repository variable to the SampleApp.rpd and see the Commit step will update 75+ XML files related to Logical Tables etc.

2. Reports fail when the modified Repository is deployed / uploaded to the server-side OBIS.
    For example: Save the MDS XML Repository back to a binary Repository, perform a global Consistency Check (in the Admin Tool) and see no Errors are reported.
                      Upload the RPD to the Linux OBIEE server, and see reports now fail with the "[nQSError: 15002] Missing navigation space for subject area XXX" error.
                      Additionally, "[nQSError: 42004] Logical element XXX has no physical data link" errors are observed in the OBIS logs.


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.