Test for SAK-588
SAK-588: Oracle performance tuning and tracking: convert LONG columns to CLOB
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, Chat Room, Discussion Forum, Email Archive, Resources, and Schedule.
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. You may need to ask a smartsite-test admin to create a new site for you as an Instructor to test adding new tools to a course.
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 |
Chat Room |
| Log in as yourself or as sakaiinst account. Go to a course and add the Chat Room tool via Site Info - Edit Tools. Create a chat message. | Chat Room tool can be added successfully and chat message can be added successfully. | CHAT_CHANNEL XML CHAT_MESSAGE XML |
Discussion |
| Log in as yourself or as sakaiinst account. Go to a course and add the Discussion tool via Site Info - Edit Tools. Create a Topic in the Discussion tool. | Discussion tool and a new topic can be added successfully. | DISCUSSION_CHANNEL XML DISCUSSION_MESSAGE XML |
Email Archive |
| Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and add the Email Archive tool. Use the name of the course for an email address, e.g., "che2a001@smartsite-test.ucdavis.edu" for CHE 2A 001. Send an email to that address and verify that it is received in the email archive tool. | User able to successfully send an email to the course via the Email Archive tool. | MAILARCHIVE_CHANNEL XML MAILARCHIVE_MESSAGE XML |
Resources |
| Log in as the new user you created and verify that you can add a file or URL to Resources in My Workspace. | New user's Resources successfully added. | CONTENT_COLLETION XML |
Resources |
| Log in as any user and add a file or URL via Resources in My Workspace or a course or project site. | New file or URL successfully added to Resources. | CONTENT_RESOURCE XML |
Resources |
| Log in as any user and delete the file or URL you just created. | User able to successfully delete an item from Resources. | CONTENT_RESOURCE_DELETE XML |
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 |
Report any error messages or onscreen errors, specifying the tool you were using when the error occurred. Each test step is a verification that the type conversion was successful for one or more tables in the database.
Test for SAK-598
SAK-598: Convert SmartSite production database to UTF-8 character encoding
Access Level: Any tester can run this test
Test Description: The SmartSite production server is pending an upgrade to recognize UTF-8 characters; http://smartsite-test.ucdavis.edu is already upgraded. The initial test will verify that you are able to test the failure to display special characters on the production server. After the upgrade, you will verify that the production server now displays these characters correctly.
Test Steps: Test As Any User with ability to enter data online, for example, in Chat or Message Center or Tests & Quizzes
- Log into Smartsite-test.ucdavis.edu in one window and smartsite.ucdavis.edu in another window or tab.
- Select a tool in a course or project site that you have in common in both systems. The following steps will use Discussion Forum as an example
- Open another window or tab to the following UTF-8 Sampler website: http://www.columbia.edu/kermit/utf8.html
- Create a message (or enter data in another tool) by copying and pasting foreign language text from the sampler page. For example, copy the Greek phrase for "I can eat glass" into both browsers.
- Keep a list of the phrase and languages you used and continue this process until you've identified 3-5 languages which are displayed correctly on test and fail on the production server, smartsite.ucdavis.edu. Failure to interpret and display properly will be indicated by upside-down "?" or by a box character.
- Keep this list so that you can repeat this test after the production server is upgraded. Your repeat test will be verification that the production server upgrade is successful.
Test for SAK-305
Test steps: Compare these fixes on Smartsite-test with issues on Smartsite and confirm that no new issues are introduced in the UI.
...
Note: Fix for toolMenuWrap flowing past footer in IE6 still pending
| Include Page | ||||
|---|---|---|---|---|
|
Test for SAK-418
...
Patch to fix Collab issues -
SAK-8386: "The link and image buttons in the edit screen of the wiki tool do not work - in IE7 and Firefox, these buttons appear to refresh the page when clicked but have no effect over the text"
SAK-8329: "Click on the Resource Embed button in the RWiki - currently nothing at all happens."
Programmer/QA Note: this error was not reproduceable on SmartSite when tested on 3/6/07 and 3/7/07. May be based on code changes in preparation for 2.4 according to the original Jira.
Test Preparation:
- Make sure you have Instructor and Student access to a course and/or project site with the Wiki tool available
- Make sure that Resources is available on the same site with some graphic material, documents (.ppt, .doc, .xls, or .pdf) and some external URLs.
...
Patch to fix Collab issue -
SAK-8331: Clicking on RSS link in Firefox gives the following error: The server encountered an internal error () that prevented it from fulfilling this request.
Programmer/QA Note: this error was not reproduceable on SmartSite when tested on 3/6/07 and 3/7/07. May be based on code changes in preparation for 2.4 according to the original Jira.
Test Preparation:
- Make sure you have Instructor and Student access to a course and/or project site with the Wiki tool available
...