Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You may receive an "Invalid column name" error message in the Event Log when you use SQLXML mapping schemas in BizTalk Server 2004

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

View products that this article applies to.

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 "SQL" raised an error message.
Details "HRESULT="0x80040e14" Description="Invalid column name 'UnderName'.
" ?<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80040e14"
Source="Microsoft OLE DB Provider for SQL Server"
Description="Invalid column name 'UnderName'."?></Root>".

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB886523, kbprb, kbbtsorchestration, kbtshoot, kbbiztalk2004-2006swept

↑ Back to the top

Article Info
Article ID : 886523
Revision : 3
Created on : 6/23/2006
Published on : 6/23/2006
Exists online : False
Views : 319