I guess you may have also tried changing <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload> for pivot and table views? Our envs export over 500000.

try changing <ODBC> <ResultRowLimit>65000</ResultRowLimit> </ODBC> to a higher value in your instanceconfig.xml. if you have all the other parameters changed.

Thanks Christian/Gainni, While the implementation was not consistent in 11g, the utility can't be denied. This limited answers access helps users share reports, they have been doing so in 11g with ease. These are not published reports, Power users would create reports and share particular information from their Areas with…

You can keep the file anywhere you prefer, as long as you mention the full path in the instanceconfig.xml file. I have it share the same folder as the instanceconfig.xml. <CustomLinks> <Enabled>true</Enabled> <filePath>/obiadv1/u01/Oracle/config/domains/bi/config/fmwconfig/biconfig/OBIPS/customlinks.xml</filePath>…

We had a couple of long running reports, WHen the user tries to export the same, it used to timeout after 10 Mins. You would see the broken pipe error message in the javahost log. increased the timeout the 3600 and things were back to normal. Default is 360.