Forum Stats

  • 3,839,770 Users
  • 2,262,532 Discussions


Error opening discoverer workbooks after migration

Ragul Halan
Ragul Halan Member Posts: 116
edited Feb 21, 2017 3:40PM in Discoverer

Hi All,

we have an issue after migrating discoverer workbooks from one instance to another instance.

This is happening with only few workbooks and the rest are working fine, we are exporting and importing the entire business area and the workbooks during migration.

below is the error message that we are getting, everything is same in both the instance.

any help on this is really appreciated.






  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Feb 21, 2017 3:40PM

    No Discoverer version was provided. Some of the older versions were full of bugs in relation to Joins.

    The options selected during the import matter.  When two objects match, which option did you select:  Rename imported, Rename existing, Do not import, Refresh the object?  Please note Refresh does not remove existing items that are not present in the Import.  In other words, if things were deleted in the Source EUL, they are not removed in the Target EUL upon import.  Items that are being removed must be manually deleted.

    The error is clear the Join needed was not found.  Things to look at. 
    - Does the BA being imported contain a new Join?

    - Does the user opening the worksheet have access to the Business Area?  To the underlying data tables needed?  If this is Apps Mode (E-Business Suite), does the User/Responsibility have row level access to the field upon which the Join is based?
    - Is there a Join between two BAs?  If yes, it could be the Join is located in the other BA and not being imported.

    - Is the worksheet using items from a Complex Folder?  A folder that contains multiple items from other Folders.

This discussion has been closed.