Guest

Cisco Unified MeetingPlace

Field Notice: FA00181 - MPWeb Fails to Install on Windows Servers That Uses Non-US Date Format


May 26, 2004


Products Affected

Product

Comments

MeetingPlace Web

4.2.7

Problem Description

Note: This Field Notice is a legacy Latitude Field Notice that has been converted to the Cisco format so the information would remain available to their customers.

If the Windows servers' operating system (OS) is set up to use non-US date format, then MeetingPlace Web installation will fail with the following error:

Error -2147221262: [Microsoft][ODBC SQL Server Driver][SQL Server] The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. 
  • US date format is defined as M/d/yyyy

  • European date format typically is dd/MM/yyyyy

  • Japanese date format typically is yyyy/MM/dd

During the process of creating the database, mpweb passes to SQL server a date value which needs to be inserted into the SQL database. MPWeb gets this date value through a function call that returns the PCs' date. For example, in European date format of dd/MM/yyyy. However, SQL server, or in most cases, just the MSDE which is installed along with MPWeb expects a US date format in M/d/yyyy.

As you can see, if the OS is in European format and has a date of 27/08/2002, SQL server and MSDE will interpret the 27 as the month 27, which does not exist. As a result, SQLInstall will generate an out-of-range error message.

The same problem exists in Japanese environment because Windows default for Japanese region uses yyyy/MM/dd format.

Note:?You will not encounter this defect if you are somehow able to change the sa account to use a regional setting with the appropriate date format that matches the settings of your PC's date format. This can typically be accomplished if you have a full SQL Server and you use the Enterprise Manager to access the sa account. However, if you are installing MPWeb using the MSDE bundled with MPWeb, you will most likely have to perform the workaround as outlined in this document.

Problem Symptoms

Unable to install MPWeb on Windows servers located outside of the United States, particularly those countries that uses European Date format.

Workaround/Solution

WORKAROUND:

Set the OS to use US Regional settings before installing MPWeb. After installation, you can change it back to use your desired country/region settings

  1. Open Start > Settings > Control Panel > Regional Options

  2. Change to US settings - specifically, the date format should be M/dd/yyyy

  3. Reboot the Windows server

  4. Install MeetingPlace Web and reboot NT server

  5. Change Regional Options settings back to your desired country/region settings

  6. Reboot the Windows server

If you have already install MPWeb and the installation failed, do:

  1. Open Start > Settings > Control Panel > Regional Options

  2. Change to US settings - specifically, the date format should be M/dd/yyyy

  3. Reboot the Windows server

  4. Run SQLInstall.exe to create mpweb datebase

  5. Change Regional Options settings back to your desired country/region settings

  6. Reboot the Windows server

SOLUTION:

Fixed in the upcoming MPWeb 4.2.7 Patch Release.

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.