Oracle Analytics Cloud and Server

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

Server error when using CASE WHEN

Received Response
159
Views
2
Comments
Rank 6 - Analytics Lead

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:

error.png

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:

error2.PNG

We can reproduce the error easily by attempting to create a formula using a "case when" statement.

error3.PNG

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

  • Rank 6 - Analytics Lead

    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

  • Rank 6 - Analytics Lead

    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.


    OK (Ignore Error)

    Any ideas?

Welcome!

It looks like you're new here. Sign in or register to get started.