Assignments Not Submitted
Omer Piperdi wrote:
We are having quite an issue with assignment tool on 2.1.2 and Oracle. There
are lots of complain about losing assignments; students submitted but
instructor cannot find it etc. We don't know where to look for and how to
trace where these assignments are lost.
>
Another issue was something to do with upload file size. One student
complained that she kept on getting a message that says "it exceeds upload
file limit", even though file size is a lot smaller than 100MB of upload
file size we set in sakai.properties.
Have anyone seen these problem or known JIRA issues on these?
John Leasia replies:
Whenever we have looked into a 'lost' assignment, we find that the student has made an attachment, but never completed the submission process. They mistakenly think that clicking the 'Finish' button to complete the attachment process also completes their submission, and fail to click the Submit button at the bottom of the page. We check this by looking for all events (in the sakai.events table) by the student around the time they think they submitted. We find the content.new event for their attachment, but don't see an asn.submit event.
I use something like this to find all events by the user:
select sakai_session.session_user, sakai_event.event_date, sakai_event.event, sakai_event.ref from ctools_user.sakai_session, ctools_user.sakai_event where sakai_session.session_id = sakai_event.session_id and sakai_session.session_user like '<useraccountname>' and sakai_event.event_date between to_date('20061021 00:00','YYYYMMDD HH24:MI') and to_date('20061021 23:59','YYYYMMDD HH24:MI') and event not in ('pres.end', 'pres.begin')
I don't know about the exceeds upload limit error - that should only happen when uploading into Resources, which isn't happening when uploading a file for a submission. Submitted files are treated as attachments and go into the /content area and aren't Sakai limited by size I think. Maybe there is some Oracle setting limiting size?
John