How to get default rpd in OBIEE 12c

user12116294

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

cesar.advincula.o

Hello,

When you upload the RPD, its converted to XML, this xml is default-diff.xml (this xml is the current source of truth for your RPD) which is located in (yourDomainHome)/bidata/service_instance/(your service name)/metadata/datamodel/customizations/default/default-diff.xml, and you can download or upload using data-model-cmd.sh (unix) or data-model-cmd.cmd (windows), for the syntax and parameters to execute the download RPD command, check this link:

2 Before You Begin

And to check the results execution of your commands, there is 2 logs:

- bi-lcm=rest.log which is located in (your Oracle Home)/user_projects/domains/(domain name)/servers/bi_server1/logs

- bi-server1-diagnostics.log which is located in (your Oracle Home)/user_projects/domains/(domain name)/servers/bi_server1/logs

Hope this helps.

Andrew Fomin.

Hi Abhi,

That isn't a direct answer to your question, but it's much easier to use OBIEE SampleApp for learning and testing purposes. Sample App is a prebuild virtual machine with a database, OBIEE and a LOT of interesting samples.

You can download it here: OBIEE Samples

[Deleted User]

+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.

Joel

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?

Andrew Fomin.

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.