OBIEE 12c 12.2.1.0.0 RPD upload creates default_diff.xml file

Question

Hello all,

While uploading the RPD(3MB) to server below path, it is creating a huge default_diff.xml(60MB) file under default folder. Live RPD size after upload is around 2 MB.  I tried some solutions found online such as removing the rpd and default_diff file from the path and start servers. then stop presentation services and upload rpd. But still same issue persists.

domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations

Gianni Ceresa · Answer

It's is created by the system. If OBIEE create the file, it isn't going to be an issue.

OBIEE doesn't go read the file every time you run a query, you aren't going to see a performance impact on that side.

As said: it's something fully managed by the system, you shouldn't even be there looking at what is created.

Or, likewise, you should also keep monitoring every tmp file created when executing queries etc. At least those could definitely have a performance impact if your model isn't ideal or some analysis are retrieving way more than needed.

Sunny86 · Answer

Dear Gianni,

Thanks a lot for the reply. It is creating a 60 MB file with the default diff file. Can it cause performance issues at a later stage or a crash?

Gianni Ceresa · Answer

And what is the issue?

If the issue is that a file is created in that folder, why are you even looking there?

In OBIEE 12c, the RPD isn't to be placed physically in a given folder on the server. There is a utility to download and upload the RPD and what the server does with it, isn't your business (that's why you paid a tool: so you don't have to care about these things).