My Oracle Support Banner

Failed and Retry to execute BDF_HOME/scripts/execute.sh AccountATMDailyProfile (Doc ID 2532478.1)

Last updated on OCTOBER 25, 2019

Applies to:

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

Symptoms

Failed and Retry to execute BDF_HOME/scripts/execute.sh AccountATMDailyProfile 

With error in log

Filename = AccountATMDailyProfile.log

See the following error:

2019-04-01 10:17:27,790 [main] FATAL - AccountATMDailyProfile - Message 10200: java.sql.SQLException: ORA-12801: error signaled in parallel query server P00G, instance 
ORA-14400: inserted partition key does not map to any partition

 

Client ran DRM job but they faced below error in DRM log.

<Error in log>

 

ALTER TABLE MANTAS.AUTO_QUOTE ADD PARTITION P20190405 VALUES LESS THAN ( TO_DATE(20190406,'YYYYMMDD'))

log date=03-30-19 01:36:35,Level=,Oper=,PartType=,Table = ,Msg=Updating status for Job id = 336,process id 71date =29-MAR-19

 

log date=03-30-19 01:36:35,Msg=Procedure P_ADD_WEEKLY(29-MAR-2019,MANTAS,ACCT_ATM_SMRY_DAILY)

 

log date=03-30-19 01:36:35,Level=,Oper=,PartType=,Table = ,Msg=Updating status for job id 336 end date = 29-MAR-19, Status = ERR

Error Code : -1840

Error Mess : ORA-01840: input value not long enough for date format

log date=03-30-19 01:36:35,Level=Error,Oper=,PartType=,Table = ,Msg=-1840 ->ORA-01840: input value not long enough for date format

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.