Pin_ledger_report Hangs in Export Mode and Consumes 100% CPU (Doc ID 2210935.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Goal

On : 7.5.0.15.0 version, General Ledger (GL)

pin_ledger_report hangs in export mode for 7019134 records for 1 given segment and consumes 100% CPU usage

Top command output:

top - 22:15:08 up 276 days, 22:22, 10 users, load average: 2.03, 4.21, 4.33
Tasks: 847 total, 7 running, 839 sleeping, 1 stopped, 0 zombie
Cpu(s): 12.6%us, 0.2%sy, 0.0%ni, 87.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 32941680k total, 30867316k used, 2074364k free, 174624k buffers
Swap: 67112956k total, 2372k used, 67110584k free, 21582940k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
49292 xxxx 20 0 2118m 2.1g 7160 R 99.7 6.6 3:25.30 pin_ledger_repo
49979 xxxx 20 0 13944 1796 856 R 1.0 0.0 0:02.69 top
29772 xxxx 20 0 5401m 5.0g 5.0g S 0.3 15.9 0:09.85 dm_oracle_billi
29994 xxxx 20 0 5503m 25m 16m S 0.3 0.1 0:00.13 dm_oracle_billi
30040 xxxx 20 0 5503m 22m 14m S 0.3 0.1 0:00.12 dm_oracle_billi
 

How to resolve this issue?

Solution

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