How to repair all system tables (sw systemdb): Difference between revisions

From support-works
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...")
 
No edit summary
 
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 and related services via Supportworks server configuration tool
# 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 free from error and you can restart all the remaining services via the Supportworks server configuration tool
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

  1. Stop all the Supportworks services which appear in the Server tab of the Supportworks server configuration tool
  2. Stop the SwSqlServer service:
    Using (Control panel->Administrative tools->Services
  3. Back-up the files from the following location:
    <<ServerInstallPath>>\Core Services\swsqlserver\data\ (Where <<ServerInstallPath>> is the default installation folder)
  4. Start the SwSqlServer service

Install Script

  1. Ensure you have received the following .zip: swrepairall.zip
  2. Unzip the script file to the following location:
    <<ServerInstallPath>>\Core Services\swhttpserver\bin\ (Where <<ServerInstallPath>> is the default installation folder)

Configure ODBC connectivity

  1. Open the MS Windows ODBC32 Setup
  2. Choose System DSN
  3. Click New
  4. Choose the Supportworks SQL driver
  5. Enter the Following:
    Data Source Name - Supportworks Messagestore
    Host = IP Address of the SupprotWorks Server
    Database Name = sw_messagestore
    User = root
    Password =
    Port = 5002
  6. Test Data Source

Executing the Script

  1. From the Start Window open a command window (cmd.exe)
  2. Enter the following statements:
    1. cd <<ServerIntsallPath>>\Core Services\swhttpserver\bin\
    2. 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.