[gradebook2-dev] Unique constraint violation on GRADE_RECORD_T

[Thomas Amsler]

I agree with Mike. Looking at the stacktrace it occurred at:

org.sakaiproject.gradebook.gwt.sakai.Gradebook2ComponentServiceImpl.upload(Gradebook2ComponentServiceImpl.java:3389)

...,which is in the import grades code section. The most likely cause
is that the import files has duplicate user rows. We have a JIRA for
this:

https://jira.sakaiproject.org/browse/GRBK-1194

Please vote on the JIRA so that it can make it into the next release
if possible.
-- Thomas

On Tue, Dec 20, 2011 at 11:55 PM, Michael Wenk <mjwenk at ucdavis.edu> wrote:
> Kelly,
>
> The unique constraint problem can happen for several reasons.  I would
> research what constraint SYS_C0010870 is, what fields in the table it
> references.  UCD had an issue last term where an instructor imported a
> file with multiple entries with the same student ID that caused a
> unique constraint failure.  If the constraint is on the STUDENT_ID
> then that's likely your problem.  Given the stack trace I looked at, I
> would strongly suspect it to be the case.  In the case I referenced,
> the problem didn't seem to cause any slowdown, just a failure of the
> system to do the import properly, so I'm not sure the constraint is
> causing your real problem.
>
> Mike
>
> 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
>
>
>
> --
> Michael Wenk