Re: BT2006 Debatching from SQL Adapter

How do you have the Any node set up in the schema? In the schema
editor try setting the Namespace property of the Any node to ##any and
the Process Content to skip.



Gregory Harris wrote:
Hi all,

excuse me if this one is a little long...

I'm wondering if I'm missing something: I am using the SQL adapter
for Biztalk 2006 against a SQL Server 2005 database. I have a receive
location polling a table and the generated schema has a target
namespace like http://a.b.c/Schemas/MyDatabase.

Fine so far. Now I wish to debatch the group of records returned by
the adapter into individual messages. ie. use an Envelope. An
example of using Envelopes with the SQL adapter is at
(http://www.rapidaddition.com/solutions%5Cenvelopes.htm).

All the examples I've seen tell me to set the TNS of the Envelope
schema to the same as the TNS for the generated records. However, if
I do this, I'm getting errors on my receive pipeline saying
"Unexpected event ("document_start") in state
"processing_empty_document". "

This appears (my assumption, feel free to correct me) to be because in
the envelope, the item type is set to xs:any. When the pipeline
breaks out each of these elements, the item itself does not have any
namespace reference, and thus fails.

I can't specify the exact type for the item in the envelope schema, as
I am not allowed to import an XSD whose namespace is the same as the
envelopes.

If I manually add the correct namespace to the individual items in a
sample file, I can successfully test the pipeline.

eg.
<ns0:Items xmlns:ns0="http:a.b.c/Schemas/MyDatabase">
<ns1:Item xmlns:ns1= "http:a.b.c/Schemas/MyDatabase"
Name="SomeSample/>
</ns0:Items>

Can anyone see anything obviously wrong please?

Thank You,

Greg Harris

.

Relevant Pages

  • Re: Receiving XML message without a namespace
    ... in with no target namespace, and I have defined my schemas with no target ... I am testing with a single schema, and I have tried the standard XML pipe, ... I have tried a custom pipe, with the XML ... > Xml Disassembler.Then use this receive pipeline ...
    (microsoft.public.biztalk.general)
  • RE: Send pipeline error
    ... If you don't have schema deployed, if you have different namespace or root node name in the XML or if there is more then 1 schema with this combinataion of target ... Subject: Send pipeline error ... Xml Pipeline has "Validate document"=True. ...
    (microsoft.public.biztalk.general)
  • Re: Flat File Problem
    ... It was the namespace I was using to ... When I debug the orchestration the RecCount variable is null. ... Have you deployed the Biztalk Assembly that contains the property schema ... And you can promote properties from the Header into the message context, ...
    (microsoft.public.biztalk.general)
  • RE: Default Namespace & Root Node questions
    ... the name of the root of the schema that is hardbound to the pipeline. ... |>>does not have a namespace specified. ... Rather than to remove the target ...
    (microsoft.public.biztalk.general)
  • Schema versioning / namespace or no namespace / like root nodes / Pipelines - any ideas?
    ... Namespace Options: Trying to figure out which way to go... ... I'm planning to handle the varying levels of schema content being ... Pipeline component to add this namespace to incoming SAP docs. ... pipeline per assembly-version (since there's no need for the pipeline ...
    (microsoft.public.biztalk.general)