[Building Sakai] Samigo - Annoymous survey issue
Tom Hall
thall at brocku.ca
Fri Aug 26 07:43:58 PDT 2011
Hi Karen
I have attached the file survey_events.txt. It contains the sequence of
events as best Matt and Mike in CTLET can rember and the results of two
queries over out SAKAI_EVENTS table. These query results come from two
different copies (non-overlapping) of the table, so please go by the
timestamps not the id numbers (I cleared the table when I did a DB
hardware migration earlier this month).
Thanks again for your help
Tom
On 8/25/2011 2:30 PM, Karen Tsao wrote:
> Hi Tom,
>
> From your records, sounds like there is a bug somewhere. However, I
> couldn't reproduce these duplicates by copying the assessments. Can
> you get more information to help me to reproduce them? For example,
> what actions the instructors have performed on these assessments.
>
>
> I then followed the foreign key in the SAM_PUBLISHEDMETADATA_T
> table to the SAM_PUBLISHEDASSESSMENT_T table and got the following
> results. They indicate that the same ALIAS value is used in
> multiple sites, with varying status values. When I checked with
> the folks who maintain the site with these assessments in it, they
> tell me that they copied one assessment to create the others. It
> looks to me like the assessment copy operation is copying aliases
> along with all of the other data, which to me doesn't make a lot
> of sense.
>
> The copy action only copies working copies. That is, the data only
> gets copied into SAM_ASSESSMETADATA_T. The aliases in
> SAM_PUBLISHEDASSESSMENT_T is created during publish. So even if they
> are copied into SAM_ASSESSMETADATA_T, you should have the different
> values in SAM_PUBLISHEDASSESSMENT_T. Also, from your example
> assessment id 4348, there are two records in SAM_PUBLISHEDASSESSMENT_T:
>
> | 220858 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965489462 |
> | 220861 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881311617657500 |
>
> The second record is the invalid/duplicate alias and you can see its
> ASSESSMENTMETADATAID is after the first record. That means the first
> one is created during publish and it is an unique alias (I can access
> it through
> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965489462
> <http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881311617657500>?).
> And then the second invalid/duplicate one is created at a later point.
> I don't know how the second record got created. Can you ask if the
> instructors modified these published assessments in some way after
> they published them?
>
> This sounds like a bug in a certain flow. If you can get the
> navigation history from instructors, that will help me to figure out
> the problem.
>
> Thanks,
> Karen
>
>
>
> mysql> select ID, TITLE, STATUS, LASTMODIFIEDDATE from
> SAM_PUBLISHEDASSESSMENT_T where ID in (4284, 4285, 4335, 4344, 4348);
> +------+----------------------------------------------------------------+--------+---------------------+
> | ID |
> TITLE |
> STATUS | LASTMODIFIEDDATE |
> +------+----------------------------------------------------------------+--------+---------------------+
> | 4284 | ADED Online Course Evaluation - SAMPLE - Modified for
> ADED1P31 | 2 | 2011-07-25 14:35:32 |
> | 4285 | ADED Online Course Evaluation - SAMPLE - Modified for
> ADED1P31 | 2 | 2011-07-25 14:57:23 |
> | 4335 | ADED Online Course Evaluation
> ADED1P31 | 2 | 2011-08-17 13:27:28 |
> | 4344 | ADED Online Course Evaluation
> ADED1P31 | 1 | 2011-08-21 18:23:58 |
> | 4348 | ADED Online Course Evaluation ADED1P31 - Copy
> #1 | 1 | 2011-08-21 18:24:49 |
> +------+----------------------------------------------------------------+--------+---------------------+
>
>
> 5 rows in set (0.00 sec)
>
>
> When I checked one of the working URLs, the result was:
>
>
> mysql> select * from SAM_PUBLISHEDMETADATA_T where LABEL =
> 'ALIAS' and ENTRY = 'b7d73f3d838d02f84979079ff5a725881313965489462';
> +----------------------+--------------+-------+-----------------------------------------------+
> | ASSESSMENTMETADATAID | ASSESSMENTID | LABEL |
> ENTRY |
> +----------------------+--------------+-------+-----------------------------------------------+
> | 220858 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965489462 |
> +----------------------+--------------+-------+-----------------------------------------------+
> 1 row in set (0.08 sec)
>
>
> I don't currently have a on-line instance of our 2.7.1
> installation available to me, but a check of the database shows
> that we did have duplicate ALIAS values there, but I had no
> reports of problems prior to 2.8.
>
> Tom
>
>
>
> On 8/24/2011 2:48 PM, Karen Tsao wrote:
>> Hi Tom,
>>
>> The table you look for should be SAM_PUBLISHEDMETADATA_T not
>> SAM_ASSESSMETADATA_T. But I am still not sure what goes wrong
>> here... If you have a certain URL that doesn't work, can you try
>> to query SAM_PUBLISHEDMETADATA_T using that ALIAS and see if that
>> record exists? Also, if your support people can reproduce this,
>> can you ask them for the step by step instruction? That would
>> help me a lot.
>>
>> Thanks,
>> Karen
>>
>> On Wed, Aug 24, 2011 at 6:20 AM, Tom Hall <thall at brocku.ca
>> <mailto:thall at brocku.ca>> wrote:
>>
>> Hi Karen
>>
>> One of the URLs is
>> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965482863
>> where the md5 hash corresponds to the LABEL value in the
>> metadata. The sample queries (for the same survey) below
>> have multiple label values associated with them. Users are
>> reporting that some URLs work and others don't. I haven't
>> seen this myself but the folks that provide faculty support
>> have seen it.
>>
>> Tom
>>
>>
>>
>> On 8/23/2011 4:57 PM, Karen Tsao wrote:
>>> Hi Tom,
>>>
>>> I don't quite understand your issue. Do you mean the id in
>>> the following URL?
>>>
>>> http://localhost:8080/samigo-app/servlet/Login?id=a1545c12-bfa2-449c-bd3a-fc5b23a75b30131413288...
>>>
>>> That is not related to the metadata id you selected from the
>>> database. Can you please explain more or give me some examples?
>>>
>>> Thanks,
>>> Karen
>>>
>>> On Tue, Aug 23, 2011 at 11:21 AM, Tom Hall <thall at brocku.ca
>>> <mailto:thall at brocku.ca>> wrote:
>>>
>>> Hi Everyone
>>>
>>> We have just come across an issue in Samigo when using
>>> anonymous surveys
>>> (don't know about other forms of tests/surveys). It has
>>> been reported
>>> to me that the id parameter in the URL for the anonymous
>>> survey is
>>> changing. When I did a check in the database I see the
>>> following for
>>> one of the surveys for which this behavior has been
>>> observed.
>>>
>>> ----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> | ASSESSMENTMETADATAID | ASSESSMENTID |
>>> LABEL |
>>> ENTRY |
>>> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> | 220845 | 4348 |
>>> itemAccessType_isInstructorEditable |
>>> true |
>>> | 220846 | 4348 |
>>> finalPageURL_isInstructorEditable |
>>> true |
>>> | 220847 | 4348 |
>>> submissionModel_isInstructorEditable |
>>> true |
>>> | 220848 | 4348 |
>>> anonymousRelease_isInstructorEditable |
>>> true |
>>> | 220849 | 4348 |
>>> dueDate_isInstructorEditable |
>>> true |
>>> | 220850 | 4348 |
>>> releaseTo |
>>> SITE_MEMBERS |
>>> | 220851 | 4348 |
>>> displayChunking_isInstructorEditable |
>>> true |
>>> | 220852 | 4348 |
>>> passwordRequired_isInstructorEditable |
>>> true |
>>> | 220853 | 4348 |
>>> testeeIdentity_isInstructorEditable |
>>> true |
>>> | 220854 | 4348 |
>>> bgColor_isInstructorEditable |
>>> true |
>>> | 220855 | 4348 |
>>> releaseDate_isInstructorEditable |
>>> true |
>>> | 220856 | 4348 |
>>> timedAssessmentAutoSubmit_isInstructorEditable |
>>> true |
>>> | 220857 | 4348 |
>>> metadataQuestions_isInstructorEditable |
>>> true |
>>> | 220858 | 4348 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881313965489462 |
>>> | 220859 | 4348 |
>>> feedbackAuthoring_isInstructorEditable |
>>> true |
>>> | 220860 | 4348 |
>>> feedbackType_isInstructorEditable |
>>> true |
>>> | 220861 | 4348 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881311617657500 |
>>> | 220862 | 4348 |
>>> assessmentAuthor_isInstructorEditable |
>>> true |
>>> | 220863 | 4348 |
>>> description_isInstructorEditable |
>>> true |
>>> | 220864 | 4348 |
>>> ipAccessType_isInstructorEditable |
>>> true |
>>> | 220865 | 4348 |
>>> submissionMessage_isInstructorEditable |
>>> true |
>>> | 220866 | 4348 |
>>> metadataAssess_isInstructorEditable |
>>> true |
>>> | 220867 | 4348 |
>>> templateInfo_isInstructorEditable |
>>> true |
>>> | 220868 | 4348 |
>>> hasTimeAssessment |
>>> false |
>>> | 220869 | 4348 |
>>> authenticatedRelease_isInstructorEditable |
>>> true |
>>> | 220870 | 4348 |
>>> feedbackComponents_isInstructorEditable |
>>> true |
>>> | 220871 | 4348 |
>>> bgImage_isInstructorEditable |
>>> true |
>>> | 220872 | 4348 |
>>> recordedScore_isInstructorEditable |
>>> true |
>>> | 220873 | 4348 |
>>> author
>>> | |
>>> | 220874 | 4348 |
>>> lateHandling_isInstructorEditable |
>>> true |
>>> | 220875 | 4348 |
>>> toGradebook_isInstructorEditable |
>>> true |
>>> | 220876 | 4348 |
>>> displayNumbering_isInstructorEditable |
>>> true |
>>> | 220877 | 4348 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881313965477231 |
>>> | 220878 | 4348 |
>>> hasMetaDataForQuestions |
>>> false |
>>> | 220879 | 4348 |
>>> retractDate_isInstructorEditable |
>>> true |
>>> | 220880 | 4348 |
>>> timedAssessment_isInstructorEditable |
>>> true |
>>> | 220881 | 4348 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881313965482863 |
>>> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> 37 rows in set (0.00 sec)
>>>
>>>
>>> mysql> select * from SAM_ASSESSMETADATA_T where
>>> ASSESSMENTID = '2751';
>>> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> | ASSESSMENTMETADATAID | ASSESSMENTID |
>>> LABEL |
>>> ENTRY |
>>> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> | 153484 | 2751 |
>>> assessmentAuthor_isInstructorEditable |
>>> true |
>>> | 153485 | 2751 |
>>> submissionModel_isInstructorEditable |
>>> true |
>>> | 153486 | 2751 |
>>> submissionMessage_isInstructorEditable |
>>> true |
>>> | 153487 | 2751 |
>>> retractDate_isInstructorEditable |
>>> true |
>>> | 153488 | 2751 |
>>> ipAccessType_isInstructorEditable |
>>> true |
>>> | 153489 | 2751 |
>>> displayChunking_isInstructorEditable |
>>> true |
>>> | 153490 | 2751 |
>>> metadataAssess_isInstructorEditable |
>>> true |
>>> | 153491 | 2751 |
>>> bgColor_isInstructorEditable |
>>> true |
>>> | 153492 | 2751 |
>>> bgImage_isInstructorEditable |
>>> true |
>>> | 153493 | 2751 |
>>> displayNumbering_isInstructorEditable |
>>> true |
>>> | 153494 | 2751 |
>>> timedAssessment_isInstructorEditable |
>>> true |
>>> | 153495 | 2751 |
>>> author
>>> | |
>>> | 153496 | 2751 |
>>> authenticatedRelease_isInstructorEditable |
>>> true |
>>> | 153497 | 2751 |
>>> releaseTo |
>>> SITE_MEMBERS |
>>> | 153498 | 2751 |
>>> feedbackComponents_isInstructorEditable |
>>> true |
>>> | 153499 | 2751 |
>>> recordedScore_isInstructorEditable |
>>> true |
>>> | 153500 | 2751 |
>>> dueDate_isInstructorEditable |
>>> true |
>>> | 153501 | 2751 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881313965477231 |
>>> | 153502 | 2751 |
>>> testeeIdentity_isInstructorEditable |
>>> true |
>>> | 153503 | 2751 |
>>> feedbackType_isInstructorEditable |
>>> true |
>>> | 153504 | 2751 |
>>> timedAssessmentAutoSubmit_isInstructorEditable |
>>> true |
>>> | 153505 | 2751 |
>>> ALIAS |
>>> b7d73f3d838d02f84979079ff5a725881311617657500 |
>>> | 153506 | 2751 |
>>> itemAccessType_isInstructorEditable |
>>> true |
>>> | 153507 | 2751 |
>>> anonymousRelease_isInstructorEditable |
>>> true |
>>> | 153508 | 2751 |
>>> metadataQuestions_isInstructorEditable |
>>> true |
>>> | 153509 | 2751 |
>>> hasMetaDataForQuestions |
>>> false |
>>> | 153510 | 2751 |
>>> templateInfo_isInstructorEditable |
>>> true |
>>> | 153511 | 2751 |
>>> finalPageURL_isInstructorEditable |
>>> true |
>>> | 153512 | 2751 |
>>> passwordRequired_isInstructorEditable |
>>> true |
>>> | 153513 | 2751 |
>>> hasTimeAssessment |
>>> false |
>>> | 153514 | 2751 |
>>> lateHandling_isInstructorEditable |
>>> true |
>>> | 153515 | 2751 |
>>> description_isInstructorEditable |
>>> true |
>>> | 153516 | 2751 |
>>> feedbackAuthoring_isInstructorEditable |
>>> true |
>>> | 153517 | 2751 |
>>> toGradebook_isInstructorEditable |
>>> true |
>>> | 153518 | 2751 |
>>> releaseDate_isInstructorEditable |
>>> true |
>>> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
>>> 35 rows in set (0.00 sec)
>>>
>>>
>>> This is leading to confusion for the survey takers.
>>>
>>> Does anyone know if this is the expected behavior or is
>>> there a problem?
>>>
>>> Thanks
>>>
>>> Tom
>>>
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> <mailto: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
>>> <mailto: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/20110826/72bf7eee/attachment.html
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: survey_events.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110826/72bf7eee/attachment.txt
More information about the sakai-dev
mailing list