Search Engine: Elastic

Article ID: 3798, created on Feb 8, 2008, last review on Apr 18, 2012

  • Applies to:
  • Helm 3


When trying to alter dates in Helm (for instance, for Domain registrations), or when trying to view reports between certain date periods, you may receive similar errors to this:
2004-08-12 11:03:34 HELM:CDomainRegistration::UpdateDomainRegistrationEx Execution failed. SQL was:
UPDATE DomainRegistration
SET LastModified = CONVERT(DATETIME, '2004-08-12 11:03:34', 102) , DomainRegistrar  = 'MANUAL'
, Expires  = '2006-06-14'
, RegistrationStatus  = 0
 WHERE DomainRegistrationId = 366
(The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.)
This is an issue with SQL Server's date and language format. Go into Enterprise Manager in SQL and (using Query Analyser) run the following SQL command against the Helm database:
set dateformat ymd
This sets the format to the correct standard. Now, in order to make this take effect you need to change the default language to something completely different and then back again, otherwise SQL won't take hold of the new settings. To do this, run this statement against the Helm database:
sp_configure 'default language', 12
reconfigure with override
to set it to a different language, and then:
sp_configure 'default language', 0
reconfigure with override
to set it back. This should fix the issue.

110556ad4b9f1c73a3682661cd1dca89 152090ff5e9a05ea7e1cf0c248449638 3ef1f5f998c0dc182718a7fe4376f875

Email subscription for changes to this article
Save as PDF