Microsoft로 로그인
로그인하거나 계정을 만듭니다.
안녕하세요.
다른 계정을 선택합니다.
계정이 여러 개 있음
로그인할 계정을 선택합니다.
영어
죄송합니다. 이 문서는 귀하의 언어로 사용할 수 없습니다.

Symptoms

Consider the following scenario:

  • You have a computer that is running BizTalk Server 2010.

  • You use Business Activity Monitoring (BAM) Management utility (BM.exe) to deploy a Business Activity Monitoring (BAM) activity definition file to a database.

  • You use BM.exe to perform a BAM database update that adds some columns of various data types into an existing BAM activity.

  • You run a SELECT statement on a view of the BAM activity. The view is created by using a UNION ALL clause that merges two views in the BAMPrimaryImport database.

In this scenario, you may receive a "Conversion failed" error message.

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.


Cause

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.

Resolution

Cumulative update information

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

2617149 Cumulative update package 3 for BizTalk Server 2010

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

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:

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:

2003907 Information about BizTalk Server hotfixes

도움이 더 필요하세요?

더 많은 옵션을 원하세요?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

이 정보가 유용한가요?

사용 경험에 어떠한 영향을 주었나요?
제출을 누르면 피드백이 Microsoft 제품과 서비스를 개선하는 데 사용됩니다. IT 관리자는 이 데이터를 수집할 수 있습니다. 개인정보처리방침

의견 주셔서 감사합니다!

×