Large volume data - WebI document fails

[Former Member]

Hi,

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.

Regards,

VJ

[Former Member]

Hi Vijay,

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:

Launch CMC

Select Servers

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.

Thanks

Sukanya

[Former Member]

Hi,

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.

4.Click Apply.

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:

MAX_HEAP_SIZE=<java_heap_size_for_app_server>

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.

Regards,

Sarbhjeet Kaur

[Former Member]

Thanks for your reply.

I tried changing all the settings you recommended but it's not fixed.

FYI, the document is not failing but showing partial data ie the summary report shows the total without the detail rows.

While running this, i noticed the WebIreport server service utilized 1.7GB memory as it was working with very large volume data.

Any clue?

Regards,

VJ.

[Former Member]

Hi Vijay,

For testing purpose could you please verify the following settings.

1.Open the webi report and right click on the tab.

2.Go to document properties and under enhanced viewing disable this option if it is checked.

3.Try to use filter and prompts in the report to get the sepcific data as the report is tooo big.

4.Try to add one more webi report server and increase the memory settings which I have already provided to you.

Also apply the following settings on the server side and test the issue.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings

To do this, follow these steps:

1.Click Start, click Run, type regedit, and then click OK.

2.Locate and then click the following key in the registry:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings

3.On the Edit menu, point to New, and then click DWORD Value.

4.Type KeepAliveTimeout, and then press ENTER.

5.On the Edit menu, click Modify.

6.Type the appropriate time-out value (in milliseconds), and then click OK. For example, to set the time-out value 6000000000.

7. Restart Internet Explorer.

I hope this will help you.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

Could you please tell me the path of webi.properties file for websphere deployment

"If using a Tomcat deployment, the file is usually stored in...\webapps\businessobjects\enterprise115\desktoplaunch\WEB-INF\classes. "

Thanks,

Dharam

Edited by: Dharmender Singh on Oct 16, 2009 10:44 AM

[Former Member]

Hi,

Generally Partial Results warning comes when you restrict the records to a particular no and actual records are more than the restricted no. In Universe parameters-> in SQL -> default no of records are restricted 10,000 (Assume) and but when the query fired at database which in turn results in a 1,00,000 then while displaying data we will get this warning. We can also restrict the no.of records in reporting level also. In DeskI we can restrict in query panel and also using filters/prompts.

I think in your case check whether any filter/prompt is applied in query panel which may restrict the records.

Cheers,

Suresh Aluri.

[Former Member]

Hi Vijay,

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:

Launch CMC

Select Servers

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.

Thanks

Sukanya