pin_cycle_fees Utility With -purchase Option Hanging After PS16 Upgrade
Last updated on JANUARY 02, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.4.0]
Oracle Solaris on SPARC (64-bit)
We are in the process of upgrading to PS16 and when we do a regression testing with PS16 installed on our test environments, pin_cycle_fees utility with -purchase options hanging after processing some accounts. Below are the MTA configuration parameters being used for pin_cycle_fees utility
Before upgrading to PS16, with the same configuration it used to work without this issue.
We could observe that it is randomly working when we reduces the MTA's children configuration to 1 or 2, but it is not consistent. We don not see any error in cm or dm_oracle or mta's pinlog file when it hangs. It is hanging even with instance having very few accounts where mta's search returns around 10 accounts to process.
Seems possible to reproduce with pin_cycle_fees utility with -purchase option on any instance having at least few hundreds of accounts (so that MTA's search returns min 200 to 500 accounts to process), with same configurations of MTA. Once it hangs, we're not able to do testnap also and we only see "CMAP: Polling for shutdown request" in the cm.pinlog.
Seems to be some issue with child threads handling, since it is working with children set to 1 and not working if we increase it.
Another symptom is that pin_cycle_fees utility is writing lot of debug messages to cm's pinlog file, compared to previous version with loglevel 3, that causing cm's log file to grow quickly upto 2 GB even before it process 200 accounts.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms