My Oracle Support Banner

FATCA MONTHLY RUN BATCH FAILURE (Doc ID 2746200.1)

Last updated on JANUARY 28, 2021

Applies to:

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

Symptoms

The monthly FATCA batch run has failed with below error

1609938923543,$RUNSK=149" FCCMINFO_1609938923543_20210106_1
com.ofs.aai.service.OFSAAServiceException: java.lang.Exception: java.sql.SQLException: Could not execute sql command - Original message: ORA-04030: out of process memory when trying to allocate 220872 bytes (QERGH hash-agg,kllcqc:kllcqslt)

at com.ofs.aai.service.rule.RuleExecutionService.execute(RuleExecutionService.java:232)
at com.ofs.aai.pr2.cmd.RuleExecution.main(RuleExecution.java:219)
Caused by: java.lang.Exception: java.sql.SQLException: Could not execute sql command - Original message: ORA-04030: out of process memory when trying to allocate 220872 bytes (QERGH hash-agg,kllcqc:kllcqslt)

at com.ofs.aai.service.rule.engine.GenericRuleEngine.executeRuleQuery(GenericRuleEngine.java:242)
at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.execute(GenericRDBMSRuleEngine.java:1562)
at com.ofs.aai.service.rule.RuleExecutionService.execute(RuleExecutionService.java:217)
... 1 more
Caused by: java.sql.SQLException: Could not execute sql command - Original message: ORA-04030: out of process memory when trying to allocate 220872 bytes (QERGH hash-agg,kllcqc:kllcqslt)

at com.ofs.aai.database.OFSAAPreparedStatementDecorator.executeUpdate(OFSAAPreparedStatementDecorator.java:883)
at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.executeRule(GenericRDBMSRuleEngine.java:1482)
at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.executeRuleQuery(GenericRDBMSRuleEngine.java:183)
at com.ofs.aai.service.rule.engine.GenericRuleEngine.executeRuleQuery(GenericRuleEngine.java:220)
... 3 more
Caused by: java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 220872 bytes (QERGH hash-agg,kllcqc:kllcqslt)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

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


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