I have a webI document which runs fine computes all the formula properly for one month data. It is just a 3 page summary report
but if i query for 4 months data, it is not doing the formula part but the same document works fine for less data. Where do i change the server settings? Should i need to do anything with the Cache server or page server?
The volume of data returned from backend would be around 40 million rows and then the document will compute few formula to give the summary page.
Lauch Designer and import the universe on which problematic report created.
Refresh the structure and save universe.
Go to File>Parameters
Select the Controls tab and uncheck options "Limit execution time" and "Limit on result set".
Go to Defination tab and click on Edit>Next.
Select "Disconnect after each transaction" for connection pool.
Click on Apply and Ok
Save universe and Export to repository.
Test the issue.
If getting partial results again
Open the webi report panel in edit mode and click on Edit Query.
uncheck the options "Max rows retrival time" and "Max rows to retrieve".
Run Query and test the issue.
Issue still experiencing:
Select Webintelligenceprocessing SErver, right click and goto Properties
Maximum List Of Values Size (entries) default value is 50000.
Increase this value if your LOVS greater than this value.
Save and close.
Restart the server.
check whether value you changed applied or not after restarting the server.
Test the issue in fresh infoview window.
Hope this will resolves the issue.
Could you please apply the following settinsg to resolve the issue.
1) Go to start->All Programs->Tomcat-> Tomcat Configuration. Then under tomcat configuration go to tab "Java" and then change Maximum memory pool size to 1024 MB. Let me inform you that in webi.properties files it is calculated in bytes, whereas in Tomcat Configuration it is in MB.
Now you must change a parameter. The defined value for MAX_HEAP_SIZE in the webi.properties file must be increased to accommodate the size of the Java Heap size defined in the application server:
To resolve the error message, set the Java heap minimum -Xms to a value at least half the value of the maximum -Xmx value.
Here are the steps for Java Runtime Environment (JRE) 1.4.2.x:
1.Click Start > Settings > Control Panel > double-click Java Plug-in.
2.Click the Advanced tab.
3.Enter the following in the Java Runtime Parameters text box: -Xms 256 -Xmx 512.
5. Close the dialog box.
6. Restart tomcat.
1. Edit the webi.properties file in the WEB-INF/classes directory of the web application.
If using a Tomcat deployment, the file is usually stored in...\webapps\businessobjects\enterprise115\desktoplaunch\WEB-INF\classes.
2. Add the following line, if the line is not in the file, or comment it out and update the value as follows:
The value <java_heap_size_for_app_server> represents the number of bytes and must match the value set to in the application server. For example:
MAX_HEAP_SIZE=750000000 if you want to set 750MB
3. Save the file, and restart the application server.
Also log on to CMC and under Servers click on the WI ReportServer properties and change Max Binary File size and Max Character File size to 500 and 500 respectively.