My Oracle Support Banner

OBIEE 12: Dashboards Objects Become Invalid And Show Yellow Triangle After RenameAccounts Command (Doc ID 2759122.1)

Last updated on MARCH 09, 2021

Applies to:

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

Symptoms


Some of the Dashboards Objects Become Invalid After RenameAccounts Command.

Command runs successfully but Dashboard objects don't work at all after that.

Objects do get new owner ( for example from test_1 to test_2)
but when logged in with the new user test_2, some of the Dashboard objects don't
work.

 

1. Create user test_1 and test_2

2. Assign BIServiceAdministrator roles to both the users.

3. Login as user test_1 and create reports and Dashboard prompt

4. Create Dashboards based on the above reports and Dashboards Prompts and
save under My Folders.

5. Similarly, create My Dashboard also based on same report and prompt.

6.

Create any text file having login credentials.

For example for this environment, create a file logindetails

7.

Run the following command:-

 After successful command, Now login as user "test_2" and it will be observed that all the objects ownership will be renamed to user test_2.

a. reports and prompts will work fine.
b. But None of the Dashboards will work. It will show Yellow Triangle icon there for the content inside the Dashboard when you edit the Dashboards as
shown in the screen shots attached.

 

 

Some of the objects may become invalid inside the Dashboard and show as Yellow triangle.

You don't have to recreate the dashboard but replace the analysis. It
can be resolved by drag and drop to replace the analysis or Find & Replace
function under administration.

 

 

 



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
References


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