[community-content]

Maybe it’s a type problem. i.e. database isn’t returning a 2 but many 2.0 or something.
Maybe you could wrap the db return value

One rather easy thing to try is create a simple .net component that takes in your two values (the db value and your 2). Then, you can convert them so you know they are the same and do your comparison.

Just make sure you pass in a reference to the .net component at a fact and make sure to GAC it.

Best of luck.

[community-content]

Errr sorry – not sure what i did there.

But anyway you get the picture of my schema.
So should i try to change to urn – or change on root note name and delete the respRoot from one of them.

I would be fine with just 1 updategram schema, but when different tables are defined ine the 2 I have, i don’t understand how i can have just one. I also run maps in my orchestrations to map the incomming xml doc to the updategrams. So i don’t get how to just use one.

Any examples or resources you know of that show something similar to this, or show how to use the same SQL port for different updategrams, or do i just make more parts to my updatgram & make it even bigger. Right now my updategram schema has 2 parts the ReqRoot & The RespRoot, do i just add like a ReqRoot2 – that type of thing?

Thank you

[community-content]

OH – yes both my updategram schema have ReqRoot & RespRoot.

Here is 1 of them…

<?xml version=\”1.0\” encoding=\”utf-16\”?>
<xs:schema xmlns:tns=\”myCompany.myProject.UpdSchema\” xmlns:updg=\”urn:schemas-microsoft-com:xml-updategram\” xmlns:b=\”http://schemas.microsoft.com/BizTalk/2003\” attributeFormDefault=\”qualified\” elementFormDefault=\”qualified\” targetNamespace=\”myCompany.myProject.UpdSchema\” xmlns:xs=\”http://www.w3.org/2001/XMLSchema\”>
<xs:import schemaLocation=\”.\\updgidentity.xsd\” namespace=\”urn:schemas-microsoft-com:xml-updategram\” />
<xs:annotation>
<xs:appinfo>
<b:references>
<b:reference targetNamespace=\”urn:schemas-microsoft-com:xml-updategram\” />
</b:references>
</xs:appinfo>
</xs:annotation>
<xs:element name=\”ReqRoot\”>
<xs:complexType>
<xs:sequence minOccurs=\”1\” maxOccurs=\”1\”>
<xs:element xmlns:updategram=\”urn:schemas-microsoft-com:xml-updategram\” updategram:Prefix=\”updg\” minOccurs=\”1\” maxOccurs=\”1\” name=\”sync\”>
<xs:complexType>
<xs:sequence minOccurs=\”1\” maxOccurs=\”1\”>
<xs:element updategram:Prefix=\”updg\” minOccurs=\”1\” maxOccurs=\”1\” name=\”after\”>
<xs:complexType>
<xs:sequence minOccurs=\”1\” maxOccurs=\”1\”>
<xs:element minOccurs=\”1\” maxOccurs=\”1\” name=\”T_Message\”>
<xs:complexType>
<xs:attribute ref=\”updategram:at-identity\” />
<xs:attribute name=\”Job_ID\” type=\”xs:long\” />
<xs:attribute name=\”MessageType_ID\” type=\”xs:long\” />
<xs:attribute name=\”Direction_IND\” type=\”xs:string\” />
<xs:attribute name=\”Creation_DT\” type=\”xs:string\” />
</xs:complexType>
</xs:element>
<xs:element minOccurs=\”1\” maxOccurs=\”unbounded\” name=\”C_Lot\”>
<xs:complexType>
<xs:attribute ref=\”updategram:at-identity\” />
<xs:attribute name=\”Message_ID\” type=\”xs:string\” />
<xs:attribute name=\”IsBulkLot_Flag\” type=\”xs:string\” />
<xs:attribute name=\”LotType_NM\” type=\”xs:string\” />
<xs:attribute name=\”Depot_CD\” type=\”xs:string\” />
<xs:attribute name=\”DestDepot_CD\” type=\”xs:string\” />
<xs:attribute name=\”Lot_CD\” type=\”xs:string\” />
<xs:attribute name=\”Label_CD\” type=\”xs:string\” />
<xs:attribute name=\”Status_TXT\” type=\”xs:string\” />
<xs:attribute name=\”Expiration_DT\” type=\”xs:string\” />
<xs:attribute name=\”Total_CNT\” type=\”xs:int\” />
<xs:attribute name=\”Trans_CNT\” type=\”xs:int\” />
</xs:complexType>
</xs:element>
<xs:element minOccurs=\”0\” maxOccurs=\”unbounded\” name=\”C_LotItem\”>
<xs:complexType>
<xs:attribute name=\”Lot_ID\” type=\”xs:string\” />
<xs:attribute name=\”Depot_CD\” type=\”xs:string\” />
<xs:attribute name=\”DestDepot_CD\” type=\”xs:string\” />
<xs:attribute name=\”Item_NO\” type=\”xs:string\” />
<xs:attribute name=\”ItemType_CD\” type=\”xs:string\” />
<xs:attribute name=\”Status_TXT\” type=\”xs:string\” />
<xs:attribute name=\”Expiration_DT\” type=\”xs:string\” />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name=\”nullvalue\” type=\”xs:string\” />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name=\”RespRoot\”>
<xs:complexType>
<xs:sequence>
<xs:element name=\”Success\” type=\”xs:anyType\” />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

So I am fine with 1 schema then but I’m just not sure how to implement that. The schema has the tables I want to insert into. Right now my second schema has different tables so if i went with only 1 schema i don’t get how i would define the tables – plus i using a map to map each schema comming in to the updategram schema, so once again I dont get how i could do that with just 1 schema. So I am willing to change things, should i try urn or should i delete RespRoot from 1 schema & change ReqRoot of one of them?

Know of any resources or samples that show this or something similar.

