Calendar dates exceed length limit exception error
search cancel

Calendar dates exceed length limit exception error


Article ID: 204121


Updated On:


CA Automic Applications Manager (AM)


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


Release : 9.4.x+

Component : CA Automic Applications Manager


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


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.