Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why do all my executeXMLQuery calls fail in SoapUI?

Received Response
12
Views
1
Comments
mac2
mac2 Rank 4 - Community Specialist

Running OBIEE 11.1.1.7.140527 on linux.

Running SoapUI 5.1.3 on my Windows 7 laptop.

Step 1: Call the logon service to authenticate and establish a session:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6">
   <soapenv:Header/>
   <soapenv:Body>
      <v6:logon>
         <v6:name>my_username</v6:name>
         <v6:password>my_password</v6:password>
      </v6:logon>
   </soapenv:Body>
</soapenv:Envelope>

I get a successful response from Step 1:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v6">
   <soap:Body>
      <sawsoap:logonResult>
         <sawsoap:sessionID xsi:type="xsd:string">cusn6ah4m28ii4oi7a7q305ivrng9e1rsd457oa</sawsoap:sessionID>
      </sawsoap:logonResult>
   </soap:Body>
</soap:Envelope>

Step 2: Call XMLViewService to execute any BI request (I've tried many simple BI requests in our catalog, they all fail the same way, see below):

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6">
   <soapenv:Header/>
      <soapenv:Body>
      <v6:executeXMLQuery>
         <v6:report>
            <v6:reportPath>/shared/Demo/Standard Library/Data Analyst/Requests/Account Revenues Trend</v6:reportPath>
            
         </v6:report>
         <v6:outputFormat>SAWRowsetSchemaAndData</v6:outputFormat>
         <v6:executionOptions>
            <v6:async>false</v6:async>
            <v6:maxRowsPerPage>50000</v6:maxRowsPerPage>
           
            <v6:presentationInfo>true</v6:presentationInfo>
         
         </v6:executionOptions>
         
         <v6:sessionID>cusn6ah4m28ii4oi7a7q305ivrng9e1rsd457oa</v6:sessionID>
      </v6:executeXMLQuery>
   </soapenv:Body>
</soapenv:Envelope>

After trying to do Step 2 I get this error returned to SoapUI:

Error getting response; java.net.SocketTimeoutException: Read Timed out

Then things start to get bad in my environment. I end up with stuck threads and have to restart services to clear them. Here are some relevant log messages I see when the issue happens:

Jan 26, 2016 2:58:10 PM EST (Error)

Message ID HTTP-503
Message Level 1
REMOTE_HOST 172.20.7.79
Component ohs1
Host asicbi01
Host IP Address 192.168.220.91
Message 172.20.7.79 - - [26/Jan/2016:14:58:10 -0500] "POST /analytics/saw.dll?SoapImpl=xmlViewService HTTP/1.1" 503 205

Jan 26, 2016 3:03:10 PM EST (Error)



Message ID OHS-9999
Message Level 32
VirtualHost main
rid 0
client_id 172.20.7.79
Relationship ID 0
Component OHS
Module core.c
Host asicbi01
Host IP Address 192.168.220.91
User oracle
Thread ID 140348832077568
ECID 005A^8QsbbB2vHYVLq6UOA0007O900000l
Message ap_proxy: trying POST /analytics/saw.dll at backend host 192.168.220.91/9704; got exception 'Backend Server not responding'; state: reading status line or response headers from WLS (wrote? Y read? N); not failing over because method not idempotent

Here's the kicker: If I call ExecuteSQLQuery instead of ExecuteXMLQuery I get a good response back. I even used ExecuteSQLQuery to execute the exact logical SQL from the request path that I used in my ExecuteXMLQuery call. I've even tried running ExecuteXMLQuery for several different BI requests (all very simple requests that run immediately in the app itself).

I also have another OBIEE environment, same version and OS, where I can run ExecuteXMLQuery and get a good response back.

Any ideas?

Answers

  • mac2
    mac2 Rank 4 - Community Specialist

    This issue was caused by having this line in instanceconfig:

    <PersistPageState>false</PersistPageState>