Article ID: 2610824 - View products that this article applies to.
Consider the following scenario:
For example, a statement that uses the UNION ALL clause creates the [bam_<Activity Name>_AllInstances] view by merging the [bam_<Activity Name>_ActiveInstances] and [bam_<Activity Name>_CompletedInstances] views. Assume that the view has some records and that you run the SELECT * FROM [BAMPrimaryImport].[dbo].[bam_<Activity Name>_AllInstances] statement. In this scenario, you may receive the following error message:
Msg 241, Level 16, State 1, Line 2
Conversion failed when converting date and/or time from character string.
This issue occurs because the order of the columns is not consistent.
For example, a NVARCHAR column from the first view is positioned where a DATETIME column is positioned in the second view. Therefore, the error that is mentioned in the "Symptoms" section occurs.
Cumulative update informationThe hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Server 2010.
For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2617149/ )Cumulative update package 3 for BizTalk Server 2010
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For information about the service packs and cumulative update list for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2555976/ )Service pack and cumulative update list for BizTalk Server
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2003907 / )Information about BizTalk Server hotfixes
Article ID: 2610824 - Last Review: December 1, 2011 - Revision: 1.0
Contact us for more help
Connect with Answer Desk for expert help.