Commission Calculation Errors With Internal Server Error. Trace shows 'latch: cache buffers chains' (Doc ID 1328110.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Incentive Compensation - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2013***

Symptoms

Commission calculation results in an internal server error.  The database trace file shows the following:

PARSING IN CURSOR #9 len=415 dep=1 uid=44 oct=6 lid=44 tim=8774504400744 hv=108900711 ad='7000000695cce60' sqlid='26chjdn37vcb7'
UPDATE CN_NOTIFY_LOG_ALL LOG SET LOG.STATUS = 'COMPLETE' WHERE LOG.NOTIFY_LOG_ID IN (SELECT LOG2.NOTIFY_LOG_ID FROM CN_NOTIFY_LOG_ALL LOG2, CN_PROCESS_BATCHES_ALL BATCH WHERE BATCH.PHYSICAL_BATCH_ID = :B1 AND LOG2.ORG_ID = BATCH.ORG_ID AND LOG2.SALESREP_ID = BATCH.SALESREP_ID AND LOG2.PERIOD_ID BETWEEN BATCH.PERIOD_ID AND BATCH.END_PERIOD_ID AND LOG2.STATUS = 'INCOMPLETE' AND LOG2.START_DATE >= BATCH.START_DATE)
END OF STMT
PARSE #9:c=0,e=108,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=2864775115,tim=8774504400743

*** 2011-05-27 10:52:56.533
WAIT #9: nam='latch: cache buffers chains' ela= 20 address=504403160408373576 number=150 tries=0 obj#=-1 tim=8774506520210

*** 2011-05-27 10:52:57.705
WAIT #9: nam='latch: cache buffers chains' ela= 6 address=504403160409593376 number=150 tries=0 obj#=-1 tim=8774507691824
WAIT #9: nam='latch: cache buffers chains' ela= 6 address=504403160409296976 number=150 tries=0 obj#=-1 tim=8774507741076

*** 2011-05-27 10:53:00.367



where the WAIT event 'latch: cache buffers chains'  appears lots of time.

Cause

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