01-14-06 02:54 AM
Apurv,
If I understand this correctly the send pipeline is complaining because the
message you are passing it doesn't have the Namespace and Root node name tha
t
it is looking for. It is looking for a document with a namespace of
http://Microsoft.Sample.SQLAdapter and a root node of MyRequestroot.
Verify you are sending the correct message to the SQL port.
"Apurv Shah" wrote:
>
> i have created two biztalk Project in visual studio .net for inserting cat
alog
> cxml into our databse and fetching order records from database to xml usin
g
> the ref of
> http://msdn.microsoft.com/library/d..._adapt_tbdk.asp
>
> but when i submit my catalog file which is in cxml format to the input fol
der
> there are two errors generet in to event viwer
> the same thing happen in both application
>
> 1:There was a failure executing the send pipeline:
> "Microsoft.BizTalk.DefaultPipelines.XMLTransmit" Source: "XML assembler" S
end
> Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve documen
t
> specification by using this type:
> "http://Microsoft.Sample.SQLAdapter#MyRequestroot".
>
> 2.There was a failure executing the send pipeline:
> "Microsoft.BizTalk.DefaultPipelines.XMLTransmit" Source: "XML assembler" S
end
> Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve documen
t
> specification by using this type:
> "http://Microsoft.Sample.SQLAdapter#MyRequestroot".
>
> here is my catalog cxml
> Fille catalog.xml
>
> <?xml version="1.0" ?>
> <!DOCTYPE cXML>
> <cXML version="1.2.008" xml:lang="en-US" payloadID="" timestamp=""
> xmlns="http://Microsoft.Sample.CatalogApplication">
> <Header>
> <From>
> <Credential domain="">
> <Identity>Customer</Identity>
> </Credential>
> </From>
> <To>
> <Credential domain="">
> <Identity>Jignesh</Identity>
> </Credential>
> </To>
> <Sender>
> <Credential domain="">
> <Identity>Leosystem</Identity>
> </Credential>
> <UserAgent>Application eProcurement</UserAgent>
> </Sender>
> </Header>
>
> <Catalog_Header>
> <Catalog_Purpose>
> <Cat_Number>cxml cat test</Cat_Number>
> <Cat_Desc>cxml cat desc</Cat_Desc>
> <PurposeCode>cxml pcode1</PurposeCode>
> <!--Codes are 01 = catalog or 04 = Cost Assure Program Changes-->
> </Catalog_Purpose>
> <Date_Time>
> <EffecDate>2006-01-01</EffecDate>
> </Date_Time>
> <SellingParty>
> <SellName>xxx 60 xxx</SellName>
> <NameIDCode>xxx 80 xxx</NameIDCode>
> </SellingParty>
> </Catalog_Header>
>
> <Catalog_Detail>
> <ProductName>Pencil</ProductName>
> <BrandName>HB</BrandName>
> <UPCCode>14445</UPCCode>
> <CategoryName>Stationary</CategoryName>
> <MfgCatNumber>cxml Mfg cat 1</MfgCatNumber>
> <ContractNumber>cxml cont1</ContractNumber>
> <BuyerItemNumber>P000001</BuyerItemNumber >
> <ProdDesc>cxl itm desc</ProdDesc>
> <UnitPrice>12</UnitPrice>
> <UnitOfMeasure>PU</UnitOfMeasure>
> </Catalog_Detail>
>
> </cXML>
>
> here is my order xml file
> "order.xml"
>
> <?xml version="1.0" standalone="yes"?>
> <NewDataSet xmlns="http://SQL_Adapter_SP/OrderApplication">
> <OrderDetail>
> <OrderNo>436</OrderNo>
> <SupplierNo>169</SupplierNo>
> </OrderDetail>
> </NewDataSet>
>
> is there any solution for this
>
> --
> Regards
>
>
> Apurv Shah
> Software Engineer
> Leo Systems and Solution
> Pune,India
> mob: 919823676454
[ Post a follow-up to this message ]
| 
