Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Commerce Server General > BizTalk Order A...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 2361 of 2446
Post > Topic >>

BizTalk Order Adapter Date Issue

by "trc" <trc_ng@[EMAIL PROTECTED] > Jun 29, 2007 at 11:27 AM

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
 




 2 Posts in Topic:
BizTalk Order Adapter Date Issue
"trc" <trc_n  2007-06-29 11:27:33 
RE: BizTalk Order Adapter Date Issue
=?Utf-8?B?SkM=?= <JC@[  2007-08-14 08:54:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:44:21 CST 2008.