Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 886523 - Last Review: June 23, 2006 - Revision: 1.2
You may receive an "Invalid column name" error message in the Event Log when you use SQLXML mapping schemas in BizTalk Server 2004
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>".
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.
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.
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
| kbbiztalk2004-2006swept kbtshoot kbbtsorchestration kbprb KB886523 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate