Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Migrating an OTBI Dashboard to another instances gives error
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
Answers
-
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 N0 -
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.
0 -
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
0 -
Have you verified all the selected columns. filters etc? Some of the columns may be set to hidden at analysis level.
Thanks.
0 -
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 N0 -
Hi @Kavita Shah,
Please take a look into the following Oracle doc if you have not already, it might be useful.
Hope this help.
Cheers,
0 -
Dear Kavitha,
I wanted to check if the issue has been resolved now.
Thanks,
Dimple N0
