[gradebook2-dev] Unique constraint violation on GRADE_RECORD_T

[Jon Gorrono]

When we have seen this error, it has been after a database restore or
copy  ... in that process the sequences used to set id's for objects
have current values that are too low: lower that than largest id
values in the respective tables...

Quick fix, than, is to increment the sequences by some sufficiently
large number like 50k or 100k or ?

On Tue, Dec 20, 2011 at 8:11 AM, Thomas Amsler <tpamsler at ucdavis.edu> wrote:
> Do you have a catalina.out stack trace for this error, and if so, can
> you please send it?
>
> Best,
> -- Thomas
>
> On Tue, Dec 20, 2011 at 7:30 AM, Geng, Kelly <gengx at muohio.edu> wrote:
>> During this morning, the last minute of grade submission here, we are experiencing some gradebook2 loading failure sporadically and access slowdown occasionally. From the log the most apparently relevant error is a ORA-00001: unique constraint violation on GRADE_RECORCD_T table . Anyone can shed any light on this?
>>
>>
>> Kelly Geng
>> Miami University
> _______________________________________________
> gradebook2-dev mailing list
> gradebook2-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev



-- 
Jon Gorrono
PGP Key: 0x5434509D -
http{pgp.mit.edu:11371/pks/lookup?search=0x5434509D&op=index}
GSWoT Introducer - {GSWoT:US75 5434509D Jon P. Gorrono <jpgorrono -
www.gswot.org>}
http{middleware.ucdavis.edu}