Oracle® Business Intelligence Applications Installation and Configuration Guide > Troubleshooting Oracle Business Intelligence Applications > Executing Oracle Business Analytics Warehouse Exception Reports >

Oracle BI Interactive Dashboard Issues


Table 97 provides information about problems and solutions related to Oracle BI Interactive Dashboards.

Table 97. Oracle BI Dashboard Issues
Symptom/Error Message
Probable Cause/Solution

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P File: ./project/webodbcaccess/odbcstatementimpl.cpp, Line: 186 State: S1000. Code: 10058. [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 4030, message: ORA-04030: out of process memory when trying to allocate 246284 bytes (hash-join subh,kllcqas:kllsltba) at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (S1000)

This is caused by a shortage of RAM on a dedicated (non shared server) environment. Depending on the Oracle version, the options for DBAs are:

  • Increase pga_aggregate_target.
  • Decrease sort_area_size and/or hash_area_size.
  • Move to multi-threaded server (a.k.a. MTS or shared servers).

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.