Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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.

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:
  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.

↑ 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


References

For more information about the DateTime.Parse method, visit the following Microsoft Developer Network (MSDN) Web site:

↑ Back to the top


Keywords: KB942249, kbprb, kbtshoot, kbbts

↑ Back to the top

Article Info
Article ID : 942249
Revision : 4
Created on : 10/25/2007
Published on : 10/25/2007
Exists online : False
Views : 486