obiee analytics page 500 Error — Oracle Analytics

Oracle Business Intelligence Applications

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

obiee analytics page 500 Error

Received Response
30
Views
3
Comments

Hi

I recently applied patches on OBIEE 11.1.1.9.191015 patch and had to roll back for some reason. Since this activity I am not able to get the 'analytics' page. I get 500 , Internal server error.

All the deployments have started fine and they are in Active mode.

These are the logs I could gather and find errors in

NQSServer.log

[2019-12-18T14:41:03.371+04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 19bc]  [nQSError: 46073] Operation 'GetFileAttributes()' on file '' failed with error: (3) The system cannot find the path specified.. [[

file: server\Utility\Generic\File\SUGFileUtility.cpp; line: 55

]]

[2019-12-18T14:41:03.557+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 19bc]  [36007] Loading repository D:\Oracle\OBI\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\SampleAppLite_BI0003.rpd.

[2019-12-18T14:41:03.729+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iy8tTLjgZFw0zurI04Zz3dfrU2j^2wb0001JO00000c,0] [tid: 1c70]  [14055] Loading subject area: SampleApp Lite ...

[2019-12-18T14:41:03.736+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iy8tTLjgZFw0zurI04Zz3dfrU2j^2wb0001JO00000c,0] [tid: 1c70]  [14056] Finished loading subject area: SampleApp Lite.

[2019-12-18T14:41:04.612+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 19bc]  [85003] MDX Member Name Cache subsystem started successfully.

[2019-12-18T14:41:04.613+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 19bc]  [85004] MDX Member Name Cache subsystem recovered entries: 0, size: 0 bytes.

[2019-12-18T14:41:04.622+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 19bc] nqsserver: Clustered Oracle BI Server (64-bit) started.  Version: 11.1.1.9.0.

[2019-12-18T14:41:07.703+04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iy8tT^wdiFw0zurI04Zz3dfrU2j^2wb0001JO00001V,0] [tid: 1f10]  [43071] A connection with Cluster Controller SERVERNAME:9706 was established.

[2019-12-18T14:41:34.885+04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iy8tTPBS3Fw0zurI04Zz3dfrU2j^2wb0001JO00000j,0] [tid: 1d2c]  [nQSError: 12002] Socket communication error at call=Read: (Number=10054) An existing connection was forcibly closed by the remote host. [[

file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 939

Any help would be great. Thanks

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    First things first: is the deployment even up?

  • Anjum Ara
    Anjum Ara Rank 4 - Community Specialist

    Yes, all the deployments are up.

  • persona4-77
    persona4-77 Rank 3 - Community Apprentice

    Are you sure you are using the right user with the right roles ?

    I had a similar problems after merging from 11g to 12c.

    The role plus the security made impossible to me to reach the analytics page from my old url.  For me it gave error 500.  I had to log in an other account prior to be enable to access the target page,

    Please check your roles an user for your new working environment.