Guest

Cisco Unified MeetingPlace

Field Notice: Users May Experience Slowness When Accessing MeetingPlace Web and or Outlook


December 16, 2004


Products Affected

Products

Comments

MP Outlook

Versions Affected: 4.3.0.x and earlier

MP Web

Versions Affected: 4.3.0.246.4 and earlier. Fixed in 4.3.0.246.5

Problem Description

Access to MeetingPlace Web and or MeetingPlace Outlook may exhibit slowness, which can lead to blank pages or pages with errors. This issue can arise in all versions of MeetingPlace Web or Outlook.

This issue is most likely seen in the following types of deployments:

  1. MeetingPace Web/Outlook gateways that have been in service for a while.

  2. MeetingPace Web/Outlook services that have been stopped and started a great deal over the lifetime of its existence.

  3. Large MeetingPlace Web/Outlook deployments where registry NumSession has been increased from its default of 120 to a larger number.

Background

The Cisco MeetingPlace Agent Service (MPAgent) maintains a constant connection between the web conferencing server and the Cisco MeetingPlace Audio Server by creating and using sessions to handle and track all user connections. The information from these sessions is kept in the SQL database (mpweb.mdf) under the Session table and Session Data table. Whenever the MPAgent is stopped or restarted, the application is supposed to clean up the session tables prior to populating them with a new set of session information. Due to a syntax error in the SQL command, the table is not cleaned up and each stop and restart adds new information on sessions to the database. As a result, the Session tables get bigger and bigger over time. There are certain MeetingPlace Web and Outlook operations that trigger a table scan on the Session table and Session Data table. Since these two tables become very large (tens of thousands of rows or even hundreds of thousands of rows), a table scan takes a very long time and thus you begin to see slowness in MeetingPlace Web and or Outlook client-side response.

Problem Symptoms

Access to MeetingPlace Web and or MeetingPlace Outlook may exhibit slowness, which can lead to blank pages or pages with errors.

Workaround/Solution

VERIFICATION OF SESSION AND DATA SESSION ROWS

From a Command prompt, log in to osql: C:\> osql -U sa -P yoursapassword

1>use mpweb 
2>go 
1>select (1) from Session 
2>go 

The number of rows present in the tables will be displayed. Run the same commands, replacing Session with SessionData, to get the number of rows present in the SessionData table.

MANUAL REMOVAL OF SESSION AND DATA SESSION ROWS

If it is determined that there are too many database entries, the tables will need to be cleaned manually.

  1. To do this, first stop the MeetingPlace Web master service (if your SQL database is being shared by more than one MeetingPlace Web/Outlook, then you will need to shutdown MeetingPlace Web/Outlook services on all machines).

    Note:?Stopping the master service effectively stops all MeetingPlace Web services. The master service was introduced in Meeting Place 4.3. If the system is an earlier version of MeetingPlace Web/Outlook , each MeetingPlace service will have to be stopped manually.

  2. Then using osql, issue the following commands:

    From a Command prompt, log in to osql: C:\> osql -U sa -P yoursapassword

    1>use mpweb 
    2>go 
    1>delete Session 
    2>delete SessionData 
    3>go 
    

    This will delete all the rows in both tables.

  3. Restart all MeetingPlace Web/Outlook services.

For More Information

If you require further assistance, or if you have any further questions regarding this field notice, please contact the Cisco Systems Technical Assistance Center (TAC) by one of the following methods:

Receive Email Notification For New Field Notices

Product Alert Tool - Set up a profile to receive email updates about reliability, safety, network security, and end-of-sale issues for the Cisco products you specify.