DLP Upgrade fails; ORA-04009 seen in the sql_error.log file

Article Id: 163130
Status: Published
Updated On: 08-04-2016 15:54
Legacy Id: TECH234630
Products:
Data Loss Prevention Enforce
Issue/Introduction:

Upgrade of DLP fails during the database schema upgrade; reviewing sql_error.log you see:

ERROR       : ORA-04009: MAXVALUE cannot be made to be less than the current value

Cause:

Numeric Overflow can cause this error; to confirm, the related technote (TECH230477) "Checking for the presence or risk of numeric overflow defect in Data Loss Prevention system" should be used to determine if there is Numeric Overflow on any of our sequences. 

Resolution:

 If Numeric Overflow is found a technical support case will need to be opened to address the issue.