community-content

Forum Replies Created

Viewing 15 posts - 8,086 through 8,100 (of 9,648 total)
  • Author
    Posts
  • 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!!!

    in reply to: Zip 100 incoming messages #14783

    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

    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.

    in reply to: How to map #13690

    Please send small example of incoming XML data.

    in reply to: Receive Port no more listening #13742

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

    in reply to: Speed Issue #13700

    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.

    in reply to: \"allow unrecognized message\" #14749

    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

    in reply to: How to handle web service return value #13721

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

    in reply to: Why do we need key file used in Tutorials ? #13729

    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.

    in reply to: Business Rule Composer problem! #13751

    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

    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.

    in reply to: \"allow unrecognized message\" #14754

    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

    in reply to: Business Rule Composer problem! #13752

    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.

    in reply to: \"allow unrecognized message\" #14753

    Greg,

    Thanks for your help. This will be detailed (though hopefuly not long winded.)

    I think I have been trying this method. I’ll try to outline all the little details I had to sweat along the way with little results.

    1) the data – in summary

    <?xml version=\”1.0\” encoding=\”UTF-8\”?>
    <ns0:UtilityData xmlns:ns0=\”http://pr_test_2_schemas.sch_test_2_env\”>
    <Utility>
    <Utility_Name> Datamatic Test </Utility_Name>
    <Utility_ID> ID_TEST </Utility_ID>
    </Utility>
    <Software>
    <MVP_Version> 3.7 </MVP_Version>
    <ROADRUNNER_Version> 032401 </ROADRUNNER_Version>
    <AMR_Version> 020901 </AMR_Version>
    </Software>
    <Data>
    <Record xmlns:ns1=\”http://pr_test_2_schemas.sch_test_2_body\”>
    <CustomerData>
    <Name> Customer 1 </Name>
    …
    </CustomerData>
    …
    </Record>
    .
    .
    .
    <Record xmlns:ns1=\”http://pr_test_2_schemas.sch_test_2_body\”>
    <CustomerData>
    <Name> Customer 23 </Name>
    …
    </CustomerData>
    …
    </Record>
    .
    .
    .

    </Data>
    </ns0:UtilityData>

    Tag Summary:
    – UtilityData: root node
    – Utility, Software – header info (applicable to all records)
    – Data – individual records

    2) My Envelope Schema looks something like

    – UtilityData
    – Utility
    Utility_Name
    Utility_ID
    – Software
    MVP_Version
    …
    – Data
    ns0:Record (imported….)
    (though I have tried with <any>

    3) My Body schema looks like:
    – Record
    – Customer Data
    …. field elements
    – RouteData
    ….. field elements
    – MeterData
    … field elements
    – ReadingData
    … field elements
    – FIREFLY
    … field elements

    NOTE: I have put in names spaces in the data XML file:
    NOTE: I put the schemas in a separate project; I had read to do that somewhere.

    IN the ORCHESTRATION
    4) The receive pipeline’s request operation has the \”Message Type\” property set to:
    pr_test_2_schemas.sch_test_2_body (is this correct? pointing to the body schema.)
    – the receive pipeline configured for custome
    pipeline: pr_test_2.pl_test_2a
    transport: file
    URI: C:\\bts_sl_test_2\\IN\\*.xml

    5) the Receive Message object/element has the \”Message\” property set to: msg_2_body

    5a) msg_2_body: property \”Message Type\” = pr_test_2_schemas.sch_test_2_body

    5b) Send message object/element configured the same

    6) Send Port:
    pipeline: Microsoft.BizTalk.DefaultPipelines.XMLTransmit
    transport: file
    URI: C:\\bts_sl_test_2\\OUT\\%MessageID%.xml

    7) custom pipeline: pr_test_2.pl_test_2a
    – in Disassemble stage: XMLDisassembler
    – allow unrecognized message: false
    – Document Schemas: pr_test_2_schemas.sch_test_2_body, pr_test_2_schemas, Version=1.0.0.0, Culture=Neutral, PublicKey Token = …..
    – Envelope Schemas: pr_test_2_schemas.sch_test_2_env, pr_test_2_schemas, Version=1.0.0.0, Culture=Neutral, PublicKey Token = …..

    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 again,
    Phil

    in reply to: Configuring receive location for HTTP adapter #13747

    The best way to get this to work is to install the SDK http sample. When you install that examle the example adds a com+ applictation to the IIS and it’s needed to make the HTTP adapter to work. After installing the example you can unistall it because the com+ application is still there.

    If you look at this installion guide and do exactly as that it will work:
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_sdk_samples_yzhk.asp

    Don’t forget to add a new httpadapter in the iis to afflict your envierment.

Viewing 15 posts - 8,086 through 8,100 (of 9,648 total)