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

[OAS] Workbook Migration Issue

Accepted answer
27
Views
2
Comments
SaurabhJaiswal-Oracle
SaurabhJaiswal-Oracle Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

After copying the workbook from the old OAS instance to the new OAS instance, a popup prompts for credentials to access data from the dataset, even though the same dataset exists in both instances. I’ve observed that a new connection and dataset are being created, despite the same connection and dataset already existing in the new instance. The user used for migration has identical access in both instances. Has anyone encountered this issue before?

Best Answer

Answers

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    Hi @SaurabhJaiswal-Oracle ,

    Did you use the same user who created the dataset and the connection to export the workbook from the old instance, and import it into the new one? If you use a different user, then this issues are expected since the original owner name is part of the "true" object name.

    I recommend to export/import all datasets/connections using their original creator account, and then export/import workbooks using your own.