V10 Master Program - Build Renewal Predictions Erroring with SQLCODE : -40284 : SQLERRM : ORA-40284: model does not exist (Doc ID 2978788.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When running Build Renewal Predictions for Service Contracts, the program is failing with below errors:

ERROR
-----------------------
OKS_BUILD_RENEW_PRED_MASTER: Master Program - Build Renewal Predictions

Begin RUN_BUILD_MODEL
Error while dropping the existing knowledge base : Mid_Contract_Renewal_Predict
SQLCODE : -40284 : SQLERRM : ORA-40284: model does not exist
algorithm_code=RF
Before Model builtoks_build_168579404_v
Create Model sqlcode= -1031
Create Model sqlerrm= ORA-01031: insufficient privileges
In the create_model Exception when others : SQLCODE : -1086 : SQLERRM : ORA-01086: savepoint 'run_build_model_PVT' never established in this session or is invalid


ECCRUNDL: ECC Run Data Load
2023-06-23 12:04:00.458 [pool-5-thread-4] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - ## SQL Plan Generation ## --> Issue with fetching the sql plan statistics data in getStatisticsToDto
java.sql.SQLException: Numeric Overflow


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using ECC Developer or Service Contract Manager responsibility, run "Master Program - Build Renewal Predictions".
2. The program fails with the indicated errors.

Changes

Cause

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