Last week, I faced typical issue when we are trying to approve marketing campaign item from Marketing manager. Our data center is in Europe and business team is sitting in USA. They started complaining that they can’t approve the marketing items from their box and in the server we found following exception in event log.
|
An exception occurred in the ‘MarketingWebService’ Web service. Exception details follow:
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)|
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.CommerceServer.Internal.Marketing.CampaignItemStorageManager.SetCampaignItemActiveStatusInTrans(Int32 campaignItemId, Boolean active, DateTime timestamp)
|
Seems to be strange but we found out that this exception is coming only when the business time is less than Europe time. After changing the business user timing from EST to Europe, the business tool started working fine. Root cause is yet to identify but in this post, I would like to convey the remedy to everyone.
If you like this post, please click on our sponsor advertisement.
July 4, 2010 | 
Author 
Posted in 
Hi Ravi,
I don’t know if you already know, but it’s an “resolved” issue. I had this problem with daylight saving time for Brazil.
http://support.microsoft.com/?scid=kb;en-us;974321&x=8&y=10
Regards,
Fernando
I ran into the same problem. What do you mean by business user timing?
When is Microsoft going to fix this?
Best regards,
Erwin Werkman
Aviva Solutions
The Netherlands