How to get default rpd in OBIEE 12c

Question

Hello Experts,

I have newly installed obiee12c in my local for learning, but somehow I mess up with my default rpd (liverpd), due to which when ever I am logging in my obiee12c it giving me error that

State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "Sample Sales Lite". (HY000)

My question is that can we get default rpd, or I have to reinstall.

Kindly help.

Thanks & Regards,

Abhi

Andrew Fomin. · Answer

Let's not leave the question unanswered.

It is possible to revert everything to the initial state using wlst and importServiceInstance command.

You can import $ORACLE_HOME/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar and restore Sample sales sample rpd and webcat.

Here is a good blog post about wlst and importServiceInstance: Welcome to OBIEE12c - using BI Application Archive (BAR) files - Red Stack Tech

Warning! WLST is extremely powerful. Be careful.

Joel Acha · Answer

As everyone else has said, lots of practice will prevent the occurrence of these type of issues. I don't believe there is a way that you can "get back" your repository. Have you looked at the Rpd to see if it is something you can fix?

[Deleted User] · Answer

+1 to Andrew. SampleApp is the way to start and once you begin to understand things then you can go off playing with your own environments.