[Deploying Sakai] [Building Sakai] Samigo - Annoymous survey issue
Karen Tsao
ktsao at stanford.edu
Thu Aug 25 11:30:25 PDT 2011
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> wrote:
>
> Hi Karen
>
> One of the URLs is
> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965482863where 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> 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
> 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/production/attachments/20110825/df140d88/attachment-0001.html
More information about the production
mailing list