OBIEE 11g: Error: "[nQSError: 17001] Oracle Error code: 1704, message: ORA-01704: string literal too long" with Usage Tracking (Doc ID 1274586.1)

Last updated on JULY 13, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] to 11.1.1.6.12 [Release 11g]
Information in this document applies to any platform.
This knowledge document is a replacement for 1355818.1 which has been deleted.


Symptoms

When using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, an intermittent error occurs with Usage Tracking.

Excerpt from the NQServer.log shows:

[nQSError: 17001] Oracle Error code: 1704, message: ORA-01704: string literal too long
at OCI call OCIStmtExecute: INSERT INTO S_NQ_ACCT (USER_NAME, REPOSITORY_NAME, SUBJECT_AREA_NAME, NODE_ID, START_TS, START_DT, START_HOUR_MIN, END_TS, END_DT, END_HOUR_MIN, QUERY_TEXT, QUERY_BLOB, QUERY_KEY, SUCCESS_FLG, ROW_COUNT, TOTAL_TIME_SEC, COMPILE_TIME_SEC, NUM_DB_QUERY, CUM_DB_TIME_SEC, CUM_NUM_DB_ROW, CACHE_IND_FLG, QUERY_SRC_CD, SAW_SRC_PATH, SAW_DASHBOARD, SAW_DASHBOARD_PG, PRESENTATION_NAME, IMPERSONATOR_USER_NAME, NUM_CACHE_INSERTED, NUM_CACHE_HITS) VALUES('ZPARK','Star','Leads','mt-050',TO_DATE('2010-12-14 14:48:26' , 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2010-12-14 00:00:00' , 'YYYY-MM-DD HH24:MI:SS'),'14:48',TO_DATE('2010-12-14 14:48:26' , 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2010-12-14 00:00:00' , 'YYYY-MM-DD HH24:MI:SS'),'14:48','SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10 FROM ( SELECT 0 s_0, "Leads"."Customer"."Party Name" s_1, ...

This error does not occur with every query.
Most inserts into the Usage Tracking tables occur without error, but when a long query string is generated, the insert fails with the the ORA error shown above.

This error may occur in OBIEE 11.1.1.5, or OBIEE 11.1.1.6 versions.

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