Help and Support

Article ID: 942249 - Last Review: October 25, 2007 - Revision: 1.3

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"

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)

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.

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.

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.

REFERENCES

For more information about the DateTime.Parse method, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/1k1skd40.aspx (http://msdn2.microsoft.com/en-us/library/1k1skd40.aspx)

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
Keywords: 
kbbts kbtshoot kbprb KB942249

Article Translations