[Building Sakai] samigo auto-submit job?

[Joshua Swink]

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