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.
Smartsite skin updates from Simon to correct the following issues:
- Fixed issue with grey background on content not extending to bottom of page in IE7 and IE6.
- Fixed: footer in IE7 not positioned at bottom of page
- Added min-width rule to stop header images wrapping in very narrow browser widths
- Fixed long site names forcing site select box edge off screen
- Fixed remaining scrollbar problems on some portletBody items, fixed selectNav dropping down below nav bar in IE browsers
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.
Test Steps:
Steps | User Acting As | Action | Expected Result |
|---|---|---|---|
1 | Instructor | Select Wiki from your course menu and then select the Edit button. Type the name of a new page in square brackets, i.e., [new page]; select Save button. | "new page" will be shown as a hyperlink with a question mark after it on the Home page. |
2 | Instructor | Select the new page and then select Edit button or link. You may edit or delete the text in the text area box. Select the Link icon (second from right of page editing tools.) | Selecting link will send the user to Resources. |
3 | Instructor | Use the select option under the Actions column in Resources to select a graphic, document or external url or click 'add new' to upload a new file from your computer. Select Continue at the bottom of the Resources page. | Coded link is added to the wiki page after a resource is selected and the user is returned to the wiki page. |
4 | Instructor | Select Save on the wiki edit page. Test the url to verify that it works. | A new link is displayed on the page. A graphic, html file or html selected from the url link may be displayed in the wiki frame; a link to a Word, Excel, PDF, PowerPoint or other document type is available as a downloadable file. |
5 | Instructor | Select the new page and then select Edit button or link. Select the Image icon (last one on the right of page editing tools.) | Selecting link will send the user to Resources. |
6 | Instructor | Use the select option under the Actions column in Resources to select a graphic file or or click 'add new' to upload a new image from your computer. Select Continue at the bottom of the Resources page. | The selected graphic is displayed in the wiki and is not a link. |
7 | Student | Log in as a Student in the course and repeat steps 1-6. | Results should be the same. May need to use 'add new' Resource function if student user has no files avaiilable. |
8 | project maintain user | Log in to a project site where you have a maintain role and repeat steps 1-6. | Results should be the same. May need to use 'add new' Resource function if project maintain user has no files avaiilable. |
9 | project access user | Log in to a project site where you have an access role and repeat steps 1-6. | Results should be the same. May need to use 'add new' Resource function if project access user has no files avaiilable. |
Test for SAK-413
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
Test Steps:
- As an Instructor, access Wiki in your course and select the RSS icon in the upper right hand corner from various pages of the wiki.
- Verify that no error messages appear. If an error message occurs, document in the Jira what you were doing/accessing when the error occurred and post a screen shot of the error.
- Repeat these steps as a Student in the course site.
- Repeat these steps as a project site member with maintain permission.
- Repeat these steps as a project site member with access permission.