Difference between revisions of "How to repair all system tables (sw systemdb)"
Jump to navigation
Jump to search
(Created page with "{{Template:Basic Cover |title=How to repair all system tables (sw_systemdb)|type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |applica...") |
|||
| Line 12: | Line 12: | ||
== How to repair all system tables == | == 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 === | === Pre-Requisites === | ||
| − | # Stop all the Supportworks | + | # Stop all the Supportworks services which appear in the Server tab of the Supportworks server configuration tool |
# Stop the '''SwSqlServer''' service: | # Stop the '''SwSqlServer''' service: | ||
#:Using (Control panel->Administrative tools->Services | #:Using (Control panel->Administrative tools->Services | ||
| Line 47: | Line 51: | ||
## '''php.exe < swrepairall.php''' | ## '''php.exe < swrepairall.php''' | ||
| − | Once completed all tables will be | + | 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. |
Latest revision as of 09:50, 14 August 2015
| 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.