Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Why do all my executeXMLQuery calls fail in SoapUI?

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
-
This issue was caused by having this line in instanceconfig:
<PersistPageState>false</PersistPageState>
0