Re: Error with DB2 adapters while processing an envelope

I've learned an additional detail.

I created a receive port/location which points to an "IN" folder, and
a send port that points "OUT" folder. If I take the raw XML document
that I create via the DB2 adapters, it will fail with the
"processing_empty_document" message. I should note that the raw XML
produced by the DB2 adapter is all on one line, and not at all
formatted.

If I open up this XML document in Visual Studio 2005, and format it
(which includes whitespaces and carriage returns), and then drop it in
the "IN" folder, it is debatched appropriately, and I receive
independent documents in the "OUT" folder.

So, it looks like the XML disassembler fails because the XML is all on
one line!

It seems to me that it should not work like this. Does anyone have
any insight?

Here's my envelope schema:

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003";
xmlns="http://schemas.tsa.com/esb/dcmessaging/hostschemas/origination/
cartonstores" elementFormDefault="qualified" targetNamespace="http://
schemas.tsa.com/esb/dcmessaging/hostschemas/origination/cartonstores"
xmlns:xs="http://www.w3.org/2001/XMLSchema";>
<xs:annotation>
<xs:appinfo>
<b:schemaInfo is_envelope="yes" xmlns:b="http://
schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
<xs:element name="CartonStoresEnvelope">
<xs:annotation>
<xs:appinfo>
<b:recordInfo body_xpath="/*[local-
name()='CartonStoresEnvelope' and namespace-uri()='http://
schemas.tsa.com/esb/dcmessaging/hostschemas/origination/
cartonstores']" />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:any maxOccurs="unbounded" namespace="##any"
processContents="lax" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Here's my document schema:

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003";
xmlns="http://schemas/cartonstores"; targetNamespace="http://schemas/
cartonstores" xmlns:xs="http://www.w3.org/2001/XMLSchema";>
<xs:element name="Table1">
<xs:complexType>
<xs:attribute name="TIF_RECORDID" type="xs:int" />
<xs:attribute name="TIF_OPERATIONTYPE" type="xs:string" />
<xs:attribute name="MESSAGE" type="xs:string" />
<xs:attribute name="TIMSTMP" type="xs:string" />
<xs:attribute name="MSGNBR" type="xs:decimal" />
<xs:attribute name="SRCAPP" type="xs:string" />
<xs:attribute name="SRCLOCN" type="xs:decimal" />
<xs:attribute name="FEEDFLG" type="xs:string" />
<xs:attribute name="SVCGRPID" type="xs:string" />
<xs:attribute name="SVCINFO" type="xs:string" />
<xs:attribute name="ERRORID" type="xs:string" />
<xs:attribute name="MSGTXT1" type="xs:string" />
<xs:attribute name="MSGTXT2" type="xs:string" />
<xs:attribute name="ALERTFLG" type="xs:string" />
<xs:attribute name="PRTMSTMP" type="xs:string" />
<xs:attribute name="CARTONID" type="xs:string" />
<xs:attribute name="CTNTOLOC" type="xs:decimal" />
</xs:complexType>
</xs:element>
</xs:schema>

I would be happy to send a zipped solution with bindings, if you'd
like to try it out yourself.


On Feb 16, 10:28 am, "Wade Wegner" <weg...@xxxxxxxxx> wrote:
I should add that I don't get errors when I switch the send pipeline
to PassThruTransmit from XMLTransmit. Only, it doesn't debatch the
message -- it just leaves it in one batch, which is not what I want.

Any help would be greatly appreciated! Thanks!

On Feb 15, 8:32 am, "Wade Wegner" <weg...@xxxxxxxxx> wrote:



Hi all,

I am using the host adapters to connect to a DB2 system. I invoke a
stored procedure, which returns a number of records back. I have two
schemas defined -- one that was created by the host adapter, and an
envelope. Both have the same target namespace defined. I've been
able to follow the following link and get this to work agains SQL
2005:

http://msdn2.microsoft.com/en-us/library/ms916019.aspx

However, when I try those steps with the DB2 adapter, I get the
following errors:

--

A message received by adapter "DB2" on receive location
"RECEIVELOCATION" with URI "DB2://SERVER:446/SERVER/BIZPOC" is
suspended.
Error details: There was a failure executing the receive pipeline:
"Microsoft.BizTalk.DefaultPipelines.XMLReceive,
Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" Source: "Pipeline " Receive Port:
"RECEIVEPORT" URI: "DB2://SERVER:446/SERVER/BIZPOC" Reason: Unexpected
event ("document_start") in state "processing_empty_document".
MessageId: {83935FBB-09B8-49C3-A934-ACDEA268A05B}
InstanceID: {9F1E40EB-1B7A-43C3-ABC0-4C809307E60B}

There was a failure executing the receive pipeline:
"Microsoft.BizTalk.DefaultPipelines.XMLReceive,
Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" Source: "Pipeline " Receive Port:
"RECEIVEPORT" URI: "DB2://SERVER:446/SERVER/BIZPOC" Reason: Unexpected
event ("document_start") in state "processing_empty_document".

--

I imagine the problem occurs during the debatching of the messages,
but I have no idea how to resolve the problem. Can anyone provide any
suggestions or assistance?

Thank you very much!

Wade- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Access to the path " is denied
    ... and it would also have to write to an XML document. ... Also gave machinename/IIS_WPG rights to the folder myApp ... What i notied is that the folder has Read Only attributes ticked if i right clicked myApp ... But i have tried turning off the read only. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access to the path " is denied
    ... and it would also have to write to an XML document. ... What i notied is that the folder has Read Only attributes ticked if i ... right clicked myApp properties. ... But i have tried turning off the read only. ...
    (microsoft.public.dotnet.framework.aspnet)
  • XSL Filter Help Needed
    ... I have an XML document which looks like ... the applicable links and structure ... invalid key pattern. ...
    (microsoft.public.dotnet.xml)
  • Custom Pipelines, Send Ports, Errors
    ... We have a schema with the name "Gha\schemas\x12wrapper" (or Something ... closed to that) In the schema we have a promoted property called ... I have a send port that filters on ... When I add the folder I get an error ...
    (microsoft.public.biztalk.general)
  • Custom Pipelines, Send ports and Content.Promote
    ... We have a schema with the name "Gha\schemas\x12wrapper" (or Something ... closed to that) In the schema we have a promoted property called ... I have a send port that filters on ... When I add the folder I get an error ...
    (microsoft.public.biztalk.general)