I have read most of BizTalk 2004 unleashed, and done much research and I have yet to see good explanations around the multipart messages and all that stuff that gets automatically created when you use the generated items (ie. Orchestration with port types and multi-part messages defined). Ic overed so much material I am probablly forgetting some of it.

I either see too simple of samples or too advanced samples. I having difficulties finding intermediate samples that actually walk you through the steps to recreate them.

Thanks!!!

[community-content]

I think the custom adapter would be the best place to do this.
If you wanta head start you could try this adapter:
[url]http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728[/url]

You will need to write a scheduled task to perform the zip function

[community-content]

Do both your schemas have the same root node.
If this is the case you will have to change the root node of one schema.
You cannot have two schema with the same root node and namespace deployed.
Also only one of your schema files can have the response node declared.
This is why I prefer one schema, the xsd rules prevent you from duplicating nodes.

The response to the updategram is always one node <Success>. All errors are reported by throwing an exception.
The main reason for receiving the response is to know when this call to SQL has completed. And you need to remove this message from the message box by consuming it.

[community-content]

Please send small example of incoming XML data.

[community-content]

If you check the Biztalk Admin Console, has the port actually been disabled? If so, check the application event log for reason.

[community-content]

I’m curious, were you using an orchestration or just message-based routing? If you went the orchestration route, were you starting 36,000 orchestrations?

Also, SQL has something called OPENXML where you can read XML and use it in a stored proc. Maybe you could use Biztalk tools to translate the map in one big batch, then send to one single stored proc.

And lastly, I always remind people that there are two technologies:
BPM – Business Process Management – Biztalk
ETL – Extract, Translate, Load – DTS (or the new SSIS in SQL 2005).

Use the right tool for the right job. Eletric cordless drills are great for making holes, but not so good for hammering in nails.

[community-content]

The only thing i noticed in your explanation that would cause your problem is the missing namespace prefix on the Record node
It should be:

<ns1:Record xmlns:ns1=\”http://pr_test_2_schemas.sch_test_2_body\”>

Is it possible to email me your schemas and a sample data file

[community-content]

So why not call the webservice is the \”normal\” fashion, i.e. by making a web reference, and with Send/Receive shapes?

[community-content]

Just to add to the above post:

You can create your own key file by running the \”sn\” .NET utility with the -k option.

sn -k ABCCompany.key

Most sites use one key file per application, or perhaps even one key file for the whole company.

In other words, if they gave you a keyfile in the tutorials, or you generated a keyfile in the tutorial, you don’t have to use that file in your applications, but you would probably generate your own key file for your company – or ask around and see if they already have a key file they want you to use.

[community-content]

Thanks for the reply Stephen W. Thomas!

I have tested my input from the orchestration with a basic test:

My XML message is built up by 2 attributes, one Boolean and one integer.
I have changed the rule so it compares the integer value of the xml message with 2. If true the boolean is switch to true.
This works fine when called from the orchestration.

But if the integer value is delivered from the database, the xml message will not change when called from the orchestration.

Strange

[community-content]

Thank you for the response. I thought it made good sense so I changed the updategrams to have the same target namespace (for example http://Project1), then i changed the SQL port TargetNamespace to the same. Undeployed – ReDeployed But now i get an error message that states…

This Assembler cannot retrieve a document specification using this type: \”http://Project1#ReqRoot

I have been to W3C web site and though i have an ok grasp of namespaces, so could you try to give me a little more info please.
Just in general terms so i can recreate it if i need to.

So now i have 2 schemas SchemaA & schemaB, their namespaces are different (http://Project1.SchemaA & http://Project1.SchemaB). But i changed both updategrams to just have the same namespace – just (http://Project1), this is how I was interpreting your response.

Will I need to go back and change things in the orchestration view of the orchestrations or something? Or am just totally executing your advice incorrectly?

Thanks again. I been working b=with BizTlak for 3 months now & every time i think I’m getting it, i run into another road block.

I will recreate another project if need be to dummy down my actual project if need be.

Aother quick question if I can – should i even bother getting the response back from the SQL port for an updategram. Eventually i will try to work in error handling, so all I really care about is knowing somehow if the insert failed. any advice on that?

k thanks again for all your help.

[community-content]

8 Current Error Message from Event Viewer:
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5753
Date: 5/31/2006
Time: 9:53:17 AM
User: N/A
Computer: FFICBMDEVNEW
Description:
A message received by adapter \”FILE\” on receive location \”pr_test_2_1.0.0.0_pr_test_2.orch_test_2_port_rec_test_2_9ee3ac47ef27d2e6_ReceiveLocation\” with URI \”C:\\bts_sl_test_2\\IN\\*.xml\” is suspended.
Error details: There was a failure executing the receive pipeline: \”pr_test_2.pl_test_2a, pr_test_2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9ee3ac47ef27d2e6\” Source: \”XML disassembler\” Receive Port: \”pr_test_2_1.0.0.0_pr_test_2.orch_test_2_port_rec_test_2_9ee3ac47ef27d2e6\” URI: \”C:\\bts_sl_test_2\\IN\\*.xml\” Reason: No Disassemble stage components can recognize the data.
MessageId: {33813B7C-8A7E-4553-B7DF-EF5A1BEFD9DA}
InstanceID: {140AE0EE-F35A-46C9-A167-6D165007A196}

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have check for UTF-8 BOM usage with my editor and this is toggled ON.

Thanks,
Phil

[community-content]

Are you sure the message you are passing into the BRE has the values you are expecting?

Maybe something is not set as you expect so your rule isn’t firing or your SQL isn’t working right.

It sounds like you are doing everything right. If it works outside the Orchestration and when the rule is always true it sounds like a problem with the input.

[Author]

Posts