|
Home > Archive > Commerce Server General > August 2007 > BizTalk Order Adapter Date Issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk Order Adapter Date Issue
|
|
|
| Hi all
I have a CS 2007 and am trying to extract information from that using BT
2006 - specifically orders through the orders adapter.
I am getting an error in the eventlog on the BT Server and a "matching"
error in the eventlog on the CS Server. The essence of the error on the CS
Server is
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between
1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
I have read through a previous thread where people solved the same issue by
setting the date found in the registry database of the BT Server under
Commer Server 2007 BizTalk Adapters/Orders/[Registry Key from RcvLoc Config]
to a valid date.
This I have tried without any luck - I have experimented with different
dates and formats without it making any difference.
Does anybody have any suggestions or examples of valid dates I can try since
I am running out of ideas?
Thanks in advance
/Troels
| |
|
| Can you send the full event log details?
Also, you problem could be caused by a datatime field being an empty string,
somewhere in your orders, line items, etc.
"trc" wrote:
> Hi all
>
> I have a CS 2007 and am trying to extract information from that using BT
> 2006 - specifically orders through the orders adapter.
>
> I am getting an error in the eventlog on the BT Server and a "matching"
> error in the eventlog on the CS Server. The essence of the error on the CS
> Server is
>
> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between
> 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
>
>
>
> I have read through a previous thread where people solved the same issue by
> setting the date found in the registry database of the BT Server under
> Commer Server 2007 BizTalk Adapters/Orders/[Registry Key from RcvLoc Config]
> to a valid date.
>
> This I have tried without any luck - I have experimented with different
> dates and formats without it making any difference.
>
> Does anybody have any suggestions or examples of valid dates I can try since
> I am running out of ideas?
>
> Thanks in advance
>
> /Troels
>
>
>
>
|
|
|
|
|