Microsoft KB Archive/886523

= You may receive an &quot;Invalid column name&quot; error message in the Event Log when you use SQLXML mapping schemas in BizTalk Server 2004 =

Article ID: 886523

Article Last Modified on 6/23/2006

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





SYMPTOMS
In Microsoft BizTalk Server 2004, when you use SQLXML mapping schemas, you may receive an error message in the Event Log that is similar to the following:

Event Type: Warning

Event Source: BizTalk Server 2004

Event Category: BizTalk Server 2004

Event ID: 5740

Date: 8/24/2004

Time: 3:52:45 PM

User: N/A

Computer: BIZTALK2004

Description:

The adapter &quot;SQL&quot; raised an error message.

Details &quot;HRESULT=&quot;0x80040e14&quot; Description=&quot;Invalid column name 'UnderName'.

&quot; ?<?MSSQLError HResult=&quot;0x80040e14&quot;

Source=&quot;Microsoft OLE DB Provider for SQL Server&quot;

Description=&quot;Invalid column name 'UnderName'.&quot;?>&quot;.



CAUSE
This issue occurs because BizTalk Server 2004 does not support this SQLXML feature, even though we recommend it in the &quot;Best Practices for Using the SQL Adapter&quot; topic in the BizTalk Server 2004 documentation.



RESOLUTION
To resolve this issue, use the BizTalk Server 2004 mapping system. In the orchestration setup, create a BizTalk map between the input schema and a SQLXML updategram schema that does not reference any external mapping file.

Additional query words: BTS BTS2004

Keywords: kbtshoot kbprb kbbtsorchestration kbbiztalk2004-2006swept KB886523

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.