My Oracle Support Banner

Failed Daily Batch (Doc ID 2825676.1)

Last updated on APRIL 24, 2023

Applies to:

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

Symptoms

Version 8.0.2

Alert generation job has been failed with below error.

11/29/2021 20:12:27 DEBUG : Thread ID = 139916808640256: mantas: File = TableCentricity.cc: Line = 270: SELECT a.CNTRY_KEY_ID, a.FOCAL_NTITY_DSPLY_NM, a.FOCAL_NTITY_DSPLY_ID, a.BUS_DMN_ST, a.JRSDCN_CD FROM PRO_OFSAAFCCM.KDD_SH_FOCUS_VW a WHERE a.CNTRY_ID = 113000074
Error Msg :-> ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PRO_OFSAAFCCM.P_SINGLE_TABLE_ANALYZE", line 64
ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query server P000, instance hostname:fccmdb1 (1)
ORA-27103: internal error
Additional information: 11818
Additional information: 9
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 10529
Additional information: 65536
ORA-0651

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.