pin_cycle_fees Utility With -purchase Option Hanging After PS16 Upgrade (Doc ID 1546746.1)

Last updated on AUGUST 07, 2024

Applies to:

Symptoms

One user is in the process of upgrading to 7.4 Patch Set (PS) 16.  When the user do a regression testing with PS16 installed on a test environments, pin_cycle_fees utility with -purchase options hanging after processing some accounts.

Below are the MultiThreaded Applications (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.

It is randomly working when one reduces the MTA children configuration to 1 or 2, but it is not consistent. No error found in cm, dm_oracle, or mta pinlog files when it hangs. It is hanging even with instance having very few accounts where MTA search returns only around 10 accounts to process.

It is 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 minimum 200 to 500 accounts to process), with same configurations of MTA. Once it hangs, testnap can not be used, and only "CMAP: Polling for shutdown request" is logged in the cm.pinlog.

It seems to be some issue with child threads handling, since it is working with children set to 1 only.

Another symptom is that pin_cycle_fees utility is writing lot of debug messages to cm.pinlog, compared to previous version with loglevel 3, and causing cm log file to grow quickly up to 2 GB even before processing the 200 accounts.

Changes

Cause

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