How to repair all system tables (sw_systemdb)
Jump to navigation
Jump to search
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Supportworks Version 7.5.0 onwards |
How to repair all system tables
This FAQ should only be followed by a competent Supportworks Administrator.
The Supportworks implementation will be unavailable while this task is performed.
Pre-Requisites
- Stop all the Supportworks services which appear in the Server tab of the Supportworks server configuration tool
- Stop the SwSqlServer service:
- Using (Control panel->Administrative tools->Services
- Back-up the files from the following location:
- <<ServerInstallPath>>\Core Services\swsqlserver\data\ (Where <<ServerInstallPath>> is the default installation folder)
- Start the SwSqlServer service
Install Script
- Ensure you have received the following .zip: swrepairall.zip
- Unzip the script file to the following location:
- <<ServerInstallPath>>\Core Services\swhttpserver\bin\ (Where <<ServerInstallPath>> is the default installation folder)
Configure ODBC connectivity
- Open the MS Windows ODBC32 Setup
- Choose System DSN
- Click New
- Choose the Supportworks SQL driver
- Enter the Following:
- Data Source Name - Supportworks Messagestore
- Host = IP Address of the SupprotWorks Server
- Database Name = sw_messagestore
- User = root
- Password =
- Port = 5002
- Test Data Source
Executing the Script
- From the Start Window open a command window (cmd.exe)
- Enter the following statements:
- cd <<ServerIntsallPath>>\Core Services\swhttpserver\bin\
- php.exe < swrepairall.php
Once completed all tables will be repaired and you can restart all the remaining services listed on the Server tab of the Supportworks server configuration tool.