An internal server error occurred when dashboard is loading.

Question

Hi,

I have some problem with two dashboards of all.

When I logged and try load dashboard for the first error: An internal server error occurred. Please try again later.

Next I refresh website and it's working fine. Other dashboard are operating normally.

If the data is already in cache it works everything perfectly.

Any suggestions?

Maybe I did something wrong in RPD?

choracy69 · Answer

Hi,

I solved the problem, however, which was in the construction of the prompt.

Request for a long time to do, to extract value from the column.

Thanks for help.

Joel Acha · Answer

Take a look at the following:

Oracle Support Document 1352697.1 (OBIEE 11g: Error: "'Unable to create a system user connection to BI Server while running user population queries" Presentation Server Fails To Start) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1352697.1

choracy69 · Answer

In sawlogn.log I found something like that:

2016-08-17T08:21:46.000+02:00] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.finalize] [ecid: 005EZtplA3zFs1wawDjc6G0002AO000c1G,0:1:1] [tid: 2078267136] An error occurred during execution of "send". Connection reset by peer [Socket:6]

2016-08-17T08:21:46.000+02:00] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.finalize] [ecid: 005EZtplA3zFs1wawDjc6G0002AO000c1G,0:1:1] [tid: 2078267136] An error occurred during execution of "send". Broken pipe [Socket:6]

2016-08-17T08:21:46.000+02:00] [OBIPS] [ERROR:16] [] [saw.rpc.server.handleConnection] [ecid: 005EZtRI1KWFs1wawDjc6G00079d000018,0:3] [tid: 2078267136] Exception in handler thread. An error occurred during execution of "send". Broken pipe [Socket:6]

Or something like that:

2016-08-17T08:13:01.000+02:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getroles] [ecid: 005EZtREAV8Fs1wawDjc6G00079d000000,0:1] [tid: 2012346112] Error retrieving user/group data from Oracle BI Server's User Population API. Unable to create a system user connection to BI Server while running user population queries

Odbc driver returned an error (SQLDriverConnectW).

State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller   or the secondary Cluster Controller () specified for the clustered DSN. (HY000)