|
Home > Archive > BizTalk Server Orchestration > January 2006 > This Assembler cannot retrieve document specification by using thi
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
This Assembler cannot retrieve document specification by using thi
|
|
| Apurv Shah 2005-12-28, 7:51 am |
|
i have created two biztalk Project in visual studio .net for inserting catalog
cxml into our databse and fetching order records from database to xml using
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 folder
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" Send
Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve document
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" Send
Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve document
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
| |
|
| 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 that
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 catalog
> cxml into our databse and fetching order records from database to xml using
> 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 folder
> 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" Send
> Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve document
> 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" Send
> Port: "SQL://BIZTALK/POPS/" Reason: This Assembler cannot retrieve document
> 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
|
|
|
|
|