...
Access Level: 
Any tester can run some steps; 
admin access required for some steps
Test Description: The smartsite-test database server was recently updated to convert long text fields to a different format. This new format enhances performance by allowing Oracle to shrink space for reclamation and to allow the fields to be searched more easily.
The update affects the following tools: Announcements, Assignments, Calendar, Chat Room, Discussion Forum, Email Archive, Resources, and ResourcesSchedule.
Test Steps
To test this update, you simply need to verify that each of these tools still work and are unaffected by the database change. This may require adding tools to a site where you are an instructor or logging in using one of the sakaiinst or sakaistu accounts.
Tool | User Acting As | Action | Expected Result | Technical Verification |
|---|---|---|---|---|
Announcements |
| Log in and create a new user. Log in as that user via the xlogin method (not through Kerberos.) Select Announcements in MyWorkspace. Verify that you can access the announcements screen without error. | Announcements is accessible to new users when their announcement channel is created. | ANNOUNCEMENT_CHANNEL XML field |
Announcements |
| Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an announcement. View that announcement. | Announcement is successfully created. | ANNOUNCEMENT_MESSAGE XML field |
Assignments |
| Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an assignment. | Assignment is successfully created. | ASSIGNMENT_ASSIGNMENT XML ASSIGNMENT_CONTENT XML |
Assignments |
| Log in as yourself or as sakaistu account. Go to the course where you added the assignement and submit a text response. | Assignment is successfully submitted. | ASSIGNMENT_SUBMISSION XML Calendar |
Chat Room |
|
|
| |
Discussion Forum |
|
|
| |
Email Archive |
|
|
| |
Resources |
|
|
| |
Schedule | | Log in as the newly-created user via the xlogin method (not through Kerberos.) Select Schedule in MyWorkspace. Verify that you can access the new user's calendar without error. | Calendar is accessible to new users when it is created. | CALENDAR_CALENDAR XML field |
Schedule |
| Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an event in the Schedule calendar. | Calendar event is successfully created. | CALENDAR_EVENT XML |
Chat Room |
|
|
| |
Discussion Forum |
|
|
| |
Email Archive |
|
|
| |
Resources |
|
|
|
Test for SAK-598
SAK-598: Convert SmartSite production database to UTF-8 character encoding
...