[gradebook2-dev] Problems with GB2 services and grades integration

[Jon Gorrono]

As far as I can determine from this description and some testing of my
own, if there are issues, then they need to be addressed by the
edu-services maintainers .... Gradebook2 uses the same tables as does
Gradebook2  and those are in edu-services...IOW, deleting an
assignment from GB1 would obviously delete it from GB2 since they
reference the same data, and if you think that removing the 'publish
this to gradebok' relationship from the item in assignments should
delete the item from GB1 and GB2, then that should be raised with the
right development team: edu-services... we'd be glad to participate in
any discussions, however.

WRT to the specific constraint error: this would occur if a comment
were referenced for which there was no corresponding gradable object.
Is it possible you removed the assignment from gradebook and with a UI
(browser window) that was not refreshed with that 'knowledge', and
then tried to edit the comment?



On Mon, Aug 29, 2011 at 5:46 AM, Jose Rabal Sastre <joserabal at um.es> wrote:
>  Hi everyone!
> This is Jose Rabal from the University of Murcia in Spain. We are
> experimenting some errors in Gradebook 2 with grades that have been sent
> from other tools like Samigo or Assignments to GB2. If we add a comment
> in one of this grades and later we try to specify that we don't want to
> send it to gradebook, the console shows the following error
>
> ERROR org.hibernate.util.JDBCExceptionReporter  - Integrity constraint
> violation FK7977DFF06F98CFF table: GB_COMMENT_T in statement [delete
> from GB_GRADABLE_OBJECT_T where ID=? and VERSION=?]
>
> and the grade is not removed from Gradebook.
>
> If we remove the grade using the Gradebook tool then the grade
> dissapears, but if we set in Samigo or Assignments that we want to send
> the grade again to Gradebook, the grade is not sent again.
> I would like to test this error in a QA server with Gradebook 2, but all
> the servers that I have found are with Gradebook 1. Can anyone reproduce
> the same problems? I have tested the error on Gradebook 1.3.0, 1.5.0 and
> 1.6.0, Sakai 2.7.1 and 2.8.
>
> Thanks in advance!
> Jose Rabal
> _______________________________________________
> 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 - gswot.org>}
http{sysdev.ucdavis.edu}