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

Getting error Missing repository object

Received Response
11
Views
3
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Hello Experts,

We are facing and error while trying to open the report:-

State: HY000. Code: 42001. [nQSError: 42001] Missing repository object with ID=3003:10344. (HY000)

Issue:- During the development we have accidentally deleted the object from physical layer.

Due to which BMM and Presentation layer was inconsistent error.

We have backup of the repository and from there we have copied all the physical layer object and pasted in physical layer.

We have check the consistency and it passed without any error.

when we hosted the rpd its getting error out.

Any idea how to fix it or do I am missing something or Do i need to build all three layer from starch.

Any Advice will be really appreciated.

Thanks & Regards,

Abhi

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If you have a backup it should just be a case of revert to back up and go from there.

    Any other approach is to construct a potentially unknown position which may be error free but may not be correct.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    p.s. recovering physical layer would not work as business model would not automatically recreate the mappings that it has lost.

    You would have to recreate the physical to logical mappings also - but as I said I would not recommend trying to recover it by rebuilding, go back to your back up, it is safer and worth losing any work for a safe known position.

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hello Robert,

    I have created it from backup - no other option left .

    But it working now.

    Thanks for your help