Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using OdiInvokeWebService to call a scenario via SOAP API call

3673816May 23 2018 — edited May 24 2018

Hello Group.

I am using OdiInvokeWebService step in my package that calls the OdiInvoke method. I have configured the HTTP Analyzer with a SOAP API request to call a scenario. It works fine, as long as I don't include any variables in my request. As soon as I include a variable/value pair, it stops working. Any idea why?

I need to pass the variable value during the request because the scenario

Here is what DOES work:

---------------------------------

<?xml version = '1.0' encoding = 'UTF-8'?>

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.w3.org/2005/08/addressing" xmlns:ns2="xmlns.oracle.com/odi/OdiInvoke/">

   <env:Header>

      <ns1:MessageID>uuid:7eb4cca3-b8c1-4814-96f5-d7b0d7199c85</ns1:MessageID>

      <ns1:Action>xmlns.oracle.com/odi/OdiInvoke/invokeStartScen</ns1:Action>

      <ns1:To>http://<my-ip>:15101/oraclediagent/OdiInvoke</ns1:To>

   </env:Header>

   <env:Body>

      <ns2:OdiStartScenRequest>

         <Credentials>

            <OdiUser>SUPERVISOR</OdiUser>

            <OdiPassword><my-password></OdiPassword>

            <WorkRepository>WORKREP</WorkRepository>

         </Credentials>

         <Request>

            <ScenarioName>DW000103_PKG01</ScenarioName>

            <ScenarioVersion>004</ScenarioVersion>

            <Context>GLOBAL</Context>

            <SessionName>WS_DW000103_PKG01</SessionName>

            <Keywords>OracleDIAgent</Keywords>

         </Request>

      </ns2:OdiStartScenRequest>

   </env:Body>

</env:Envelope>

Here is what DOES NOT work:

----------------------------------------

<?xml version = '1.0' encoding = 'UTF-8'?>

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.w3.org/2005/08/addressing" xmlns:ns2="xmlns.oracle.com/odi/OdiInvoke/">

   <env:Header>

      <ns1:MessageID>uuid:7eb4cca3-b8c1-4814-96f5-d7b0d7199c85</ns1:MessageID>

      <ns1:Action>xmlns.oracle.com/odi/OdiInvoke/invokeStartScen</ns1:Action>

      <ns1:To>http://<my-ip>:15101/oraclediagent/OdiInvoke</ns1:To>

   </env:Header>

   <env:Body>

      <ns2:OdiStartScenRequest>

         <Credentials>

            <OdiUser>SUPERVISOR</OdiUser>

            <OdiPassword><my-password></OdiPassword>

            <WorkRepository>WORKREP</WorkRepository>

         </Credentials>

         <Request>

            <ScenarioName>DW000103_PKG01</ScenarioName>

            <ScenarioVersion>004</ScenarioVersion>

            <Context>GLOBAL</Context>

            <SessionName>WS_DW000103_PKG01</SessionName>

            <Keywords>OracleDIAgent</Keywords>

            <Variables>

               <Name>#RES.PUBLISH_ID</Name>

               <Value>999</Value>

            </Variables>

         </Request>

      </ns2:OdiStartScenRequest>

   </env:Body>

</env:Envelope>

As you can see,  the only difference is:

            <Variables>

               <Name>#RES.PUBLISH_ID</Name>

               <Value>999</Value>

            </Variables>

Thanks

Boris

This post has been answered by 3673816 on May 24 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2018
Added on May 23 2018
1 comment
504 views