ORA-07445: exception encountered: core dump [pfrinstr_INHFA1()+1524] [SIGSEGV]
(Doc ID 2453413.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
Oracle Communications Order and Service Management - Version 7.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
The customer is getting the following exception when they are creating an order:
<Sep 13, 2018 10:10:22 AM EDT> <Notice> <Stdout> <BEA-000000> < 10:10:22 AM EDT> <Error>
<oracle.communications.ordermanagement.ws.CreateOrderBySpecificationOperationI
mpl> <BEA-000000> <Error processing createOrderBySpecification
com.mslv.oms.handler.InternalErrorException: No more data to read from socket
: No more data to read from socket
at
com.mslv.oms.handler.AbstractHandlerEJB.processRequest(AbstractHandlerEJB.java
:122)
at
com.mslv.oms.handler.createorder.CreateOrderHandlerEJB.process(CreateOrderHand
lerEJB.java:167)
at
com.mslv.oms.handler.AbstractHandlerEJB.processRequest(AbstractHandlerEJB.java
:117)
We turned on the alert and trace logs and on the DB side and received the error in the Alert Log:
Fri Sep 14 10:09:27 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0]
[PC:0xCF2B184, pfrinstr_INHFA1()+1524] [flags: 0x0, count: 1]
Errors in file
/<DIR>/trace/xxxx_ora_25565.trc
(incident=338623):
ORA-07445: exception encountered: core dump [pfrinstr_INHFA1()+1524]
[SIGSEGV] [ADDR:0x0] [PC:0xCF2B184] [Address not mapped to object] []
ORA-01403: no data found
Which is then further traced to:
*** 2018-09-14 10:18:51.568
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3,
mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=1684n96u5h0f9) -----
BEGIN
om_handler_pkg.sql_order_transition(
a_order_seq_id => :1 ,
a_hist_seq_id => :2 ,
a_hist_seq_id_new => :3 ,
a_parent_hist_seq_id_new => :4 ,
a_new_ord_state_id => :5 ,
a_new_process_status_id => :6 ,
a_new_state_id => :7 ,
a_source_state_id => :8 ,
a_task_id => :9 ,
a_assigned_user => :10 ,
a_privilege => :11 ,
a_author => :12 ,
a_source_process_id => :13 ,
a_source_position_id => :14 ,
a_source_coord_set_id => :15 ,
a_source_parent_hist_id => :16 ,
a_new_process_id => :17 ,
a_new_process_position_id => :18 ,
a_is_request_in_workstream => :19 ,
<Sep 13, 2018 10:10:22 AM EDT> <Notice> <Stdout> <BEA-000000> <
<oracle.communications.ordermanagement.ws.CreateOrderBySpecificationOperationI
mpl> <BEA-000000> <Error processing createOrderBySpecification
com.mslv.oms.handler.InternalErrorException: No more data to read from socket
: No more data to read from socket
at
com.mslv.oms.handler.AbstractHandlerEJB.processRequest(AbstractHandlerEJB.java
:122)
at
com.mslv.oms.handler.createorder.CreateOrderHandlerEJB.process(CreateOrderHand
lerEJB.java:167)
at
com.mslv.oms.handler.AbstractHandlerEJB.processRequest(AbstractHandlerEJB.java
:117)
We turned on the alert and trace logs and on the DB side and received the error in the Alert Log:
Fri Sep 14 10:09:27 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0]
[PC:0xCF2B184, pfrinstr_INHFA1()+1524] [flags: 0x0, count: 1]
Errors in file
/<DIR>/trace/xxxx_ora_25565.trc
(incident=338623):
ORA-07445: exception encountered: core dump [pfrinstr_INHFA1()+1524]
[SIGSEGV] [ADDR:0x0] [PC:0xCF2B184] [Address not mapped to object] []
ORA-01403: no data found
Which is then further traced to:
*** 2018-09-14 10:18:51.568
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3,
mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=1684n96u5h0f9) -----
BEGIN
om_handler_pkg.sql_order_transition(
a_order_seq_id => :1 ,
a_hist_seq_id => :2 ,
a_hist_seq_id_new => :3 ,
a_parent_hist_seq_id_new => :4 ,
a_new_ord_state_id => :5 ,
a_new_process_status_id => :6 ,
a_new_state_id => :7 ,
a_source_state_id => :8 ,
a_task_id => :9 ,
a_assigned_user => :10 ,
a_privilege => :11 ,
a_author => :12 ,
a_source_process_id => :13 ,
a_source_position_id => :14 ,
a_source_coord_set_id => :15 ,
a_source_parent_hist_id => :16 ,
a_new_process_id => :17 ,
a_new_process_position_id => :18 ,
a_is_request_in_workstream => :19 ,
a_bypass_security => :20 ,
a_amending_order => :21 ,
a_reason => :22 ,
a_is_order_complete => :23 ,
a_is_order_to_transition => :24 ,
a_any_data_update => :25 ,
a_transition_mode => :26 ,
a_transition_reason => :27 ,
a_transition_message => :28 ,
a_jeopardy_timers_4amended => :29 ,
a_jeopardy_checks_4amended => :30 ,
a_jeopardy_timers => :31 ,
a_jeopardy_checks => :32 ,
a_tasks_skip_grace_period => :33 ,
a_process_status => :34 ,
a_task_transition_metrics => :35
);
:36 := om_event_pkg.get_events;
:37 := om_wf_api.get_jms_threads;
:38 := om_wf_api.get_pending_orch_processes;
:39 := om_wf_api.get_completed_orch_comp_tasks;
END;
[TOC00005]
and the call stack:
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xa576860c8 46 ORDERMGMT.OM_T_METR_TASK_TRANS
0xa576860c8 87 ORDERMGMT.OM_T_METR_TASK_TRANS
0xa4734ba88 2939 package body ORDERMGMT.OM_WF_API
0xa4734ba88 3147 package body ORDERMGMT.OM_WF_API
0xa4734ba88 6243 package body ORDERMGMT.OM_WF_API
0xa4734ba88 4939 package body ORDERMGMT.OM_WF_API
0xa3f5a40e8 549 package body ORDERMGMT.OM_HANDLER_PKG
0xa5768b1c8 2 anonymous block
[TOC00005-END]
[TOC00004-END]
a_reason => :22 ,
a_is_order_complete => :23 ,
a_is_order_to_transition => :24 ,
a_any_data_update => :25 ,
a_transition_mode => :26 ,
a_transition_reason => :27 ,
a_transition_message => :28 ,
a_jeopardy_timers_4amended => :29 ,
a_jeopardy_checks_4amended => :30 ,
a_jeopardy_timers => :31 ,
a_jeopardy_checks => :32 ,
a_tasks_skip_grace_period => :33 ,
a_process_status => :34 ,
a_task_transition_metrics => :35
);
:36 := om_event_pkg.get_events;
:37 := om_wf_api.get_jms_threads;
:38 := om_wf_api.get_pending_orch_processes;
:39 := om_wf_api.get_completed_orch_comp_tasks;
END;
[TOC00005]
and the call stack:
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xa576860c8 46 ORDERMGMT.OM_T_METR_TASK_TRANS
0xa576860c8 87 ORDERMGMT.OM_T_METR_TASK_TRANS
0xa4734ba88 2939 package body ORDERMGMT.OM_WF_API
0xa4734ba88 3147 package body ORDERMGMT.OM_WF_API
0xa4734ba88 6243 package body ORDERMGMT.OM_WF_API
0xa4734ba88 4939 package body ORDERMGMT.OM_WF_API
0xa3f5a40e8 549 package body ORDERMGMT.OM_HANDLER_PKG
0xa5768b1c8 2 anonymous block
[TOC00005-END]
[TOC00004-END]
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |