Cisco Cisco MeetingTime Quick Setup Guide

Page of 766
Monitoring and Maintaining Cisco Unified MeetingPlace Web Conferencing
Checking Which Conferences Are Currently Running
7
 
To determine whether the time zones match, open the Web Conferencing log, called 
GWSIM_eventlog_XXX.txt, and search for the string “time zone”. 
If the time zones are the same, you will see a message similar to this: 
Information: CompareTimeZone: Time Zones are the same between Cisco Unified MeetingPlace 
Web Conferencing and Breeze. Cisco Unified MeetingPlace Web Conferencing: (GMT-08) Pacific 
Standard Time and Breeze: (GMT-08:00) Pacific Time (US)
If the time zones are not the same, the system logs an error and you see a message similar to this: 
MasterSvc Error: **** Time Zones are NOT matching between Cisco Unified MeetingPlace Web 
Conferencing and Breeze. Time Zone Offset-- Cisco Unified MeetingPlace Web Conferencing: 
GMT:+01 Breeze: GMT:-08 
To change the time zone, follow these instructions: 
Procedure 
Step 1
Stop the Cisco Unified MeetingPlace Web Conferencing master service on all Cisco Unified 
MeetingPlace Web Servers that use the same database. 
Step 2
Open the SQL Server Query Analyzer on the computer where the Web Conferencing SQL database is 
located by following these steps: 
a.
Select Start > Programs > Microsoft SQL Server > Query Analyzer
b.
In the SQL Server field, select (local)
c.
Select SQL Server authentication
d.
Enter the login name of “sa” and the password. 
e.
Select OK
Step 3
Select Query > Change Database
Step 4
Highlight the name of the slave database (such as MPWEB_XXXX_XXXX), and select OK
Step 5
Enter the following SQL string: 
select * from PPS_ENUM_TIME_ZONES 
Step 6
Select Execute Query
Step 7
Look through the time zone records and find your time zone ID from the TIME_ZONE_ID field. 
Step 8
Clear the command window by entering: 
UPDATE PPS_ACL_PREFERENCES SET TIME_ZONE_ID = < local_machine_timezone_id > 
where <local_machine>timezone_id> is the time zone ID of the local machine. 
Step 9
Select Execute Query
Step 10
Start the Cisco Unified MeetingPlace Web Conferencing service on all Cisco Unified MeetingPlace Web 
Servers.
Checking Which Conferences Are Currently Running
Complete this procedure as a debugging tool to check which conferences are currently running on the 
Web Server.