Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error during AD sync: "The time zone parameter provided to AT TIME ZONE clause is invalid."
설명
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."
원인
The time zone parameter is malformed. Defect ID 440606.
해결 방안
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.