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

  • Applies to:
  • Helm 3

Resolution

Problem
 
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.)
 
Solution
 
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 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF