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

View products that this article applies to.

Expand all | Collapse all

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 "Value" is invalid for property "Interchange Date Time".

String was not recognized as a valid DateTime (mscorlib)

Back to the top

CAUSE

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

Back to the top

WORKAROUND

To work around this issue, verify that the date time format for the language that is selected in the "Regional and Language Options" item in Control Panel is valid. To do this, follow these steps:

Click Start, click Run, type Intl.cpl, and then click OK.
On the Regional Options tab, click the language that you want to configure, and then click Customize.
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.

Back to the top

MORE INFORMATION

The "Interchange Date Time" 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 "Symptoms" section occurs when the string value is converted to a DateTime value.

Back to the top