obiee analytics page 500 Error

Question

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

persona4-77 · Answer

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.

Anjum Ara · Answer

Yes, all the deployments are up.

[Deleted User] · Answer

First things first: is the deployment even up?