Marketing Web service Exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

ravikanth | July 4, 2010

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.

Categories
Commerce Server 2009, commerce server 2007
Comments rss
Comments rss
Trackback
Trackback

« »

2 Responses to “Marketing Web service Exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM”

  1. Fernando Barros says:
    July 20, 2010 at 4:45 am

    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

    Reply
  2. Erwin Werkman says:
    July 30, 2010 at 7:03 am

    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

    Reply

Leave a Reply