0 Replies Latest reply on Aug 25, 2013 3:47 PM by Hola

    S_NQ_DB_ACCT not populating

    Hola

      Hi all,

       

      I manage to set up usage tracking on OBIEE 11.1.1.7.0. I am able to get records in the table  S_NQ_ACCT, however S_NQ_DB_ACCT is not working. I found why is not working, but I am not sure how to fix it. In the nqserver.log I am getting the error message:

       

      [2013-08-25T10:23:56.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 51b20baf5af39d61:5f43a5d1:140b5bda6ac:-8000-00000000000005fc] [tid: 14fc]  [nQSError: 17011] SQL statement execution failed. [[

      [nQSError: 17001] Oracle Error code: 2291, message: ORA-02291: integrity constraint (TEST2_BIPLATFORM.FK_S_NQ_DB_ACCT) violated - parent key not found

      at OCI call OCIStmtExecute: INSERT INTO S_NQ_DB_ACCT (ID,LOGICAL_QUERY_ID,QUERY_TEXT,QUERY_BLOB,TIME_SEC,ROW_COUNT,START_TS,START_DT,START_HOUR_MIN,END_TS,END_DT,END_HOUR_MIN) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12).

      ]]

       

      I'll appreciate your help.

       

      Thanks.