Cluster Slow Login to Business Objects

[Former Member]

Hi there,

Linux deployment on XI 3.1

We have created a CMS cluster for 2 servers.

Logging into Infoview (or any BO app) takes over a minute.

When we run a tcp trace and analyse using wireshark, we can see 50 seconds of traffic between the 2 Business Obects servers in the cluster

Any thoughts?

James

[Former Member]

Final DNS solution sorted issue

[former_member142702]

Hi,

are the clocks of the two linux servers synchronized?

Can you please also check what happens if you shutdown (or just stop the SIA) one of the cluster members? Does this speed up the login process?

Regards,

Stratos

Edited by: Efstratios Karaivazoglou on Jun 6, 2009 12:07 PM

[Former Member]

Thanks for the response (especially on a Saturday)

I will be signing into the server later and I will look at both suggestions...

How would the clocks of the two linux servers not being synchronized cause a issue?

thanks & regards

James

[former_member142702]

Hi,

timestamps are used for accessing to the common repository. De-synced clocks may therefore cause additional internal communication overhead while the system is trying to syncronize its members.

Regards,

Stratos

[Former Member]

We synchronized the server clocks including the database server which holds the BO repository.

We still experienced the issue after this. We captured logs against the CMS

We can see a thread that appears to be the cause of the delay - this is attached below

You can see a delay of exactly 40 seconds (??) between the submission of the request to login and the submission of the MySQL query to the BO repository

Any thoughts?

James

2009/06/08 10:19:12.694|==| | |24562|1138568080| |||||||||||||||(sessionmgr.cpp:3056) CSessionMgr::AcceptLogonEx(logonPropertyBag:3&cY=172.18.192.208,8P&cZ=bo1,8P, inAuthMethod:secEnterprise) 2009/06/08 10:19:52.695|==| | |24562|1138568080| |||||||||||||||(MySQLStatement.cpp:257) ExecDirect: SQL: SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE (CMS_InfoObjects6.ObjName = 'O1MO!;B' AND (CMS_InfoObjects6.TypeID = 19 AND SI_PLUGIN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC 2009/06/08 10:19:52.695|==| | |24562|1138568080| |||||||||||||||(DatabaseSubsystem_impl.cpp:208) SQL executed on connection 1 (transaction 0): SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE (CMS_InfoObjects6.ObjName = 'O1MO!;B' AND (CMS_InfoObjects6.TypeID = 19 AND SI_PLUGIN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC 2009/06/08 10:19:52.696|==| | |24562|1138568080| |||||||||||||||(DatabaseSubsystem_impl.cpp:5933) DatabaseSubsystem::GetObjectIds: End: Count(1), Sql(SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE (CMS_InfoObjects6.ObjName = 'O1MO!;B' AND (CMS_InfoObjects6.TypeID = 19 AND SI_PLUGIN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC)

[former_member142702]

Hi James,

what happens if you stop the SIA on one of the servers? Is the login process still slow?

Regards,

Stratos

[Former Member]

HI Stratos,

yes , we stopped one server and login process was still slow...

James

[former_member142702]

Hi James,

I would suggest to open an SAP case about this. There are some reports (also in these forums) about similar behaviour of several BO XI 3.1 installations.

Regards,

Stratos

[Former Member]

We resolved it ourselves...

The DNS for the BO servers needed to have the name of the BO Cluster added to each of them and we pointed them at their own IPs..

James