nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Migrating an OTBI Dashboard to another instances gives error

Kavita Shah

I have an OTBI dashboard that is working in an instance. However when I migarte to another instance I get lot of SQL errorrs. Some ofthe errors are

Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25002: Definition dummy_view_link of type View Link Definition is not found. (HY000)

And I also have a big chunk of SQL given

What could be the reason for this error. Note: I also have a couple of columns that are calculated (formula based)

Regards,

Kavita

Find more posts tagged with

Dashboard

OTBI

Accepted answers

All comments

Dimple-Nagesh-Support-Oracle

Dear Kavitha,

Do you have DFF fields included in your analysis, if so can you try running this ESS job: "Import Oracle Fusion Data Extensions For Transactional Business Intelligence" and retest the flow

Steps : Navigator → Tools → Schedule Process → Drop down → Search → Import Oracle Fusion Data Extensions For Transactional Business Intelligence → ok → Submit.

Once completed and rerun the dashboard and test the flow.

Let me know if that helps.

Thanks,
Dimple N

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/23855/migrating-an-otbi-dashboard-to-another-instances-gives-error

These error mainly arise from missing DFF configuration in target environment when DFF attributes are used in your dashboard.

Can you please verify if all DFF's used in dashboard are correctly configured in Target environment?

Fusion OTBI: OTBI analysis failed with 'ADFService11G - JBO-25002: Definition dummy_view_link ' error (Doc ID 2758422.1)

Thanks.

Kavita Shah

Hello @Dimple-Nagesh-Support-Oracle ,

I do not have DFF in my dashboard. But I anyways had executed the mentioned ESS job. Still no luck. Issue remains

Regards,

Kavita

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61111#Comment_61111

Have you verified all the selected columns. filters etc? Some of the columns may be set to hidden at analysis level.

Thanks.

Dimple-Nagesh-Support-Oracle

Correct,
Please check for the custom attributes names in the analysis, make sure all custom attributes exists in the target pod as well and then test the flow.

Thanks,
Dimple N

Bhaskar Konar

Hi @Kavita Shah,

Please take a look into the following Oracle doc if you have not already, it might be useful.

https://support.oracle.com/knowledge/Oracle%20Cloud/2758422_1.html

Hope this help.

Cheers,

Dimple-Nagesh-Support-Oracle

Dear Kavitha,

I wanted to check if the issue has been resolved now.

Thanks,
Dimple N