Microsoft KB Archive/942249

= Error message when you try to view the EDI Interchange and Correlated ACK Status report in BizTalk Server 2006 R2: &quot;This operation failed while accessing at least one of the Message Box databases&quot; =

Article ID: 942249

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2006 R2 Standard Edition
 * Microsoft BizTalk Server 2006 R2 Enterprise Edition
 * Microsoft BizTalk Server 2006 R2 Developer Edition
 * Microsoft BizTalk Server 2006 R2 Branch Edition

-



SYMPTOMS
In Microsoft BizTalk Server 2006 R2, you may receive an error message that resembles one of the following when you try to view the EDI Interchange and Correlated ACK Status (Interchange/ACK Status) report:

Error message 1

Error: This operation failed while accessing at least one of the Message Box databases. Some results might be omitted.

Additional Information:

String was not recognized as a valid DateTime. Couldn't store <> in ActivationTime Column. Expected type is DateTime.(System.Data) String was not recognized as a valid DateTime. (mscorlib)

Error message 2

Error: This operation failed while accessing at least one of the Message Box databases. Some results might be omitted.

Additional Information:

Specified value &quot; &quot; is invalid for property &quot;Interchange Date Time&quot;.

String was not recognized as a valid DateTime (mscorlib)



CAUSE
This issue can occur if the time format for the language that is selected in the &quot;Regional and Language Options&quot; item in Control Panel is not valid for the DateTime.Parse method.



WORKAROUND
To work around this issue, verify that the date time format for the language that is selected in the &quot;Regional and Language Options&quot; item in Control Panel is valid. To do this, follow these steps:
 * 1) Click Start, click Run, type Intl.cpl, and then click OK.
 * 2) On the Regional Options tab, click the language that you want to configure, and then click Customize.
 * 3) On the Time tab in the Time format box, click a time format that is valid for the DateTime.Parse method. For example, click H:mm:ss.



MORE INFORMATION
The &quot;Interchange Date Time&quot; column in the Interchange/ACK Status report uses the DateTime.Parse method to convert string time and date information. The error that is described in the &quot;Symptoms&quot; section occurs when the string value is converted to a DateTime value.

