7 Replies Latest reply on Sep 19, 2015 7:21 AM by kt1

    OBIEE Analytics is not coming up, Its throwing 500 Error

    2753252

      Hi Gurus,

       

      We are having issue with OBIEE Analytics Page:

      Error 500--Internal Server Error

      From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:

      10.5.1 500 Internal Server Error

      The server encountered an unexpected condition which prevented it from fulfilling the request.



      Admin and Managed BI Server are running.

      OPMN all services are Alive.

       

      We are able to login to EM and Console.

      But Analytics throwing Error 500.

       

      When we checked with EM and found Deployments are Down.

       

       

      Can any one please suggest possible Solution for this issue.

       

      Nqs Log:

       

      [2015-09-16T03:26:07.000-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 6628f250] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

      [2015-09-16T03:26:11.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250]  [36007] Loading repository /app/oracle/Middleware/11.1.1/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/TEST_BI0014.rpd.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqbJPmDOdQLQao2yd0004Tk00000g,0] [tid: 43cad940]  [14055] Loading subject area: Alarm Monitor ...

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqbJZtDOdQLQao2yd0004Tk00000i,0] [tid: 43dae940]  [14055] Loading subject area: Usage Tracking ...

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqbJZtDOdQLQao2yd0004Tk00000i,0] [tid: 43dae940]  [14056] Finished loading subject area: Usage Tracking.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqbJPmDOdQLQao2yd0004Tk00000g,0] [tid: 43cad940]  [14056] Finished loading subject area: Alarm Monitor.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqbYvNDOdQLQao2yd0004Tk00000o,0] [tid: 41e5b940]  [16020] Metadata Database Type: Oracle 11g [[

      Data Source Name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rsodbpu03.ers.na.emersonclimate.org)(PORT=1501)))(CONNECT_DATA=(SID=edwdb)))

      Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64b

      ]]

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 6628f250]  [nQSError: 43123] Query log for some users are enabled, performance may decreased

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 6628f250]  [nQSError: 23006] The session variable, NQ_SESSION.DISPLAYNAME, has no value definition. [[

      [nQSError: 43059] Init block 'ActiveSitesFL': Dynamic refresh of repository scope variables has failed.

      ]]

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 6628f250]  [43143] Blacklisted connection pool: '"DB_EDWR"."CP_EDWR"'

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250]  [58002] Query Cache loaded with 17 entries from saved cache files.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250]  [85003] MDX Member Name Cache subsystem started successfully.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250]  [85004] MDX Member Name Cache subsystem recovered entries: 0, size: 0 bytes.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 6628f250] An error message was received from the BI Security Service: PolicySet Invalid: WSM-06102 PolicyReference The policy reference URI "oracle/no_authentication_service_policy" is not valid.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 6628f250]  [13026] Error in getting roles from BI Security Service:  'An error message was received from the BI Security Service: PolicySet Invalid: WSM-06102 PolicyReference The policy reference URI "oracle/no_authentication_service_policy" is not valid. '

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250]  [46172] Database security store is not available, do not re-associate to this provider type.

      [2015-09-16T03:26:13.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 6628f250] nqsserver:    Clustered Oracle BI Server (64-bit) started.  Version: 11.1.1.7.141014.

      [2015-09-16T03:26:17.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 0057xWqqDONDOdQLQao2yd0004Tk00001^,0] [tid: 43cad940]  [43071] A connection with Cluster Controller rsobitl02:9706 was established.

      [2015-09-16T03:32:56.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0057xWqSkFwDOdQLQao2yd0004Tj000000,0:82:6] [tid: 447b8940] PolicySet Invalid: WSM-06102 PolicyReference The policy reference URI "oracle/no_authentication_service_policy" is not valid.

      [2015-09-16T03:32:56.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0057xWqSkFwDOdQLQao2yd0004Tj000000,0:82:6] [tid: 447b8940]  [nQSError: 43126] Authentication failed: invalid user/password.

       

      Thanks,

      Sri