ALM 8.1.2.2 Process Fails With Multiple ORA Errors And Core Dump When Process Tuning Is Enabled And TP Method Is Selected (Doc ID 2990133.1)

Last updated on DECEMBER 20, 2023

Applies to:

Symptoms

When Process Tuning is configured, a few random id_numbers crashing and generating core dump. When a Deal (ID_NUMBER) is crashing, the entire product gets eliminated from result set.
If Process Tuning is set, the ALM process completes for all the Products.

All options of process tuning was tested, without slicing and with slicing, dedicated and cooperative same behavior, process fails with core dump:

LOG ERROR:
-----------------------

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 3106 ORA- 03106: fatal two- task communication protocol error SQL:
select FSI_D_PAYMENT_SCHEDULE.id_number,
FSI_D_PAYMENT_SCHEDULE.payment_date,
FSI_D_PAYMENT_SCHEDULE.instrument_type_cd,
FSI_D_PAYMENT_SCHEDULE.amount,
FSI_D_PAYMENT_SCHEDULE.identity_code
from FSI_D_PAYMENT_SCHEDULE
where FSI_D_PAYMENT_SCHEDULE.instrument_type_cd = 110.00000
and id_number = ' 481XXX9'
and FSI_D_PAYMENT_SCHEDULE.identity_code = 20230331.00000
order by FSI_D_PAYMENT_SCHEDULE.payment_date


Module Logging OFS errors: (905002) Child died with signal 6.
Module Logging OFS errors: (905001) Child dumped core.

Module Logging OFS errors: (203105) Oracle drv_oci error: Disconnect: Not all ORACLE driver copies destroyed!

Console ERROR:
-----------------------

Error:
| strBatchId : INFODOM_XXXXX0527_1 | strComponentId :
Asset Liability Management | Process ID : 203611 | User ID : ALMADMIN |

ProcSysID = 203611
Warning: iso88951 does not exist.
Running Oracle ALM, Process Rule: 203611 Engine started execution
Warning: iso88951 does not exist.
Running Oracle ALM, Process Rule: 203611 Engine started execution
Warning: iso88951 does not exist.
Running Oracle ALM, Process Rule: 203611 Engine started execution
Warning: iso88951 does not exist.
Running Oracle ALM, Process Rule: 203611 Engine started execution
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f24e48bd89a, pid=113527, tid=0x00007f24eb9a4d80
#
# JRE version: Java(TM) SE Runtime Environment (8.0_333-b02) (build
1.8.0_333-b02)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.333-b02 mixed mode
linux-amd64 compressed oops)
# Problematic frame:
# C [libclntsh.so.19.1+0x319389a] ttcfopr+0xea


OCI Error: 3106
ORA-03106: fatal two-task communication protocol error
SQL: select
FSI_D_PAYMENT_SCHEDULE.id_number,FSI_D_PAYMENT_SCHEDULE.payment_date,FSI_D_PAY
MENT_SCHEDULE.instrument_type_cd,FSI_D_PAYMENT_SCHEDULE.amount,FSI_D_PAYMENT_S
CHEDULE.identity_code from FSI_D_PAYMENT_SCHEDULE where
FSI_D_PAYMENT_SCHEDULE.instrument_type_cd = 110.00000 and id_number = '
48XXXX70' and FSI_D_PAYMENT_SCHEDULE.identity_code =
20230527.00000 order by FSI_D_PAYMENT_SCHEDULE.payment_date
Error(Oracle Financial Services Application error) (905002) Child died with
signal 6.
Error(Oracle Financial Services Application error) (905001) Child dumped
core.
Running Oracle ALM, Process Rule: 203611 Engine started execution
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f24e48bd89a, pid=113527, tid=0x00007f24eb9a4d80
#
# JRE version: Java(TM) SE Runtime Environment (8.0_333-b02) (build
1.8.0_333-b02)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.333-b02 mixed mode
linux-amd64 compressed oops)
# Problematic frame:
# C [libclntsh.so.19.1+0x319389a] ttcfopr+0xea


OCI Error: 3146 ORA-03146: invalid buffer length for TTC field SQL: select
FSI_D_PAYMENT_SCHEDULE.id_number,FSI_D_PAYMENT_SCHEDULE.payment_date,FSI_D_PAY
MENT_SCHEDULE.instrument_type_cd,FSI_D_PAYMENT_SCHEDULE.amount,FSI_D_PAYMENT_S
CHEDULE.identity_code from FSI_D_PAYMENT_SCHEDULE where
FSI_D_PAYMENT_SCHEDULE.instrument_type_cd = 110.00000 and id_number = '
481XXXX12' and FSI_D_PAYMENT_SCHEDULE.identity_code =
20230527.00000 order by FSI_D_PAYMENT_SCHEDULE.payment_date
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f24e48bd89a, pid=113527, tid=0x00007f24eb9a4d80
#
# JRE version: Java(TM) SE Runtime Environment (8.0_333-b02) (build
1.8.0_333-b02)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.333-b02 mixed mode
linux-amd64 compressed oops)
# Problematic frame:
# C [libclntsh.so.19.1+0x319389a] ttcfopr+0xea

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.