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.TryHandleWeb MethodException(Exception
ex, SoapHttpClientProtocol serviceProxy)
at
Microsoft.CommerceServer.Internal.Orders.OrderServ iceProxy.AuthorizedInvoke(String
methodName, Object[] parameters)
at
Microsoft.CommerceServer.Internal.Orders.OrderServ iceProxy.SearchPurchaseOrdersWithCount(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
at
Microsoft.CommerceServer.Adapter.Orders.OrdersRece iveEndpoint.GetOrderGuids(Cookie
commerceServerCookie, ArrayList& orderGroupIds)
at
Microsoft.CommerceServer.Adapter.Orders.OrdersRece iveEndpoint.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(Time Span value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(Date Time value)
at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTi me 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.TdsExecuteRPC(_Sql RPC[]
rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest
notificationRequest, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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(Com mandBehavior
behavior, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at
System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at
Microsoft.CommerceServer.Internal.Orders.MtsHelper .ExecuteSqlCommandDataSet(String
connStr, String commandText, ArrayList sqlParamValues, Int32 timeout)
at
Microsoft.CommerceServer.Orders.DataManagement.Ord erSearch.ExecuteSqlQuery(String
commandText, ArrayList valueList)
at
Microsoft.CommerceServer.Orders.DataManagement.Ord erSearch.ExecuteSearch(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
at
Microsoft.CommerceServer.Orders.DataManagement.Ser verOrderSystem.SearchPurchaseOrdersWithCount(XmlEl ement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)
at
Microsoft.CommerceServer.Orders.WebService.OrdersW ebService.SearchPurchaseOrdersWithCount(XmlElement
searchClause, SearchOptions searchOptions, Int32& recordsMatched)



Bidyut.