Classic report with a DV dataset not working after migration due to ownership mismatch

Question

Hi , We have an OAC classic report in FDI which uses a DV dataset (Created using DV connection to ADW Schema table) . This dataset was created by USER1If you read the session log , each column from the table is reference in the format .

XSA('USER1'.'DW_X_AR_ALTYX_CASHREPORT_V')."DW_X_ALTYX_CASHREPORT_V"."ACCOUNT_NO_TEXT"

Now for PROD migration , we need to depend on USER2 , since USER1 does not have access. USER2 has completed migration and now the report fails . Editing the report also not possible , it throws the error (Panel Div 'idReport' not found in document).The linked dataset already exists in PROD , but it was migrated earlier by USER3 who no longer existsWhat is the recommended approach to overcome this failure  ?

How do i repoint the dataset in this report, considering that Edit report itself is failing ?

User_XF8Z3 · Answer

I know this post is a bit old, but I ran into a similar issue with some imported items and thought I’d share what worked for me.

We’re using Oracle Analytics Server (OAS) rather than OAC, so this may not apply in your case—but have you tried the Replace Text option under the More menu?

Here’s the official documentation: Search and Replace Text in Catalog Objects (OAS).

I recommend making a copy of your report first and testing the change there. Essentially, you can search for User1 and replace it with User2.

Deepa Mohan · Answer

Pic1.png

pic2.png

Deepa Mohan · Answer

Hi Sumanth ,

Thank you for the response .

The question is not really about changing ownership of catalog objects. We have already tried this and it doesnt help.

There is an object ID associated to each DV dataset and it is in the form of USERNAME.DATASETNAME .

. It refers to this object ID every time a query is run and this object ID remains the same even upon changing the ownership of the object . This is the reason the report fails when opened in another environment after migration.

Thanks,

Deepa