Calendar dates exceed length limit exception error

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When  trying to create calendar, users see the following error:

java.sql.SQLException: ORA-20999: General Failure " Calendar dates exceed length limit at xx/xx/xxxx. Choose less dates" 

ORA-06512: at "xxxxx", line 477
ORA-06512: at "xxxxx", line 1321
ORA-06512: at "xxxxx", line 4110

Environment

Release : 9.4.x+

Component : CA Automic Applications Manager

Cause

This error usually occurs if you select past dates in Calendars.

Resolution

After selected days in Calendars have passed, you may not need Applications Manager to store them in the database any longer.

Remove dates that have passed from all Applications Manager Calendars by running the PURGE_CAL_DATES Job.

The PURGE_CAL_DATES Job includes one prompt where you specify a date before which to delete all days.

The prompt value uses the format DD-MMM-YY. Its default prompt value is determined by the #beginning_of_year Substitution Variables.