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

[Jose Rabal Sastre]

  Any grade with "comments" or "excuses option" selected causes the 
constraint violation error when an external tool tries to remove it and 
it has nothing to do with removing the grade from gb2.

Also If we remove an external grade with comments from gb2, the external 
application can not send it again and log shows the message:

2011-08-30 12:10:02,578  WARN http-8080-Processor25 
org.sakaiproject.tool.assessment.ui.listener.author.SavePublishedSettingsListener 
- oh well, must have been added already:An external assessment with that 
ID already exists in gradebook ui
d=fa0a5450-44cf-41b3-a8a4-7e24b2249137

I reproduced the error on a clean Sakai 2.7.1 and Gradebook2 1.6.1 
installation.
I will report the issue to edu-services team too.

Thank you!
Jose Rabal

El 30/08/2011 1:55, Jon Gorrono escribió:
> 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
>>
>
>