My Oracle Support Banner

Daily Batch running for Long Time. (Doc ID 2941735.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

User reported that daily batch is running for more than 24 hour with the same query, and it mostly take 3 to 4 hours

Batch got stuck in AccountProfile_Transaction datamap task where in task started but not ending

In AccountProfile_Transaction.log

2023-04-04 11:51:52,476 [main] INFO - AccountProfile_Transaction - Message 10211: Processing batch DLY on date 20230402, last batch is true

.

.

NVL(GREATEST(LEAST(b.RDC_VENDOR_IN_CT,99999999),-99999999),0),
NVL(GREATEST(LEAST(b.RDC_OTHER_IN_AM,1.0E20),-1.0E20),0.0),
NVL(GREATEST(LEAST(b.RDC_OTHER_IN_CT,99999999),-99999999),0),
SUBSTR(b.RPTNG_CRNCY_CD,1,3)

Cause

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
Symptoms
Cause
Solution
References


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