Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Facing issue while try to use Explore as Workbook option from classic for any DV views

Accepted answer
79
Views
6
Comments
Senthilkumar Subramaniam
Senthilkumar Subramaniam Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Hi ,

This is happening or observed after the recent July 2024 update, all the DV views referred or used in classic dashboard is throwing error like "Failed to load workbook from specified path" when using "Explore as Workbook" option.

Though I see a Oracle SR raised for similar error for Retail Science Platform, does anyone facing same error?

Can we have a clear documentation with steps ,as suggested one seems not working or not clear enough to follow. Attached the error I see from our classic DB after clicking on 'Explore As Workbook' option.

Failed to load DV view error.png

clicking on 'Explore As Workbook' option.

Reference: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=458256469700359&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2928462.1&_afrWindowMode=0&_adf.ctrl-state=18we1odlh7_53

Tagged:

Best Answer

  • SteveF-Oracle
    SteveF-Oracle Mod
    Answer ✓

    Hi @Senthilkumar Subramanian

    Thanks for sharing your workaround.
    I think this may possibly be related to an internal bug (35908231) which is resolved in a future update release.
    If you need to pursue it further, then I suggest you open a Service Request.

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Jul 26, 2024 3:49PM

    I just tested it, and it worked OK for me with July patching applied.

    6823918;OAS STACK PATCH BUNDLE 7.6.0.0.240710 (Patch 36823847)
    36814917;OAS BUNDLE PATCH 7.6.0.0.240708

    To expand upon the note Doc ID 2928462.1, you would need to have the correct application role to run a DV workbook. It sounds from your post, that it worked for you prior to patching?

  • Senthilkumar Subramaniam
    Senthilkumar Subramaniam Rank 5 - Community Champion

    Hi @SteveF-Oracle ,

    Patch you mentioned is for OAS ,is it applicable for OAC as well. Though the July 2024 patch already in place, and I can replicate same issue in all OAC environments (DEV/ TEST / UAT/ PROD).

    As per the solution Doc ID 2928462.1, can you please tell me does that <Tenant_ID>-BIContentAuthor role will suffice to be mapped to application role/user groups mapped to the catalog object?

    Can you give me some example with description here which is something working for you.

  • Senthilkumar Subramaniam
    Senthilkumar Subramaniam Rank 5 - Community Champion

    Hi @SteveF-Oracle - Not sure, just tried by renaming the existing DV object and repoint them in classic dashboard and after checking 'Explore As Workbook' and it worked.

  • SteveF-Oracle
    SteveF-Oracle Mod

    @Senthilkumar Subramanian

    Apologies, when you said July 2024 update, my mind automatically went to the recently published OAS CPU/Bundle patches.

    I should have asked which Analytics product you were using. In future, always include since we have multiple.

    For OAC, when you login with your user account to /ui/dv, can you create a DV workbook?

  • Senthilkumar Subramaniam
    Senthilkumar Subramaniam Rank 5 - Community Champion

    @SteveF-Oracle - To answer your question, YES , I can create DV views and able to login successfully into ui/dv. Being an administrator have access to create/edit/modify/delete etc., hence I expect this would work .

    For now, what I noticed is that by renaming the workbook and repoint the objects in the edit dashboard of classic section makes them work when we click on 'Explore As Workbook'.