My Oracle Support Banner

Lost Connection with Errors (Doc ID 2898377.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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