Web Intelligence rich client too slow

[Former Member]

Dear Friends,

I'm having issues with rich client 4.0 when starting the app and logging to the server, everything seems to go smoothly, but after selecting a universe, it takes +-1mn to see QueryPanel. I have tried installing SP04 but the issue remains and it did not help. I did change dynamics ports and assigned fixed ports to the servers and  all ports are allowed by firewall as far as our networking guys concerns, still after 1 mn I am able to connect but it seem not much to be happening on network trafic and CPU usage in this 1mn.

here below an example of rich client trace file,                    =====> Any help would be appreciated. Thnx in advance

---------------------------------------------------

trc file: "WebIRichClient_ncs.trc", trc level: 1, release: "720"

---------------------------------------------------

M 

M [Thr 788] Tue Jul 24 11:46:44 2012

M  [Thr 788] NCS trace timer thread is successfully triggered

M  [Thr 788] Trace dispatcher thread is successfully triggered

M  [Thr 788] NCS data timer thread is successfully triggered

M  [Thr 788] Data dispatcher thread is successfully triggered

M  [Thr 788] NCS library version 2.3.8 (unicode) loaded

M  [Thr 788] NCS_ProcInit API invoked

M 

M [Thr 4412] Tue Jul 24 11:46:49 2012

M  [Thr 4412] ***LOG Q0I=> NiBufIConnect: connection pending after 500ms: connect (10035: WSAEWOULDBLOCK: Resource temporarily unavailable) [nibuf.cpp 4634]

M  [Thr 4412] *** ERROR => NiBufIConnect: non-buffered connect pending after 500ms (hdl 1;127.0.0.1:59818) [nibuf.cpp    4645]

M  [Thr 4412] *** ERROR => NI raw handle failed to be initilized for the first time, connection to agent destination failed to be established  in agent 1 [ncsmtdatasen 136]

M 

M [Thr 2780] Tue Jul 24 11:47:45 2012

M  [Thr 2780] Performance or Resource Data Detected

M  [Thr 2780] *** ERROR => NI raw handle failed to be initilized for the first time, connection to agent destination failed to be established  in agent 1 [ncsmtdatasen 136]

M 

M [Thr 2780] Tue Jul 24 11:48:45 2012

M  [Thr 2780] Performance or Resource Data Detected

M 

M [Thr 2780] Tue Jul 24 11:49:46 2012

M  [Thr 2780] Performance or Resource Data Detected

M 

M [Thr 2780] Tue Jul 24 11:50:46 2012

M  [Thr 2780] Performance or Resource Data Detected

M 

M [Thr 2780] Tue Jul 24 11:51:46 2012

M  [Thr 2780] Performance or Resource Data Detected

[former_member188911]

what patch level are you on? please be sure to be on SP02 + patch 2.6 minimum,  2.18 suggested, or SP04

please notice also that we noticed such delays in presence of some antivirus software, by declaring as safe the webi rich client the performance improved dramatically

thanks

[Former Member]

Hi Simone,
Thnx for your reply,

As mentioned before, I'm currently on SP04 and no patches further.
Problem still remains after disabling our local Antivirus/Firewall.

Any other suggestion concerning this issue would be appreciated.

[former_member188911]

it seems that it has problems in the host resolution, try to add the host names  to the hosts file on the client side and try again

you may also wish to use a sniffer to see what is going on

You should also check the following:

is universe specific? 

how does behave with sample universes?

is user specific?

what happens with the administrator account?

check where the load is, client or server?

thanks

[Former Member]

Thnx Simone for your reply,
I did check your mentioned points without success, except sniffer what currently is difficult because of our complex landscape and security policies, but I will do this very soon if issue not solved,

I tried a few more times on another machine from the same image, the first attempts did go well without delay but then my 3th or 4th attempts felt into 1min delay again.

Rich client stays using 25% (1core) of resources and doing nothing.
Network traffic on the server shows me no activities during this minute and after 1min you see the client attempting to connect.

Is there any chance that rich client not installed as it should or has been damaged and reinstalling it could help ?

Any suggestions would be appreciated,
Thnx in advance.

[former_member188911]

you may wish to try reinstall the client tool however the messages in the trace logs point to some security issue preventing the client server dialog...

please check whether the CMS service has a declared request port and that port opened bidirectionally on the server and client, see the Administrator Guide for more details

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_bip_admin_en.pdf chapter

7.15 Configuring BI platform for firewalls  p.178

[Former Member]

Hi we are also facing very bad performance issues with Rich Client.

Can you please update us if you have solution.

Thanks.