[Building Sakai] samigo auto-submit job?

[Joshua Swink]

Thanks a bunch!

Josh

On Tue, Mar 27, 2012 at 11:44 AM, Sam Ottenhoff <ottenhoff at longsight.com>wrote:

> 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/4e244c93/attachment.html