OBIEE 11g: Error: "[nQSError: 17011] SQL statement execution failed. [nQSError: 17001] Oracle Error code: 1400, message: ORA-01400: cannot insert NULL into ("DEV2_BIPLATFORM"."S_NQ_ACCT"."ID")" (Doc ID 1437343.1)

Last updated on OCTOBER 25, 2013

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Oct-2013***

Symptoms

When you use usage tracking, you get the following error:

  
2012-03-12T16:48:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 196d9155ffe074ed:b1ba6b4:13607b901b6:-8000-0000000000002f45] [tid: b2020b90] [nQSError: 17011] SQL statement execution failed. [[
[nQSError: 17001] Oracle Error code: 1400, message: ORA-01400: cannot insert NULL into ("DEV2_BIPLATFORM"."S_NQ_ACCT"."ID")
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(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29).
]]
  

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