OBIEE 11g [ Error 500 -- Internal Server Error ]

2773333 · Oct 20, 2016 1:54AM

Hi

I tried to upload the RPD from production environment to the TEST environment to make a clone copy of production in Test. Once I uploaded the RPD in Enterprise manager and restarted all the services the restart was successful and all the components (admin server, manager server and opmn) is up and running with green.

But when I open the analytics page it throws me this error

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.

After some R&D in the internet, I checked the Oracle process manager and it was in a running state. I tried to open the analytics with multiple RPD but it still throws same issue.

Kindly assist.

Regards

Vyshak P

Pedro F · Oct 20, 2016 3:26AM

Check the logs, otherwise you won't be able to solve the issue and we won't be able to help you since we can't really guess what went wrong with your system. Besides, even if you solve the issue by trying multiple things, you'll never know what went wrong.

2773333 · Oct 20, 2016 3:57AM

Hi Pedro

Are you asking me to check the sawlog ?

Regards

Vyshak

Pedro F · Oct 20, 2016 5:31AM

If all services are running as you say then yes, check your sawlogX.log and nqserver.log

cesar.advincula.o · Oct 20, 2016 10:27AM

To add what Pedro said, check your deployments, the state should be "Active" in Web Logic Server Administration Console, and tell us about the logs

Screen Shot 2016-10-20 at 9.26.27 AM.png

GermanA-Oracle · Oct 20, 2016 1:14PM

The Error 500 is seen when the plugin (/analytics) is not able to connect to the presentation server. You have to:

Check that the presentation server is running (opmnctl status on 11g or status.sh on 12c)
Check the presentation server logs and see if there are any error(s)

HTH,

German

Dieguinho · Oct 20, 2016 5:03PM

Hi,

Please check the version of 2 environments (Sometimes if you have a different version, the RPD fail).

Regards.

2773333 · Oct 23, 2016 6:51AM

Hi

I have attached the log information below.

[2016-10-23T13:44:22.000+04:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] Error connecting to the Oracle BI Server: Could not connect to the Oracle BI Server because it is not running or is inaccessible. Please contact your system administrator.

Odbc driver returned an error (SQLDriverConnectW).

Any luck ?

Regards

Vyshak

Joel · Oct 23, 2016 7:06AM

Hi @2773333

2 things. The error indicates that the BI Server is down. Could you provide the errors logged in the NQServer.log file. Secondly, what is the status of the OPMN components when you check on the server using the opmnctl status command?

cesar.advincula.o · Oct 25, 2016 3:02PM

1. Check in Administration Console, you bi_server1 are RUNNING;

Screen Shot 2016-10-25 at 2.02.50 PM.png

2. Check your deployment are "Active"

Screen Shot 2016-10-25 at 2.00.37 PM.png

3. Check Availability of the BI Processes

Screen Shot 2016-10-25 at 2.01.40 PM.png

Dieguinho · Oct 25, 2016 4:26PM

Hi,

Just try to check services, like cesar.advincula.o said.

Please check version and release of your environments, They must be the same.

Regards.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

OBIEE 11g [ Error 500 -- Internal Server Error ]

Error 500--Internal Server Error

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

10.5.1 500 Internal Server Error

Answers