My Oracle Support Banner

Mantas 8.x HDC Process Failure (Doc ID 2667029.1)

Last updated on MAY 13, 2020

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------
Mantas 8.x HDC Process Failure

Problem Description
---------------------------------------------------
Our HDC job has been failing with below error

 

2020-03-18 15:29:24,620 [Thread-56] WARN CORE - Message 170114: Exception -- populateSeqIdTempTable: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
2020-03-18 15:29:24,620 [Thread-56] DEBUG MANTAS - Message 00001: SQL analyzeTempTable query: {call DBMS_STATS.GATHER_TABLE_STATS (?, ?)}
2020-03-18 15:29:25,025 [Thread-56] WARN CORE - Message 170113: Exception -- analyzeSeqIdTempTable: java.sql.SQLException: ORA-20000: Unable to analyze TABLE "OFSAAFCCM"."UI_TEMP_TABLE2678007", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 34897
ORA-06512: at line 1

 

2020-03-18 15:29:25,025 [Thread-56] DEBUG MANTAS - Message 00001: Databag Query is: SELECT ACCT_INTRL_ID,INSTL_ACCT_SMRY_SEQ_ID,MNTH_SMRY_START_DT FROM OFSAAFCCM.INSTL_ACCT_SMRY_MNTH WHERE ACCT_INTRL_ID = ? AND MNTH_SMRY_START_DT IN (SELECT KEY FROM UI_TEMP_TABLE2678007)
2

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.