Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
IQY reports in 11.1.1.7
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
Answers
-
User128178 - Oracle wrote:
We have increased the row limit in instanceconig.xml fileYou 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.
0 -
Chnaged the following parameter in instance config.xml to 400000
<DefaultRowsDisplayedInDownload>400000</DefaultRowsDisplayedInDownload>
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?
0 -
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
0 -
Only that one line? There is MUCH more you need to change!
https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG3262
0 -
Here is the error message
Error: Unable to open <Delta url>. Cannot download the information you requested.
0