IQY reports in 11.1.1.7

User128178 - Oracle · Apr 18, 2018 6:33AM

Customer is trying to dowlanload reports using IQY from answers advanced tab using Excel.

For large number of records EXcel is not opening and throwing an error message

After giving our username and password, the Microsoft Excel starts fetching data but eventually fails giving below error.

Error: Unable to open <Delta url>. Cannot download the information you requested.

We have increased the row limit in instanceconig.xml file

Using OBIEE 11.1.1.7 and excel 2013

[Deleted User] · Apr 18, 2018 6:55AM

User128178 - Oracle wrote:
We have increased the row limit in instanceconig.xml file

You have increased what to what setting? There are about 20 parameter in the instanceconfig which have to do with "rows". And many more which have an impact on the amount of columns, data etc.

Plus you also need to increase the JavaHost limits.

Please be precise on WHAT you're doing, WHAT you've done exactly etc.

User128178 - Oracle · Apr 20, 2018 2:21AM

Chnaged the following parameter in instance config.xml to 400000

This works fine with smaller number of records.

When my report has 11000 records it errors out

How do i increase the java host limits?

Martin van Donselaar · Apr 20, 2018 3:27AM

What is the Error Message? Hard to tell what's going on exactly without that.

Probably you need to check your javahost limits like Christian said: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=521982636075038&id=1595671.1

[Deleted User] · Apr 20, 2018 5:48AM

Only that one line? There is MUCH more you need to change!

https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG3262

User128178 - Oracle · Apr 20, 2018 5:56AM

Here is the error message

Error: Unable to open <Delta url>. Cannot download the information you requested.

Oracle Analytics Forum

Categories

IQY reports in 11.1.1.7

Answers