Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Server error when using CASE WHEN

Hi all,
We are currently using OBIEE 11.1.1.7.171017 and have just started to notice a strange issue when trying to use the CASE WHEN formula inside analysis formulas, prompt SQL and BIP data models.
The error returned is as follows:
We also get the following error message in Chrome Tools:
Failed to load resource: the server responded with a status of 500 (Internal Server Error) at /analytics/saw.dll?ResolveActionXML
Another error in the logs:
We can reproduce the error easily by attempting to create a formula using a "case when" statement.
The full text of that error message is as follows:
There was a problem retrieving the response data: Internal Server Error (500).
Third-party server not responding.
The resource you have requested is located on a third-party server. WebSEAL has attempted to send your request to that server, but it is not responding.
Explanation
This could be due to the third-party server being offline, or to network problems making it unreachable. The problem is not with the WebSEAL server itself.
Solutions
Retry your request later, or contact the system administrator for assistance.
Both app and OHS servers have been restarted and no changes were made to either on the day the error started occurring.
Any help would be greatly appreciated.
Thanks in advance,
Adam
Answers
-
A bit more information.
This from the ohs.log file straight after attempting to run the case statement.[2018-02-07T10:18:43.8369+11:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: SERVERNAME] [host_addr: xx.xx.xx.xx] [pid: 5544] [tid: 2308] [user: SYSTEM] [VirtualHost: SERVERNAME.DMZ.INT:4443] ap_proxy: trying POST /analytics/saw.dll at backend host xx.xx.xx.xx/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, referer: https://reporting.com.au/analytics/saw.dll?Answers&SubjectArea=%22reporting%20Development%22
0 -
Can confirm that this is an issue between our OHS and Application server as I have replicated the error logging directly into the OHS and attempting to create a formula using "CASE (IF)".
The error message returned is:Formula syntax is invalid.
There was a problem retrieving the response data: Service Temporarily Unavailable (503).
Failure of server APACHE bridge:
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.
Any ideas?
0