Lost Connection with Errors (Doc ID 2898377.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Goal

Oracle Billing and Revenue Management (BRM) Cloud Native on Openshift environment is having errors from MTAs or WebServices executions, also there is no network failures.

How to solve the errors from BAD_LOGIN, PIN_ERR_DM_ADDRESS_LOOKUP_FAILED and PIN_ERR_DM_CONNECT_FAILED?

Errors in brm-apps log:
------------
...
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pcpst.c(107):2132 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
(693): pcp_connect(), connecting - failed
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pcm.c(65):197 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
Connect open failed in pcm_context_open
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_BAD_LOGIN_RESULT:56>
<facility=0 msg_id=0 version=0>
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pcm_conn.c(9):285 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
pcm_connect: bad pcm_context_open, err 56
...
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pin_mta_ac_export_fiscal_file.c:5856 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
pin_mta_ac_fiscal_create_item_file invalid dt_emissao error!
D Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pin_mta_ac_export_fiscal_file.c:1263 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
pin_mta_tune search results flist
# number of field entries allocated 20, used 1
0 PIN_FLD_MULTI_RESULTS ARRAY [0] allocated 20, used 4
1 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
1 PIN_FLD_RESULTS ARRAY [0] allocated 72, used 72
2 PIN_FLD_POID POID [0] 0.0.0.1 /ac_fiscal_arquivo_item 124956337 0
2 PIN_FLD_CREATED_T TSTAMP [0] (1663612980) Mon Sep 19 18:43:00 2022
2 PIN_FLD_MOD_T TSTAMP [0] (1663612980) Mon Sep 19 18:43:00 2022
...
2 AC_FLD_VALOR_GT_FIM STR [0] "0000000000000000"
2 AC_FLD_VALOR_GT_INI STR [0] "0000000000000000"
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
Thread (4141755200) exits ...
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pin_mta.c:730 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
pin_mta_main_thread error
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_BAD_LOGIN_RESULT:56>
<facility=0 msg_id=0 version=0>
E Mon Sep 19 19:07:46 2022 brm-apps pin_mta_ac_export_fiscal_file:693 pin_mta.c:735 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
pin_mta_main_thread error
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_BAD_LOGIN_RESULT:56>
<facility=0 msg_id=0 version=0>
....


Errors in cm.pinlog
----------
...
W Mon Sep 19 19:07:46 2022 cm cm:774289 pcpst.c(107):2092 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
  connect to host=dm-oracle, port=12950 FAILED, returned ebufp->pin_err=57
E Mon Sep 19 19:07:46 2022 cm cm:774289 pcpst.c(107):2132 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
  (774289): pcp_connect(), connecting - failed
E Mon Sep 19 19:07:46 2022 cm cm:774289 cm_utils.c(155):4558 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
  CM->DM socket!, err=57(PIN_ERR_CM_ADDRESS_LOOKUP_FAILED), errno=16
E Mon Sep 19 19:07:46 2022 cm cm:774289 cm_child.c(140):5278 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
  bad cm_change_dm_connection, new db=1(0.0.0.1), current db=0(0.0.0.0), err=57(PIN_ERR_CM_ADDRESS_LOOKUP_FAILED), errno=9(Bad file descriptor)
E Mon Sep 19 19:07:46 2022 cm cm:774289 pcm.c(65):835 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
Op (PCM_OP_SEARCH) send failed in pcm_op
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_CM_ADDRESS_LOOKUP_FAILED:57>
<facility=0 msg_id=0 version=0>
D Mon Sep 19 19:07:46 2022 cm cm:774289 fm_act_find.c:871 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
fm_act_find_search_service: search result flist
NULL flist ptr
E Mon Sep 19 19:07:46 2022 cm cm:774289 fm_act_find.c:885 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
fm_act_find_search_service error
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_CM_ADDRESS_LOOKUP_FAILED:57>
<facility=0 msg_id=0 version=0>
E Mon Sep 19 19:07:46 2022 cm cm:774289 fm_act_find.c:636 2:brm-apps:pin_mta_ac_export_fiscal_file:693:-146585856:0:1663614456:0::::
fm_act_find_search_singledb login/alias search error:
<location=PIN_ERRLOC_FLIST:6 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_CM_ADDRESS_LOOKUP_FAILED:57>
...

Error stack in db_alert.log
---------------
...
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 18.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 18.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 18.0.0.0.0 - Production
Version 18.1.0.0.0
Time: 16-SEP-2022 14:09:08
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=<IP_ADDR_99>)(PORT=64889))

Solution

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