The objective of this protocol is to verify the installation of the LogiLAB SDMS program and to verify that it performs its intended function in a consistent and reproducible manner. Specific test objectives and acceptance criteria are defined.
The Installation Qualification consists of tests to ensure that the components of the LogiLAB SDMS program have been properly installed. Specific test objectives and acceptance criteria are defined.
This protocol specifies the Installation Qualification tests that are to be applied to the LogiLAB SDMS program, which will be used in a cGMP environment, for the purpose of verifying proper installation. The LogiLAB SDMS program was installed to capture, store raw-data, meta-data, files and transfer necessary data over the LAN to a database. Within the scope of this protocol are the activities and tasks that must be performed throughout the qualification process.
Changes made to the software and/or computer systems after validation is completed must be conducted under the appropriate system change control procedure. Parts of the protocol may be used for reconfirmation or revalidation, if necessary.
Tests within this protocol have been designed to verify that all-important elements of the LogiLAB SDMS program installation adhere to the requirements set forth by the manufacturer, when successfully completed. For each installation test in this protocol, a cover sheet is provided to define the test objective, procedure, and acceptance criteria. Following each cover sheet are the data sheets. These data sheets outline the information that must be verified and/or documented, as well as provide space for recording additional information. The information recorded on the test data sheets combined with referenced supporting test documentation provides a method whereby adherence to the test acceptance criteria can be verified.
Any deviation from the specified acceptance criteria/expected results must be recorded on a deviation report.
Acronym/Initials | Meaning |
CFR | Code of Federal Regulations |
FDA | Food & Drug Administration. |
CGMP | Current Good Manufacturing Practice |
FIELD | Meaningful data |
HTML | Hypertext Markup Language |
LAN | Local Area Network |
IQ | Installation qualification |
IIS | Internet Information Server |
N/A | Not applicable |
N/AV | Not available |
N/S | Not specified |
OQ | Operational qualification |
PC | Personal Computer |
PDF | Portable Data File |
QA | Quality Assurance |
QC | Quality Control |
SOP | Standard Operating Procedure |
UPS | Uninterruptible Power Supply |
LIMS | Laboratory Information Management System |
BLOB | Binary Large Objects |
DSN | Domain Source Name |
TCP/IP | Transmission control Protocol / Internet Protocol |
ASCII | American Standard Code for Information Interchange |
SDMS | Scientific Data Management System |
FTP | File Transfer Protocol |
DB | Database |
LogiLAB SDMS is generic software designed to handle the scientific instrument data from any analytical instruments and can facilitate data management with access control. System will perform periodic data backup and facilitate restore the same. The data collected would be stored as flat files in a FTP server in a non readable format. Data access view is controlled through user rights providing data security. The data entered by the user is sent to a centralized database server and a FTP server. All data generated from instrument or any other source in laboratory operations is captured and store centrally. Secured storage with version control of all the SOPs, Instruction manuals and MSDS can be achieved with SDMS and secured access to data as required enables availability of any required data to users. Strong search facility ensures availability of required data instantaneously.
LogiLAB SDMS will collect the Laboratory Data generated from Instrument PCs and store centrally on FTP / DB servers. Data collection will be scheduled based on each client/instrument requirement to automate the storage process. Storage structure of Archival data being maintained as is including Directory structure as per Client setup ensures easy search on LogiLAB SDMS view panels as well as restoration of data back on client as and when required. Modified files are stored with version controls and maintaining number of versions can be defined to reduce the unwanted data storage. Data on client machine can be automatically removed periodically upon backup reducing load on client machines.
LogiLAB SDMS 21 CFR Part 11 component has a security module which covers the security needs, user rights allocation, CFR policy settings like password length, ageing, auto log-off timer, audit trail, reason resource creation and electronic signature support.
Audit trail viewer will support export of audit trail into human readable format. All audit trail data is stored inside the database, is accessible and can be traced back to the actual user, date/time stamped, action performed and reason for the action.
The LogiLAB SDMS Customer has the following responsibilities:
The test plan includes IQ protocols of the LogiLAB SDMS program. The testing is detailed in the following sub-sections:
The IQ tests to ensure the components of the LogiLAB SDMS program are installed properly, including:
Computer Type: Application Server
Record the server name: ________________________________________________________________
Attach evidence for all components.
Components | Actual Result | Pass / Fail | Verified Date | Reviewed Date |
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
Verified By | Reviewed By |
Link to access Validation Environment: http://appsvr:8080/SDMS_Web/Login.html
Computer Type: Database Server
Record the server name: ________________________________________________________________
Attach evidence for all components.
Components | Pass / Fail | Verified Date | Reviewed Date | |
| ☐ Pass ☐ Fail | |||
| ☐ Pass ☐ Fail | |||
Verified By | Reviewed By |
Computer Type: Client Computers
Computer Name: Refer Annexure-A for the clients list.
Components | Pass / Fail | Verified Date | Reviewed Date |
| Pass |
Verified By | Reviewed By |
Objectives
Verify that the LogiLAB SDMS installation was performed successfully.
Procedures
Perform an inspection of the LogiLAB SDMS software installation and document any discrepancies from the installation guide.
Record all results, as required, in the appropriate location on the data sheets. If more than one data sheet will be required, record the results on photocopies of the applicable original data sheet.
Acceptance Criteria
The LogiLAB SDMS software is installed correctly.
Computer Type: Application Server
Record the computer name: ___________________________________________________________
Attach evidence for all steps.
Step | Specified Action | Expected Result | Actual Result | Pass/Fail | Verified Date | Reviewed Date | |
1 | Verify the LogiLAB SDMS folder exists in D:\Agarm Technologies\SDMS Programs\SDMS Services, having all the required files | LogiLAB SDMS folder will exists in the specified path with all the required files | ☐Pass ☐ Fail | ||||
2 | Verify the version of LogiLAB SDMS Web installed | 5.1 beta | ☐Pass ☐ Fail | ||||
Verified By | Reviewed By |
Computer Type: Application Client
Record the computer name: ___________________________________________________________
Step | Specified Action | Expected Result | Actual Result | Pass/Fail | Verified Date | Reviewed Date | |
1 | Verify the LogiLAB SDMS folder exists in C:\Program Files, having all the required files | LogiLAB SDMS folder will exists in the specified path with all the required files | ☐Pass ☐ Fail | ||||
2 | Verify whether services related to LogiLAB SDMS are started and running by going to Control Panel -> Services. | Robotic File Upload Robotic File Watcher Robotic File Monitor services will be exists in Services. msc | ☐Pass ☐ Fail | ||||
4 | Verify Chrome Web Browser Installed | Google Chrome web browser is available in system | ☐Pass ☐ Fail | ||||
Verified By | Reviewed By |
Att. No. | Description | No. Of Pages | Document Name |
1. | Screenshot of IQ report from Application Server, DB Server and Client | LogiLAB SDMS Installation Qualification Attachment v5.1 | |
2. | Annexure document for all the client PCs list | Annexure-A | |
In the following Discrepancy Log, record the discrepancy numbers for any discrepancy reports.
Include a brief description of the issue. When the discrepancy is resolved and approved, write the date resolved.
Deficiency number | Brief description | Date resolved |