[Building Sakai] samigo auto-submit job?

[Sam Ottenhoff]

Check the Samigo source for docs/auto_submit/auto_submit_oracle.sql.

--Sam

On Tue, Mar 27, 2012 at 2:41 PM, Joshua Swink <joshua.swink at gmail.com>wrote:

> Thanks Sam. I'm having some trouble with the manual database update.
>
> INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID, ASSESSMENTID,
> LABEL, ENTRY)
>      VALUES (NULL, 1, 'automaticSubmission_isInstructorEditable', 'true');
>
> ORA-01400: cannot insert NULL into
> ("SAKAI"."SAM_ASSESSMETADATA_T"."ASSESSMENTMETADATAID")
>
> The distributed sql files even set up this table with 'not null' for that
> field:
>
> create table SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID bigint not null
> auto_increment, ...
>
> Is there a workaround for these database updates?
>
> Josh
>
>
> On Fri, Mar 23, 2012 at 3:39 PM, Sam Ottenhoff <ottenhoff at longsight.com>wrote:
>
>> Check out the 2.6.0 release notes for details:
>>
>>    https://confluence.sakaiproject.org/display/SAM/2.6+Release+Notes
>>
>> Only set the job to run once a night when no students are taking
>> assessments.  Do NOT run the job when students could be taking an
>> assessment (if you allow submissions after the due date).  See SAM-1088 if
>> you want details.
>>
>> --Sam
>>
>> On Fri, Mar 23, 2012 at 6:35 PM, Joshua Swink <joshua.swink at gmail.com>wrote:
>>
>>> Since we are using Tests & Quizzes, should we have a trigger to run the
>>> "Auto Submit Assessments Job" regularly?
>>>
>>> I am investigating a student who says that he completed an assessment
>>> while saving his progress, but there was a power outage before he could
>>> finally submit. Then the deadline passed. Tests & Quizzes simply shows no
>>> submission from this student. However, I examined the database table
>>> SAM_ITEMGRADING_T and it contains a complete set of answers from this
>>> student, for the assessment in question, and these answers were saved
>>> before the assignment's deadline.
>>>
>>> I've tried to be thorough when installing and setting things up, but did
>>> I miss an instruction to set a trigger for the "Auto Submit Assessments
>>> Job"? It is currently not scheduled to run.
>>>
>>> Josh
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120327/41b2ab48/attachment.html