Commerce Server 2007 Integration Error

Hi,

         I am working on a module which deals with integration of CS07
with other LoB (like MS CRM) and we are building a PoC on that. I
tried to first extract the schema of Order Syatem and mapped some of
the fields with another schema using BizTalk 2006. I already have
configured the send and receive locations and started the application.
But when I place an order from CS website I get an exception. I do not
have any clue on the source of the error which I am getting. The order
is placed in the CSDB but it is not picked up by BT. The error details
are below: -


Failed submitting message to BizTalk.  Message: SqlDateTime overflow.
Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM..
Stack trace:    at
Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception
ex, SoapHttpClientProtocol serviceProxy)
   at
Microsoft.CommerceServer.Internal.Orders.OrderServiceProxy.AuthorizedInvoke(String
methodName, Object[] parameters)
   at
Microsoft.CommerceServer.Internal.Orders.OrderServiceProxy.SearchPurchaseOrdersWithCount(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
   at
Microsoft.CommerceServer.Adapter.Orders.OrdersReceiveEndpoint.GetOrderGuids(Cookie
commerceServerCookie, ArrayList& orderGroupIds)
   at
Microsoft.CommerceServer.Adapter.Orders.OrdersReceiveEndpoint.SubmitBatch().
_________________________________________________________________________________________

An exception occurred in the 'OrdersWebService' 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.

Server stack trace:
   at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
   at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
   at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value)
   at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime,
Byte cb)
   at System.Data.SqlClient.TdsParser.WriteValue(Object value,
MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32
offset, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Td***ecuteRPC(_SqlRPC[]
rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest
notificationRequest, TdsParserStateObject stateObj)
   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.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
   at
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
   at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at
Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String
connStr, String commandText, ArrayList sqlParamValues, Int32 timeout)
   at System.Runtime.Remoting.Messaging.Message.Dispatch(Object
target, Boolean fExecuteInContext)
   at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
   at
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg)
   at
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type)
   at
Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String
connStr, String commandText, ArrayList sqlParamValues, Int32 timeout)
   at
Microsoft.CommerceServer.Orders.DataManagement.OrderSearch.ExecuteSqlQuery(String
commandText, ArrayList valueList)
   at
Microsoft.CommerceServer.Orders.DataManagement.OrderSearch.ExecuteSearch(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
   at
Microsoft.CommerceServer.Orders.DataManagement.ServerOrderSystem.SearchPurchaseOrdersWithCount(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
   at
Microsoft.CommerceServer.Orders.WebService.OrdersWebService.SearchPurchaseOrdersWithCount(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)



Bidyut.