ODBC
Errors - Application & System Issues (Analytics & Noetix) |
Technical
Solution, Workaround & Guidance for OBI & Noetix Team |
Noetix - Insufficient
Privileges - Any User - First Time Access to Shared folders |
Check 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 |