Help and Support
 

powered byLive Search

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.
Article ID:942249
Last Review:October 25, 2007
Revision:1.2

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:
http://msdn2.microsoft.com/en-us/library/1k1skd40.aspx (http://msdn2.microsoft.com/en-us/library/1k1skd40.aspx)

Back to the top

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

Back to the top

Keywords: 
kbbts kbtshoot kbprb KB942249

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.