We are having issues with calendar creation. The system gives us the following error:
Error
Unable to update Calendar entity KING.NEED_TO_CREATE}
The ACTIVITY_CALENDAR 291 cannot be created because a duplicate already exists
Cannot add the ACTIVITY_CALENDAR record. ACTIVITY_CALENDAR_ID must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_ACTIVITY_CALENDAR) violated
We have verified that the ACTIVITY_CALENDAR_ID is unique. The only discrepancy that we see is that there are 2000 records indicated in the calendar counter but when we are creating them we are only at 290.
The calendars were CSV'd into this environment. Could that be the cause of this issue?
Chris