Latest News

Tuesday, March 29, 2016

OBIEE ODBC Errors / Application / System Issues and Solutions


Below are a List of OBIEE ODBC Error Codes and Description along with the Suggested Technical Solutions and Workarounds.








ODBC Errors Codes / Application & System Issues (Analytics) Suggested Technical Solution / Workaround  (OBIEE)
Noetix - Insufficient Privileges - Any User - First Time Access to Shared foldersCheck the AD groups Association and clear the browser cache and
  try.
Analytics: [nQSError:
  96002] Essbase Error: Unknown Member- for the report/ page/ dashboard
Validate the correct member and change the filter as
  required in the report.
Analytics:[nQSError:
  46118] Out of disk space.
Database is down or the OBI Server tmp file size has
  reached its limit
Analytics:[nQSError:
  96002] Essbase: Query is allocating too large memory ( > 4GB)
Put default values to Prompt  to restrict the
  Record set for the MDX sent to obi
Analytics:[nQSError:
  17012] Bulk fetch failed. -Oracle Error code: 1013
Oracle Error - Get the Physical SQL execute in Toad to
  get the Error and fix it
Analytics:[nQSError:
  14050] Internal Error: could not find level detailed enough for GROUP BY
  clause
Its OBI Presentation Error tweak the Aggregation Rule
  and column formula
Analytics:[nQSError:
  14025] No fact table exists at the requested level of detail: 
Fix the Consistency warning in the RPD and deploy
Analytics:[nQSError: 14046] No physical join relationships exist between any of the following tables:Fix the Consistency warning in the RPD and deploy
Analytics:[nQSError:
  14070] Cannot find logical table source coverage for logical columns:
  [Amount].
The logical column mapping for the column is missing in
  the business layer
Analytics:[nQSError:
  15018] Incorrectly defined logical table source 
Check the Business model and apply the fix for warning
  as required - Data model
Analytics:[nQSError:
  16001] ODBC error [DataDirect][ODBC PostgreSQL Wire Protocol driver]Socket
  closed.
Destination Server was down - check the server , port
   of the PostgreSQL
Analytics:[nQSError: 17010]- ORA-01031: insufficient privileges, invalid identifier,  Bulk fetch failed.Check the DB object for the column being present in the
  table
Analytics:[nQSError:
  17014] Could not connect to Oracle database.
Database Down , Tns Error, basic connectivity issue
Analytics:[nQSError:
  23006] The session variable, NQ_SESSION. has no value definition.
Check the default Value and also the underlying SQL in
  the IB
Analytics:[nQSError:
  96002] Essbase Error: Request [MdxReport] terminated since it exceeded the
  time limit
Its configuration set at the essbase admin to kill the
  long running sessions
Analytics:[nQSError:
  46118] Out of disk space.
Check the Memory configuration @ Essbase & Obi
  Server Level to overcome
Analytics: [nQSError:
  46017] Sort has no work space in the work directory.
The Tmp directory set in the obi configuration has
  reached its limits - privilege
Analytics:[nQSError:
  46066] Operation cancelled.
Close Cursor, cancel running request  by
  Administrator
Analytics:[nQSError:
  60009] The user request exceeded the maximum query governing execution time.
Long running MDX, SQL's send to the Data source being
  killed by server
Analytics:[nQSError:
  46073] Operation ''write() tmp dir No such file or directory.
Check the Write privilege to the tmp dir setting in the
  OBI - NQSconfig
Analytics:[nQSError:
  17014] ORA-12154: TNS:could not resolve the connect identifier 
Check the basic setting of connection to Oracle DB
Analytics:[nQSError:
  17010] message: ORA-00910: specified length too long for its datatype at OCI
  call 
check the data type & Size of the column in
  physical layer of RPD and change
Analytics:[nQSError:
  59107] Set operation failed due to incompatible sort order.
validate the union reports and apply the correct sor
  order for the column
Analytics:[nQSError:
  42015] Cannot function ship the following expression: 
Tweak the column formula, apply the aggregation rule,
  get the MDX, Physical SQL
Analytics:[nQSError:
  96002] Essbase Error: Invalid login id - please login again
Check the Essbase server connectivity Details
Analytics:[nQSError:

  96002] Essbase Error: Network errorA descendent member of the expected level
  is returned. 
Check the Essbase hierarchy for the members being
  displayed in the report
Analytics:[nQSError:
  96002] Essbase Error: Network error: Timed out before receiving all data
Essbase Connectivity Issue - Check server, port,
  application, cube
Analytics:[nQSError:
  96002] Essbase Error: Application

  currently not accepting connections
Either the cube refresh / switch is in progress and obi
  application
Analytics:[nQSError:
  96002] please check if you tried to connect to secure port
Server Config and Validation of the setting based on
  the data source connect
Analytics:[nQSError:
  59011] OverFlow occurred during the execution of AddFloat. 
Tweak the column formula , try conversion, check the
  SQL in Oracle
Analytics:[nQSError:
  96002] Essbase Error: Not enough memory for formula Set MAXFORMULACACHESIZE
Essbase.cfg- Tweak the setting in the Essbase Server
Analytics:[nQSError:
  17010] ORA-00980: synonym translation is no longer valid
Validate or recreate the synonym as required for the
  object used in the report
Analytics:[nQSError:
  46104] The current operation was about to overflow the stack. 
Get the Physical SQL , make it wok in Toad , and
  translate the fix on obi
Analytics:[nQSError:
  17010] ORA-00932: inconsistent datatypes: expected - got CLOB
Convert the  data type in column formula
   apply the size and then try
Analytics:[nQSError:
  22023] An arithmetic operation is being carried out on a non-numeric type.
Validate the column formula and apply the data type
  conversion operations
Analytics:[nQSError:
  22025] Function TimestampAdd is called with an incompatible type.
Validate the column formula and apply the data type
  conversion operations
Analytics:[nQSError:
  23006] The session variable, NQ_SESSION.SRR_QTR, has no value definition.
Check the SQL, default Value in the IB in the RPD of
  OBIEE.
Analytics:[nQSError:
  96002] Essbase Error: Administrator Has Temporarily Disabled User Commands
Essbase, server, application, cube is down or
   under maintenance
  • Google+
  • Pinterest
« PREV
NEXT »

1 comment

  1. Running report in OBIEE 12C getting error Analytics: [nQSError:
    96002] Essbase Error: Unknown Member.
    What could be the reason for this error how to resolve.
    Thanks

    ReplyDelete