Calendar Creation

[Christopher Collins]

We are having issues with calendar creation. The system gives us the following error:

ErrorUnable to update Calendar entity KING.NEED_TO_CREATE}The ACTIVITY_CALENDAR 291 cannot be created because a duplicate already existsCannot 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

[cunninghamg]

Re: Calendar Creation

Christopher

Activity_calendar has an ID populated by an Oracle Sequence number.
This field is not a GID and therefore does not get prefixed with the Domain.

Chances are that if you've tried to load a csv with ID numbers that already exist in another domain (even PUBLIC) this will give the error you are seeing.

Though I have never tried it myself, I have always been warned against using csv upload to create calendars - but to do it manually - I think you are beginning to see why.

There are always round the issues - such as altering the sequence numbers (if you have the access and know how) but unless you have an awful lot to load I would suggest manual creation.

Gary

[Christopher Collins]

Re: Calendar Creation

Gary:

Thanks. We did determine that it is the sequencing. We have csv'd calendars before without any issue but this time a problem did occur. We will correct and going forward use the manual process for calendars.

Thanks,

Chris

[rramaiah]

Re: Calendar Creation

"The ACTIVITY_CALENDAR 144 cannot be created because a duplicate already exists
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GLOGOWNER.PK_ACTIVITY_CALENDAR) violated"

I am trying to insert the calendar manually. I know that Calendar ID I am giving is not duplicated. I tried with three different names and always getting the same error.
(OTM Version 6.3)
What am I missing. Please advise.

[er.prashant.jain]

Re: Calendar Creation

Just to cross check, please check the next available sequence of ACTIVITY_CALENDAR_SEQUENCE,

SELECT ACTIVITY_CALENDAR_SEQUENCE.NEXTVAL FROM DUAL