Load datawarehouse fails with oracle error ORA-00600: internal error code arguments [qkaQknLTPruneKaf:1]

book

Article ID: 144206

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG Clarity PPM On Premise

Issue/Introduction

The load data warehouse job fails with the following excerpt in the DWH log:

ERROR 2020-01-03 10:48:45,531 [DWH_DIM_FIELD_MAPPING - Table input 2] dwh.event Table input 2 - org.pentaho.di.core.exception.KettleDatabaseException: 
An error occurred executing SQL: 
SELECT CASE WHEN a.record_count > 0 THEN 1 ELSE 0 END record_exists
FROM  (SELECT COUNT(1) record_count
       FROM   DWH_TIMESHEET_V src
    WHERE (CLARITY_UPDATED_DATE IS NULL OR CLARITY_UPDATED_DATE >= to_date('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss'))) a
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [qkaQknLTPruneKaf:1], [], [], [], [], [], [], [], [], [], [], []

Environment

Release : Clarity PPM 15.4 and above.

Component :CLARITY PPM Data Warehouse

Resolution

The load data warehouse failure is not related to a configuration issue within PPM, and is related to an issue with the Oracle DB server. The same oracle error- "ORA-00600: internal error code, arguments: [qkaQknLTPruneKaf:1]" is returned while manually running the SQL query against the PPM schema:

SELECT CASE WHEN a.record_count > 0 THEN 1 ELSE 0 END record_exists
FROM  (SELECT COUNT(1) record_count
       FROM   DWH_TIMESHEET_V src
    WHERE (CLARITY_UPDATED_DATE IS NULL OR CLARITY_UPDATED_DATE >= to_date('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss'))) a;

The Oracle 12 R2 situation is described in the following Oracle Document, and the patch recommendations would need to be reviewed by the Oracle DBA. 

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2067672_1.html