obiee 12.2.1.2 excel export issue (not instanceconfig.xml)

PiusV

Hi guys

Have a problem with obiee and excel export.

We've recently installed obiee version 12.2.1.2.0 and had some problems with migration (had it to do manually.... ).

All the stuff from instanceconfig is also in the new installation but with excel 2007 exports we have some problems. it always tells me that i need to talk to the admin (or i would like to have a look in the log but i do not know which would be the right log).

Could you advise me where i could change it so that the export for excel 2007 works correctly?

hopefully @Gianni Ceresa or @Christian Berg are online to give hints for the right log?

thanks in advance

Pius

Gianni Ceresa

Hi Pius,

How are the permissions? the 2007+ exports require the user to have access to its own personal folder as it's where temp file will be generated. So depending on security this can be an issue.

Other problems can depend on the size of what you try to export: so are you doing a database dump with Excel via OBIEE?

PiusV

thanks for your fast reply gianni!

permissions shouldnt be a problem because i use the admin-account and havent had to set it somewhere before

but i thinks its a bit big one... not that much but not only 200 rows.... need some assignment? do i have to set it somewhere else than in the instanceconfig.xml?

Gianni Ceresa

The export also bring into the equation java memory settings for javahost etc.

Ideally you must check the settings in all the components getting into the loop.

If you look on MOS there are documents about that and the tuning guide probably also cover that.

PiusV

ah thank you java host was it what i was looking for

will look around the MOS and search for my problem

edit: found the Doc 783892.1 which looks like my problem

do you have any recommendations to use as max memory used?

default we have 8192 and there i could play around

<XMLP>

<InputStreamLimitInKB>8192</InputStreamLimitInKB>

</XMLP>

Gianni Ceresa

Check this: https://blogs.oracle.com/proactivesupportepm/obiee-12c-infrastructure-tuning-guide

Follow the link to MOS and download the PDF.

Point 4.3 is about JavaHost and they talk about Excel exports.

But ... do not randomly apply everything because it's written. Always read the PDF first, compare with your use case and if it matches try it.

PiusV

thank you for the pdf-link, will have a look on that but with setting it to 0 (for testing purposes) it works

so it looks like it was a problem there....

thank you @Gianni Ceresa