BO4 - users experiencing freezing in WEBI

[former_member272336]

Hi,

Intermittently, users are reporting system freezing e.g in editing a report and cannot exit it/log off etc.

Similarly if hit Cancel nothing happens.

Sometimes alot of underlying database activity on the warehouse server on which the bo4 cms database sits.

How is it best to resolve this/stop it happening.

Checked the logs nothing obvious.

Thanks

[Former Member · Accepted solution]

Hello Philip,

Which application server your using?, Is this the same issue with all reports?, If the issue with some reports, try to run the report query on database and observer how long query is running on the database.

Regards,

Santosh

[former_member272336 · Accepted solution]

Hi All,

Thanks for responses.

Using BO4 SP5 with bundled Tomcat server Oracle 11.2.0.3 cms + audit database.

Supported JRE + IE versions - we ensure users use these.

cpu quite high usage on the warehouse server.   The cms database is hosted on the same server as the warehouse database.

Just an intermittent problem e.g when in editing data provider user can't hit cancel or any other button.

Most of time fine.

Thanks

[Former Member · Accepted solution]

Philip,

If the issue is happening on client work station browser then I would recommend below items.

1)     If you are running on IE 9 then I believe it support Java JRE 1.6 32 onwards so make sure Java JRE 1.7 is not installed

2)     Close all applications and browsers -- Go to Start - Run(if it is windows 7 then "search programs and files") and type %temp% - it will show all the temp files then delete all the files under folder which will release the memory of the system

3)     Go to start - Run and type prefetch (not available on windows 7) and delete all the content from prefetch folder

4)     If the 2 and 3 are not helpful then add the Run Time parameters for Java JRE version in control panel java option

-- If you experience the same issue on server browser also then I would recommend the below items

1)     Go to start - tomcat - tomcat configuration - under java change the "java options"  and maximum memory pool etc.,

Java options ex:

-Djava.library.path=C:\Windows\SysWOW64\;E:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\

-Dcatalina.base=E:\Program Files (x86)\SAP BusinessObjects\Tomcat6\

-Dcatalina.home=E:\Program Files (x86)\SAP BusinessObjects\Tomcat6\

-Djava.endorsed.dirs=E:\Program Files (x86)\SAP BusinessObjects\Tomcat6\common\endorsed\

-Dbobj.enterprise.home=E:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\

-Xrs

-XX:MaxPermSize=384M

-Dbusinessobjects.olap.bin=

-Dbusinessobjects.olap.stylesheets=

-Djava.awt.headless=true

If Mcafee on-access scanner service (mcshield.exe) kind of services are running on client machines which scan level is high then it scans every read/write(in/out) of data packet on the client and server machines which lags the application. So pelase make sure the on access scanner is not using high CPU on server and client machines

-- Gopal

[former_member272336 · Accepted solution]

Hi

Thanks for response

You raise an interesting point about macafee.

We  have it running - on my client machine have disabled for the idt/universe design tool etc

- is there a way to diasable it for browser sessions which accessing the infoview/launchpad website as need for security on other websites?

Many Thanks

[Former Member · Accepted solution]

Security team will help in disabling the On Access scanner on user machines and I don't see any option to disable on our own on user workstations.

[former_member272336 · Accepted solution]

Hi Goal,

No problem.

Thanks for reply.

Philip

[former_member191664 · Accepted solution]

" Intermittently, users are reporting system freezing e.g in editing a report and cannot exit it/log off etc."

If you are using the "Rich Internet Application" to edit a Webi report, you can add the -Xmx1024m -Xincgc to your JRE1.6.x, where

-Xmx<size>        set maximum Java heap size.  Note that 1024m is just an example, -Xmx848m (windows 2003) -Xmx664m (Windows XP), etc.  You'd need to adjust it to the highest size your PC OS is allowed.

-Xincgc           enable incremental garbage collection

Help this helps,

Jin-Chong

[former_member272336 · Accepted solution]

Hi,

Thanks or the tip.

Yes the more advice the better.

The quicker we can have the client perform the happier he users.

Thanks

[Former Member]

Hi,

if you use the iE8 or IE9 so please run it with the compatibility mode.

Best regards,

Mohamed AISSA

[former_member272336]

Hi,

Thanks for advice.

Why run in compatability mode - what does this acahive?

Thanks

[Former Member]

Hi,

We are also facing  exact issue and we suspect it could be with macafee. our users are using Browser and security team says cant disable fully but they can do exception for particular folders.

Do you know which folders / files need to be put in exception for macafee?

[Former Member]

Please find the below details of files and directories should be excluded from an antivirus scan for SAP BusinessObjects Business Intelligence Platform products

SAP BusinessObjects Business Intelligence 4.0:

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\logging

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\data

%INSTALLDIR%\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore

%INSTALLDIR%\SAP BusinessObjects\MSSQLSERVER2008

%INSTALLDIR%\SAP BusinessObjects\Tomcat6\bin

%INSTALLDIR%\SAP BusinessObjects\Tomcat6\webapps

%INSTALLDIR%\SAP BusinessObjects\Tomcat6\work

Below are the additional things for the cluster environment:

Input and output FRS if these are not in the default directories.

Webi Shared Document Cache (view properties of Web Intelligence Server for this information if it is set.)

please check the below SAP note as well to have complete details to know about antivirus exclusion

1497394 - Which files and directories should be excluded from an antivirus scan for SAP BusinessObjects Business Intelligence Platform products

[Former Member]

Hi Prasad,

Here i dont see anything related to client m/c - The user just using BI Launch pad.

We are looking for the details for the two scenerios.

1. Users just using BI LaunchPad with out installing client Locally

2. Users install the client tools locally.

Any idea? for #1 and #2 what should be excluded? I know for #2 we can exclude BO installation root folder itself but what about #1.

[Former Member]

please check the below two urls.

https://community.mcafee.com/thread/32741

https://kc.mcafee.com/corporate/index?page=content&id=KB65382

Hope they are helpful.

[Former Member]

Thanks Prasad. will be really helpful to work with our security team.

[former_member182521]

Philip,

Can you check with CPU and Memory utilization as well along with the above for compatibility?.

Regards,

Mani

[Former Member]

Philip,

BI Version with patch?

IE Version?

Java JRE version on client machine?

CMS/Audit DB information?

-- Gopal