My Oracle Support Banner

Pin_CMT Process Is Throwing Error With ECE (Doc ID 2568141.1)

Last updated on JULY 24, 2019

Applies to:

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


On : version, Conversion Manager

Post installing Patch 29546359,Account XML with Hierarchy is working as expected but during Balance XML its throwing connection "2500 - DB_CONNECTION_ERR" error.

Note: CMT is processing around 30 records and throwing this error. Moreover happening only for BALANCE type XML where as its able to successfully process other account level & Service Level XML with bulk accounts.

. Unlike the behavior mentioned, its Processing few records and throwing error.
. Unlike "java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver", it says unable to open few more connection unlike "Timed-Out waiting for a free connection".
. Suspect it something related to threads configured in the Currently its 30 Maxconn connections and successfully processing 30 , if configured it to maxconn=40 then files were processing successfully.

Error in the Console log:

Steps to reproduce:

The issue can be reproduced at will with the following steps:
1. ./pin_cmt -import -file MIG_BRM_Load_01018_Part1of1_CUST_20190517_1.xml 1111 --> Processed Successfully
2. ./pin_cmt -import -file MIG_BRM_Load_01018_Part1of1_BL_20190517_1.xml 1111 --> 2500 - DB_CONNECTION_ERR Error




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

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