community-content

Forum Replies Created

Viewing 15 posts - 3,226 through 3,240 (of 9,648 total)
  • Author
    Posts
  • in reply to: "Dynamic Send Port file" and "create folder" are not friend #21696

    I try it but it doesn’t worked too.

    In this case, the send port Create a file that contain the folder name

    in reply to: "Dynamic Send Port file" and "create folder" are not friend #21695
    Something like :

    Port_2(Microsoft.XLANGs.BaseTypes.Address) = "file://C:\Alten\test\testdynamicFolder\Out
    "+vDatetime;

    ????

    will this work if the input xml has differenct schema namespace when compared with message being constructed

    in reply to: BizTalk Complex Mapping Issue #21693

    Hay Suman, Can you explain a bit your 2nd point?

    in reply to: BizTalk Complex Mapping Issue #21689

    Hi

    You can write the external XSLT file to be aligned to the target XSD file
    (OR)
     write XML serialization for the port where message will be received.

    Regards,
    Suman Kalyan Betal

     

    Steps To Solve your Issue…

    1) From your inputted message get the xml in the xmlDocument Variable (you can also take help of   helper class to get XML from message), in Expression Shap.

    2) Then in construction message assign xmlDocument Variable to your unconstructed message.

    in reply to: BizTalk Complex Mapping Issue #21685

    waiting for reply[:(]

    in reply to: direct port to msg Box #21684

    Only by writing some custom code to interrogate the subscriptions and try and match with your particular scenario. Although this may not be accurate as insistence subsciptions may only exist for a short period of time and may or may not exist when you look.

    Setting Envelope=Yes and the body Xpath was my first of many attempts. This resulted in  the error about no subscribers:

    The published message could not be routed because no subscribers were found

    The only setting in body XPath that even produced the “schema not found” error was POLLINGSTMT/POLLINGSTMTRECORD/POLLINGSTMTRECORD… of course telling me it couldn’t fnd the Schema for “ID,” my first entry in the POLLINGSTMTRECORD.

    Only after setting the root node to “POLLINGSTMT” did I get the error stating that the schema for POLLINGSTMTRECORD couldn’t be found. At this point I followed the standard new schema / include method mentioned in the blog posted previously.

    The only message I get back is of type POLLINGSTMT…. so like you said, I wouldn’t be able to handle messages of this type.

    I guess my real beef is lack of documentation for how it was designed to work.

    I find setting the Root Reference is generally a bad idea.
    When you deploy a schema with Root Reference = (Default), each root level element in the schema is registered as a message type.
    In your case there will be 4 message types: POLLINGSTMT, ArrayOfPOLLINGSTMTRECORD, POLLINGSTMTRECORD, POLLINGSTMTResponse.
    If you specify the Root Reference then only that element is registered as a message type, i.e. POLLINGSTMT

    When the Xml Disassembler receives a message that is an envelope it debatches each child of the Body Xpath node and tries to find the message type. If you have set the Root Reference it cannot find the message type, which is why you need to create your separate schema.

    A simpler way of enabling debatching, staring with the generated schema:
    1. Select <Schema> and set Envelope = Yes
    2. Select POLLINGSTMT and set Body Xpath = POLLINGSTMT/POLLINGSTMTRECORD

    There is a potential issue if you ever expect to receive a POLLINGSTMTResponse message using the Xml receive pipeline, but in your case this should not happen.

    I found a solution this afternoon. (my own question)

    The generated schema doesn’t have a root reference set. Set this to POLLINGSTMT. Set to Envelope=yes.

    I then deleted the POLLINGSTMTRECORD entry from the generated schema. I created a new schema named POLLINGSTMTRECORD, INCLUDED the original schema, named the root POLLING STMTRECORD and set it’s type to POLLINGSTMTRECORD from the generated schema. I set this new “record” to be the root node.

    I could probably have just set the root to the original entry for POLLINGSTMTRECORD. I’m going to try this next.

    I was able to successfully debatch 10 rows from oracle using this minor change for the oracle adapter.

    in reply to: Soap Adapter timeouts and other failures #21677

    Hello put your orchestation in Long Runnig mode, set a timespam, and before the message be sent, put this lines.. messagename(soapclientconectiontimeout) =  number in miliseconds.

    in reply to: Accessing a WebService from Orchestration #21676

    Hello you can see too the soaptimeconnectiontimeout and the size of the message, compare it to the maxrequestlenght into the web.config ( it must be lower).

    SCHEMA as generated, copy and paste (now that I’m at work)

    _______________________________________________________________

    <?xml version=”1.0″ encoding=”utf-8″?>
    <xs:schema xmlns:tns=”http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMTAccountPoll” elementFormDefault=”qualified” targetNamespace=”http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMTAccountPoll” version=”1.0″ xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
      <xs:complexType name=”POLLINGSTMTRECORD”>
        <xs:sequence>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”ID”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CUNO”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CTIT”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAMA”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”35″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAMB”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAMC”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAMD”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAME”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NAMF”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PSTC”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”10″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_COMP”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CREG”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PCPR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PCTX”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PCTF”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_SNDR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRTE”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”5″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CDEL”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCOR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_REFA”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_REFP”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_OSNO”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”15″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TELP”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”15″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TELX”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”15″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TEFX”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”15″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_SEAK”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”16″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CBRN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CBAN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CREP”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CFRW”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CPAY”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCRS”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CDEC”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCTY”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CLAN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCUR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CVYN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRLR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CLIN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCIC”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_RFCI”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”15″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_MREM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_EDED”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CNPA”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_ITPR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_NCIN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CINM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_INFQ”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCUS”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_BACK”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CPLS”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_SCOM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PLDD”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CFCG”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CCSU”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_FOVN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”20″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PAYM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_MSTM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_BUOR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_BUIN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_ODIS”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRYR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TOVR_x0024_1″>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TOVR_x0024_2″>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TOVR_x0024_3″>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TOVR_x0024_4″>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TOVR_x0024_5″>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CADR”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”6″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_INRL”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_ISCN”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_PRIO”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_COTP”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TRTM”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_GEOC_x0024_L”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”10″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_ACKX”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_TXTA”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRRA”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRBU”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”30″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_CRAT”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”3″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_REFCNTD”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”T_x0024_REFCNTU”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”4000″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”REFLAG” nillable=”true”>
            <xs:simpleType>
              <xs:restriction base=”xs:string”>
                <xs:maxLength value=”1″ />
              </xs:restriction>
            </xs:simpleType>
          </xs:element>
        </xs:sequence>
      </xs:complexType>
      <xs:element name=”POLLINGSTMTRECORD” nillable=”true” type=”tns:POLLINGSTMTRECORD” />
      <xs:complexType name=”ArrayOfPOLLINGSTMTRECORD”>
        <xs:sequence>
          <xs:element minOccurs=”0″ maxOccurs=”unbounded” name=”POLLINGSTMTRECORD” type=”tns:POLLINGSTMTRECORD” />
        </xs:sequence>
      </xs:complexType>
      <xs:element name=”ArrayOfPOLLINGSTMTRECORD” nillable=”true” type=”tns:ArrayOfPOLLINGSTMTRECORD” />
      <xs:element name=”POLLINGSTMT”>
        <xs:annotation>
          <xs:documentation>
            <doc:action xmlns:doc=”http://schemas.microsoft.com/servicemodel/adapters/metadata/documentation”>http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT</doc:action>
          </xs:documentation>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs=”0″ maxOccurs=”1″ name=”POLLINGSTMTRECORD” nillable=”true” type=”tns:ArrayOfPOLLINGSTMTRECORD” />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name=”POLLINGSTMTResponse”>
        <xs:annotation>
          <xs:documentation>
            <doc:action xmlns:doc=”http://schemas.microsoft.com/servicemodel/adapters/metadata/documentation”>http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT/response</doc:action>
          </xs:documentation>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence />
        </xs:complexType>
      </xs:element>
    </xs:schema>

    Thanks!

    I’ve run through this example, and needless to say the Oracle adapter gerated schema is not so elegant and easy to modify. It’s structured with an extra tier that makes this not one to one with the SQL adapter.

    responses are similar to the following:

    <POLLINGSTMT>

    <POLLINGSTMTRECORD>

    <POLLINGSTMTRECORD> … records repeat here </POLLINGSTMTRECORD>

    </POLLINGSTMTRECORD>

    </POLLINGSTMT>

     

    I think it’s the extra lvl of POLLINGSTMTRECORD giving me trouble. When I set the body XPATH to the lowest level, it complains that there is no schema named after the first entry for a datafield. When I set body XPATH to the next higher level POLLINGSTMTRECORD the message isn’t getting routed at all.

Viewing 15 posts - 3,226 through 3,240 (of 9,648 total)