| Apurv Shah 2005-12-26, 5:54 pm |
|
i have created a biztalk Project in visual studio .net for inserting catalog
cxml into our databse 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
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>
--
Regards
Apurv Shah
Software Engineer
Leo Systems and Solution
Pune,India
mob: 919823676454
email : apurva_shah1301@hotmail.com
|