Restituisci
-
Titolo
Error during AD sync: "The time zone parameter provided to AT TIME ZONE clause is invalid." -
Descrizione
After upgrading to version 9.2 an error may be encountered when attempting an Active Directory (AD) synchronization:
"[810143] Database error 9820: The time zone parameter '(UTC+01:00) Amsterdam, Berlin, Bern, Rom, Stockhol' provided to AT TIME ZONE clause is invalid.
[System.Data.SqlClient.SqlException] The time zone parameter '(UTC+01:00) Amsterdam, Berlin, Bern, Rom, Stockhol' provided to AT TIME ZONE clause is invalid." -
Causa
The time zone parameter is malformed. Defect ID 440606. -
Risoluzione
WORKAROUND
In Designer locate the configuration parameter QBM\DBServerProperties\TimeZoneInformation. It contains the invalid value. Set the value to 'W. Europe Standard Time'. Commit the change to database.
STATUS
Defect ID #440606 will be fixed in a future release of the product.