Usage tracking on OBIEE 12.2.1.2.170418

Alex Sharkov

Hi

I found usage tracking sometime work - write ok in S_NQ_ACCT

Sometimes DONT work. 

How i can resolve this issue?

[2017-06-27T14:56:44.653+06:00] [OBIS] [ERROR:1] [] [] [ecid: 005KiozCysnEwGH5yvc9yW0009Cz0004lv,0:1:1] [sik: ssi] [tid: aafb4700]  [nQSError: 17020] A bulk insert statement has successfully inserted 0 rows but failed in batch 1. Maximum batch size 11. Current batch size 1., direct path mode 0,  csv parsing mode 0, elapsed time 1 [[ file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8BulkInsert.cpp; line: 618 Properties: description= PopulateTable BulkInsertGateway Exchange; producerID=0x3da832d8; requestID=0xffffffff; sessionID=0xffffffff; Insert statement: 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_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 , ERROR_TEXT , IMPERSONATOR_USER_NAME , QUERY_BLOB , NUM_CACHE_INSERTED , NUM_CACHE_HITS , ID  ) VALUES (  :1,  :2,  ,  :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,  :30,  :31) Parameterized column values: ('???????','?i','??????','?????????1',1900-01-01 00:00:00.000,1900-01-01 00:00:00.000,'??6',1900-01-01 00:00:00.000,1900-01-01 00:00:00.000,'??6','????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????','????????????????','0','?','1','0','1','1','?','N','???','??????????????????????????ы','?????????????????????????????????????????S','???','??????','','','?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????Y','1','0','????????????????') [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist . **********  Task: 1. Running for (mls): 2 ********** Description: DbGateway InitCursor DSN:DWH_BI User Name:DWH_BI SQL: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_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 , ERROR_TEXT , IMPERSONATOR_USER_NAME , QUERY_BLOB , NUM_CACHE_INSERTED , NUM_CACHE_HITS , ID  ) **********  Task: 2. Running for (mls): 3 ********** Description: Producer Executing Query Repository Name:;Subject Area Name:;User Name: ]]

Hendrik Schmidt

Hello,

found OBIEE 11g: Usage Tracking Table S_NQ_ACCT Is Not Getting Update Anymore (Doc ID 2242627.1)

but shouldn't be the Problem?

and

OBIEE 12c - Usage Tracking Table S_NQ_DB_ACCT Exists But It Is Not Getting Populated  (Doc ID 2175738.1)

Regards

Alex Sharkov

I't strange

but we have records in S_NQ_ACCT.

but some of records OBIEE can't insert.  I's bulk insert work incorrectly? how can stop _BULK_  insert, and use simple insert?

Hendrik Schmidt

could it be related to:

Bulk Insert Failure by OBIEE 11g Usage Tracking (Doc ID 2103304.1)

Perhaps you have also a similar problem

regards