Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Installing or upgrading to vCenter Server 4.1 fails on a non-US English MSSQL with the error: ODBC error 22007 (1024737)

Symptoms

You may experience these issues if the the SQL Server Data Source was created using a non-US English localized installation:
  • Installing or upgrading to vCenter Server 4.1 fails
  • You see these errors for a German database:

    A database error occurred: "ODBC error: (22007) - [Microsoft][SQL Native Client][SQL Server]Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert außerhalb des gültigen Bereichs." is returned when executing SQL statement "

    INSERT INTO VPX_LIC_METADATA(LAST_SAMPLE_ID, LAST_SAMPLE_TIMESTAMP, RETAINED_SAMPLE_ID, RETAINED_SAMPLE_TIMESTAMP, GLOBAL_DIGEST, IS_STATE_VALID, WEEK_KEEP_COUNT)
                          VALUES(0, '1900-12-31 00:00:00', 0, '1900-12-31 00:00:00', NULL, 1, 208)"

    Produkt: VMware vCenter Server -- Fehler 25003.Setup konnte das vCenter Server-Repository nicht erstellen.
  • You see these errors for a French database:

    A database error occurred: "ODBC error: (22007) - [Microsoft][SQL Server Native Client 10.0][SQL Server]La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites." is returned when executing SQL statement "

    INSERT INTO VPX_LIC_METADATA(LAST_SAMPLE_ID, LAST_SAMPLE_TIMESTAMP, RETAINED_SAMPLE_ID, RETAINED_SAMPLE_TIMESTAMP, GLOBAL_DIGEST, IS_STATE_VALID, WEEK_KEEP_COUNT)
                          VALUES(0, '1900-12-31 00:00:00', 0, '1900-12-31 00:00:00', NULL, 1, 208)"

    La ressource de message est présente mais le message ne se trouve pas dans la table des chaînes ou des messages
  • You see these errors for a British English database:
A database error occurred: "ODBC error: (22007) - [Microsoft][SQL Native Client][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." is returned when executing SQL statement

INSERT INTO VPX_LIC_METADATA(LAST_SAMPLE_ID, LAST_SAMPLE_TIMESTAMP, RETAINED_SAMPLE_ID, RETAINED_SAMPLE_TIMESTAMP, GLOBAL_DIGEST, IS_STATE_VALID, WEEK_KEEP_COUNT)
                      VALUES(0, '1900-12-31 00:00:00', 0, '1900-12-31 00:00:00', NULL, 1, 208)

Product: VMware vCenter Server -- Error 25003.Setup failed to create the vCenter Server-Repository

  • You see these errors for a Spanish database:
A database error occurred: "ODBC error: (22007) - [Microsoft][SQL Native Client][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo." is returned when executing SQL statement "

INSERT INTO VPX_LIC_METADATA(LAST_SAMPLE_ID, LAST_SAMPLE_TIMESTAMP, RETAINED_SAMPLE_ID, RETAINED_SAMPLE_TIMESTAMP, GLOBAL_DIGEST, IS_STATE_VALID, WEEK_KEEP_COUNT)
                      VALUES(0, '1900-12-31 00:00:00', 0, '1900-12-31 00:00:00', NULL, 1, 208)

Resolution

This issue occurs because the database server fails to correctly convert the date/time string using the localized non-US English format.
 
This issue is resolved in vCenter 4.1 Update 1.

For vCenter Server 4.1, to workaround this issue, use an English MS SQL Server.
 
If you cannot use an English MS SQL Server, change the DSN settings for the vCenter Server database. 
 
To change the DSN settings for the vCenter Server database, in the DSN configuration wizard:
  1. Select Change the language of SQL Server system messages to and select English from the dropdown. 

    Note    : In German, the setting is Sprache der SQL Server-Systemmeldungen ändern auf: English.
  2. Deselect Perform translation for character data.

    Note: In German, the setting is Konvertierung für Zeichendaten ausführen.
  3. Deselect Use regional settings when outputting currency, numbers, dates and times.

    Note: In German, the setting is Ländereinstellungen bei der Anzeige von Währungs-, Zahlen-, Datums- und Zeitangaben verwenden.

Additional Information

For more information about configuring DSN settings, see Configure a SQL Server ODBC Connection in the ESX and vCenter Server Installation Guide.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 13 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 13 Ratings
Actions
KB: