Exalytics: Summary Adviser Fails With [nQSError: 16001] ODBC error state: 22003 code: -2616 message: [Teradata][ODBC Teradata Driver][Teradata Database] Numeric overflow occurred during computation. (Doc ID 1970172.1)

Last updated on FEBRUARY 15, 2015

Applies to:

Oracle Exalytics Software - Version 1.0.0.3.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When executing Summary Adviser, it fails with the below error:

[2015-01-12T13:32:08.000+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 163c] [[
[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 16001] ODBC error state: 22003 code: -2616 message: [Teradata][ODBC Teradata Driver][Teradata Database] Numeric overflow occurred during computation.
[nQSError: 16015] SQL statement execution failed.
[nQSError: 46066] Operation cancelled.
[nQSError: 46066] Operation cancelled.
[nQSError: 46066] Operation cancelled.
[nQSError: 46066] Operation cancelled.
[nQSError: 46066] Operation cancelled.
[nQSError: 46066] Operation cancelled.
[nQSError: 98001] Sampling query execution by the Advisor failed: /* Summary Advisor aggregate LTS row count query: LTS Fact Base Rated Usage Daily */
SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_CACHE_SEED=1,DISABLE_PLAN_CACHE_SEED=1,DISABLE_PLAN_CACHE_HIT=1,SA_SAMPLING_USE_EXPECTED_CARDINALITY=0,SA_DYNAMIC_SAMPLING_LEVEL=8:
select count(1) from (SELECT_PHYSICAL 1 as c1 from "CDWTest".."PRD_EDW_RPT_VIEWS"."Fact Base Rated Usage Daily" T65865 /* Fact Base Rated Usage Daily */ ) DT]]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms