none
biztalk Argument /SQLEXECUTE/SQLEXECUTE is invalid - Oracle Send Port RRS feed

  • Question

  • Hi  I have a composite Schema that looks like this:

    <?xml version="1.0" encoding="utf-16"?>
    <xs:schema xmlns="http://Comverse.ConcertoSyncSST.QueryOracleComposite" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns:ns1="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE" xmlns:ns0="http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS" targetNamespace="http://Comverse.ConcertoSyncSST.QueryOracleComposite" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      <xs:import schemaLocation=".\CompositeOpSQLEXECUTE.xsd" namespace="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE" />
      <xs:import schemaLocation=".\CompositeOpAPPS.View.CNS_CONCERTO_PROJECTS.xsd" namespace="http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS" />
      <xs:annotation>
        <xs:appinfo>
          <b:references>
            <b:reference targetNamespace="http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS" />
            <b:reference targetNamespace="http://Microsoft.LobServices.OracleDB/2007/03" />
            <b:reference targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
            <b:reference targetNamespace="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE" />
          </b:references>
        </xs:appinfo>
      </xs:annotation>
      <xs:element name="Send">
        <xs:annotation>
          <xs:appinfo>
            <b:properties>
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='Select' and namespace-uri()='http://Comverse.ConcertoSyncSST.OracleDBBindingAPPS.View.CNS_CONCERTO_PROJECTS']/*[local-name()='COLUMN_NAMES' and namespace-uri()='http://Comverse.ConcertoSyncSST.OracleDBBindingAPPS.View.CNS_CONCERTO_PROJECTS']" />
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='Select' and namespace-uri()='http://Comverse.ConcertoSyncSST.OracleDBBindingAPPS.View.CNS_CONCERTO_PROJECTS']/*[local-name()='FILTER' and namespace-uri()='http://Comverse.ConcertoSyncSST.OracleDBBindingAPPS.View.CNS_CONCERTO_PROJECTS']" />
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='SQLEXECUTE' and namespace-uri()='http://Comverse.ConcertoSyncSST.MaxDateQuerySQLEXECUTE']/*[local-name()='SQLSTATEMENT' and namespace-uri()='http://Comverse.ConcertoSyncSST.MaxDateQuerySQLEXECUTE']" />
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='Select' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS']/*[local-name()='COLUMN_NAMES' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS']" />
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='Select' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS']/*[local-name()='FILTER' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS']" />
              <b:property distinguished="true" xpath="/*[local-name()='Send' and namespace-uri()='http://Comverse.ConcertoSyncSST.QueryOracleComposite']/*[local-name()='SQLEXECUTE' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE']/*[local-name()='SQLSTATEMENT' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE']" />
            </b:properties>
          </xs:appinfo>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ns0:Select" />
            <xs:element ref="ns1:SQLEXECUTE" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="Receive">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ns0:SelectResponse" />
            <xs:element ref="ns1:SQLEXECUTEResponse" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:schema>

    now the message i'm sending to Oracle is :

    <ns0:Send xmlns:ns0="http://Comverse.ConcertoSyncSST.QueryOracleComposite"> <ns1:Select xmlns:ns1="http://Microsoft.LobServices.OracleDB/2007/03/APPS/View/CNS_CONCERTO_PROJECTS"> <ns1:COLUMN_NAMES>PROJECT_NUMBER,PROJECT_NAME,CUSTOMER_NAME,PRODUCT_NAME,PM_NAME,DIVISION_NAME,REGION_NAME,SST_CREATION_DATE,SST_MODIFIED_DATE</ns1:COLUMN_NAMES> <ns1:FILTER>SST_CREATION_DATE &gt; TO_DATE('1/5/2014 10:0:0', 'DD/MM/YYYY HH24:MI:SS') AND (SST_MODIFIED_DATE &gt; TO_DATE('1/5/2014 10:0:0', 'DD/MM/YYYY HH24:MI:SS') AND SST_MODIFIED_DATE &lt; sysdate)</ns1:FILTER> </ns1:Select> <ns2:SQLEXECUTE xmlns:ns2="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE"> <ns2:SQLSTATEMENT>select greatest(MAX(SST_CREATION_DATE), MAX(SST_MODIFIED_DATE)) from cns_concerto_projects</ns2:SQLSTATEMENT> <ns2:PARAMETERSCHEMA> </ns2:PARAMETERSCHEMA> <ns2:PARAMETERSET> <ns3:PARAMETERDATA xmlns:ns3="http://Microsoft.LobServices.OracleDB/2007/03"> <ns3:PARAMETER> <ns4:string xmlns:ns4="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> </ns4:string> </ns3:PARAMETER> </ns3:PARAMETERDATA> </ns2:PARAMETERSET> </ns2:SQLEXECUTE> </ns0:Send>

    and here's the error i'm getting:

    A message sent to adapter "WCF-Custom" on send port "WcfSendPort_OracleDBBinding_Multiple_Custom" with URI "oracledb://test11i/" is suspended. 
     Error details: Microsoft.ServiceModel.Channels.Common.MetadataException: Argument /SQLEXECUTE/SQLEXECUTE is invalid.

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result) 
     MessageId:  {5D21F00C-9BCB-4E8D-A024-DB9CE59261D3}
     InstanceID: {9ED8E94D-1CE9-40DF-B54E-3CC023F77926}

    Does any body has an idea why? doe's my SQLEXECUTE query wrong by not putting any parmeters in the paremter tag?

    Sunday, May 11, 2014 2:02 PM

All replies