ORA-07445: exception encountered: core dump [qksbgGetVal()+19] on running a query (Doc ID 1504275.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.2 version, when attempting to run the following query,
SELECT * FROM (SELECT JPS.FILE_DETAIL_ID,JPS.ORDER_SEQUENCE,JPS.PRODUCT_SEQUENCE,NVL(JPS.GENERATED_SEQUENCE,-1),NVL(JPS.JOB_PRODUCT_SEQUENCE,-1),P.PRODUCT_STATE,Pss.STEP_PRDN_STATUS ,P.DUE_DATE,NVL(P.PROCESS_SETUP_ID,-1), NVL(PSS.STEP_ATTEMPTS_COUNT,-1), GETPRIORITYSETUPNAME(P.PRIORITY_CODE) PRIORITY_SETUP_NAME,NVL(P.DATA_SETUP_ID,-1), NVL(P.PRODUCT_SETUP_ID,-1), NVL(ORDER_NAME,-1) FROM JOBPRODUCTSEQUENCE JPS,PRODUCT P,ORDERS O, ProductionStepStatus pss WHERE pss.IS_STEP_CURRENT=1 AND JPS.DELETED=0 AND JPS.JOB_ID=:1 AND JPS.PRODUCT_TYPE=0 AND JPS.GENERATED_SEQUENCE > (SELECT DECODE(RESTART_INDEX,0,RESTART_INDEX,-1,-1,RESTART_INDEX-1) FROM JOB WHERE JOB_ID=:2 AND RESTART_INDEX >= -1) AND JPS.FILE_DETAIL_ID=Pss.FILE_DETAIL_ID AND JPS.ORDER_SEQUENCE=Pss.ORDER_SEQUENCE AND JPS.PRODUCT_SEQUENCE=Pss.PRODUCT_SEQUENCE AND JPS.PRODUCT_TYPE=Pss.PRODUCT_TYPE AND JPS.FILE_DETAIL_ID=P.FILE_DETAIL_ID AND JPS.ORDER_SEQUENCE=P.ORDER_SEQUENCE AND JPS.PRODUCT_SEQUENCE=P.PRODUCT_SEQUENCE AND JPS.PRODUCT_TYPE=P.PRODUCT_TYPE AND Pss.step_prdn_status=2 AND O.FILE_DETAIL_ID = P.FILE_DETAIL_ID AND O.ORDER_SEQUENCE = P.ORDER_SEQUENCE ORDER BY JPS.GENERATED_SEQUENCE ASC) WHERE ROWNUM = 1
the following error occurs.

ERROR
---------
ORA-07445: exception encountered: core dump [qksbgGetVal()+19] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x141D5EDDF] [UNABLE_TO_READ] []

Stack Trace:
--------------

qksbgGetCursorVal <- kxsBindPeekEnabled <- kxsPeekBinds <- kksCompareBinds <- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip<- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real<- opimai

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