An internal server error occurred when dashboard is loading.

choracy69

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?

Joel

Hi @choracy69

Have you taken a look at the BI Server log file (nqserver.log) as well as the Presentation Services log file (sawlogn.log)? These may give you some more detail of what the issue might be.

choracy69

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)

Joel

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

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.