Trackwise Pre-Configured Supplier Audit PQ

/ Document Version 4.0/ March 2013

IQ-03: TrackWise Utilities Installation Verification

Document Version 4.0

May 2013

Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

Information in this document is subject to change without notice and, except as otherwise expressly agreed in writing by Sparta Systems, Inc., does not constitute in any way a representation, warranty or commitment on the part of Sparta Systems, Inc. The software described in this document and the documentation itself is furnished under a license agreement and/or nondisclosure agreement. The software and documentation may be used, copied, disclosed, transmitted, modified, and stored only as expressly permitted by those agreements.

TrackWise® and Sparta Systems® are registered trademarks of Sparta Systems, Inc. All other marks referenced herein are the trademarks or registered trademarks of Sparta Systems, Inc. or their respective owners. No license to any trademarks is granted herein.

Sparta Systems, Inc.
2000 Waterview Drive, Suite 300
Hamilton, New Jersey 08691
888.261.5948
/ Sparta Systems Europe, Ltd.
1 Hachoshlim Street
Herzliya, Israel 46724
972.9.970.6000

Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

Table of Contents

Document Review & Approval 4

Revision History 5

1 Test Procedures 6

1.1 General Instructions 6

1.2 Prerequisites 6

2 Test Scripts 7

3 Test Summary 9

Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

Document Review & Approval

Prepared By:

Regina Mackiewicz
Senior Analyst, Quality
Name / Title / Signature / Date

Reviewed By:

Derek Grzyb
Analyst, Quality
Name / Title / Signature / Date

Reviewed and Approved By:

Brian King
Director, Quality
Name / Title / Signature / Date
Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

Revision History

Version / Supersedes / Effective Date / Summary of Changes / Justifications /
1.0 / N/A / 07/01/2010 / Initial Version.
2.0 / 1.0 / 05/20/2011 / Updated for Release 8.3.
2.01 / 2.0 / 10/25/2011 / PR 14034 – IQ 03 and IQ 04 have same title.
Correct numbering sequence.
3.0 / 2.01 / 03/29/2012 / - PR 14189 - steps are in the incorrect order
- PR 14674 Updated for Release 8.4
remove reference FullText Admin.exe, License and Copyright information
- PR 14810 Add Reviewed By signature
4.0 / 3.0 / See Reviewed and Approved By date / - PR 16369 Add Note to Step 3 for exception
Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

1 Test Procedures

1.1 General Instructions

Markers, comments, initials and signature must be performed with indelible ink.

The initials of the person who conducts the test and the associated date will indicate the completion of the test. Any person performing IQ test cases must record all deviations from the expected results that occur while conducting the test. Initials are to be used for each completed step in the script, as long as the person’s complete name and signature is provided in the signature log.

When screen prints or reports are generated to support the test effort, these must be clearly labeled with references to the test step to which they are associated. If the test script instructions indicate that documented evidence (screen printout, hard-copy or listing) is required, the Test Procedure column will indicate (with a 3 symbol) that the evidence is required. The evidence must be labeled with the test script ID, step number it refers to, and each page numbered (as page X of Y, where X is the page number and Y is the total number of pages). The first and last pages must be initialed and dated. The evidence will be attached to the completed test script after the last page, in step order (if there is more than one).

If an exception (error) in the test script or software defect is found, a Deviation Report will be completed and the deviation added to the log. The Deviation Report number must be noted in the Actual Results column.

The same person cannot execute the test cases and review the obtained results.

The reviewer of the completed test case will: ensure that all steps in the test case have been executed, ensure that all executed steps are initialed and dated, check that all referenced deviation records are available, check that there are at least as many deviation records as there are deviation reports, and check that all required evidence has been documented and is attached. The reviewer will circle the appropriate answer to the question, “Has the Test Objective been met and ALL test steps Passed and any unexpected results resolved?” and add their initials and date to the right, and sign and date the Reviewed By field.

1.2 Prerequisites

The build date listing for the contents of the release must be available. This test should be performed only after the successful execution of IQ-01 TrackWise Installation DVD Verification.

Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 3 of 9

-Information contained in this document is confidential and proprietary -

/ Document Version 4.0/ March 2013

2 Test Scripts

TEST ENVIRONMENT: / WORKSTATION ID:
TEST TITLE: TrackWise Utilities Installation Verification
TEST OBJECTIVE: The objective of this test is to document that the TrackWise Utilities have been installed on the application server
Step / Test Procedure / Test Data / Expected Results / Actual Results / Pass (P)/ Fail (F) / Initials/ Date /
1 / From the TrackWise DVD run autorun.htm to install TrackWise in accordance with the TrackWise Installation and Upgrade Guide. / N/A / No errors are identified during the installation.
2 / Print a directory listing of the TrackWise installation directory and attach it to the test script. 3
(Local Disk>Program Files>TrackWise) / N/A / The directory listing is printed and attached to the test script.
3 / Verify the build dates for the following executables against the build date listing:
- Coordinator.exe
- Coordinator Service .exe
- db_acct.exe
- Entity Import Service.exe
- Entity Import Utility.exe
- MedDRA Import.exe
- Multiple Language Update Utility.exe
- or_updat.exe or ms_updat.exe
Note 1: is dependent upon the DBMS being used. 64-bit installations will find these files on the machine where update schema was executed
Note2: for a fresh install of TW8.4 and above, the files will not be created.
- Person Import Service.exe
- Person Import Utility.exe
- PR Import Service.exe
- PR Import Utility.exe
- Selection Import Service.exe
- Selection Import Utility.exe
- TestSMTP.exe / TrackWise Build Listing.pdf / The build date of the files matches the build date of the listing. / Step 3 Continued on this page

3 Test Summary

Test Conclusion
Has the Test Objective been met and ALL test steps Passed and any unexpected results resolved?
Circle One: Yes No / Initials and Date:
Comments
EXECUTION APPROVAL / Performed By: / DATE:
Reviewed By: / DATE:
Approved By: / DATE:
Sparta Systems, Inc. / Test Case Title / Page
TrackWise Utilities Installation Verification / 7 of 9

-Information contained in this document is confidential and proprietary -