Difference between revisions of "Expanding the Number of Available Levels For Problem Profile Codes"

From support-works
Jump to navigation Jump to search
 
Line 3: Line 3:
  
  
−
2. Ensure all Support-Works Clients Are Logged Off for the duration of these instructions.
+
1. Ensure all Support-Works Clients Are Logged Off for the duration of these instructions.
  
−
3. On the Supportworks Server - stop the SwServerService service.
+
2. On the Supportworks Server - stop the SwServerService service.
  
−
4. On the Supportworks server run the following:
+
3. On the Supportworks server run the following:
  
 
  Start ... Programs Hornbill Core Services.... Database Schema Editor
 
  Start ... Programs Hornbill Core Services.... Database Schema Editor
  
−
5. In the Database Schema Browser pane expand the database used by the Supportworks server (by default this is the "swdata" database).
+
4. In the Database Schema Browser pane expand the database used by the Supportworks server (by default this is the "swdata" database).
  
−
6. In the Database Schema Browser pane click on the "opencall" table so that it is highlighted.
+
5. In the Database Schema Browser pane click on the "opencall" table so that it is highlighted.
  
−
7. With the opencall table selected scroll down to the "probcode" columns, in the Columns tab on the right hand side and double click it.
+
6. With the opencall table selected scroll down to the "probcode" columns, in the Columns tab on the right hand side and double click it.
  
 
In the Columns Attributes Window that opens up increase the "Max Data Size" value and OK then change. (NOTE: for every level required an increasing this value by 5 is required, for
 
In the Columns Attributes Window that opens up increase the "Max Data Size" value and OK then change. (NOTE: for every level required an increasing this value by 5 is required, for
Line 23: Line 23:
 
the maximum number of levels is 8 therefore the maximum value that this parameter should be set to is 41).
 
the maximum number of levels is 8 therefore the maximum value that this parameter should be set to is 41).
  
−
8. In the Database Schema Browser pane scroll to the PCDESC table and click on it so that it is highlighted.  In the Columns tab on the right hand side double click on the CODE column  
+
7. In the Database Schema Browser pane scroll to the PCDESC table and click on it so that it is highlighted.  In the Columns tab on the right hand side double click on the CODE column  
 
to open up it's properties.  Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.
 
to open up it's properties.  Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.
  
−
9. In the Database Schema Browser pane scroll to the PCINFO table and click on it so that it is highlighted.
+
8. In the Database Schema Browser pane scroll to the PCINFO table and click on it so that it is highlighted.
 
In the Columns tab on the right hand side double click on the CODE column to open up it's properties.
 
In the Columns tab on the right hand side double click on the CODE column to open up it's properties.
 
Increase the "Max Data Size" value to match the value entered into the properties of the
 
Increase the "Max Data Size" value to match the value entered into the properties of the
 
OPENCALL.PROBCODE field and OK the change.
 
OPENCALL.PROBCODE field and OK the change.
  
−
10. In the Database Schema Browser pane scroll to the PROBCODE table and click on it so that it is highlighted.
+
9. In the Database Schema Browser pane scroll to the PROBCODE table and click on it so that it is highlighted.
 
In the Columns tab on the right hand side double click on the CODE column to open up it's properties.
 
In the Columns tab on the right hand side double click on the CODE column to open up it's properties.
 
Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.
 
Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.
  
−
11. Once these changes have been made from go to the toolbar of Supportworks Database Schema Editor utility and from the "Database" pull down menu select the option to "Apply
+
10. Once these changes have been made from go to the toolbar of Supportworks Database Schema Editor utility and from the "Database" pull down menu select the option to "Apply
 
Specification to Physical Database".
 
Specification to Physical Database".
  
−
12. Close the Supportworks Database Schema Editor utility.
+
11. Close the Supportworks Database Schema Editor utility.
  
−
13. Start the SwServerService service.
+
12. Start the SwServerService service.
  
−
14. Log into a Supportworks client and test.
+
13. Log into a Supportworks client and test.

Latest revision as of 15:59, 28 June 2018

In accordance with good working practice, it is advisable to backup your database files before commencing any operation that will change live data.


1. Ensure all Support-Works Clients Are Logged Off for the duration of these instructions.

2. On the Supportworks Server - stop the SwServerService service.

3. On the Supportworks server run the following: 

Start ... Programs Hornbill Core Services.... Database Schema Editor

4. In the Database Schema Browser pane expand the database used by the Supportworks server (by default this is the "swdata" database).

5. In the Database Schema Browser pane click on the "opencall" table so that it is highlighted.

6. With the opencall table selected scroll down to the "probcode" columns, in the Columns tab on the right hand side and double click it.

In the Columns Attributes Window that opens up increase the "Max Data Size" value and OK then change. (NOTE: for every level required an increasing this value by 5 is required, for example increasing this from it's default value of 16 to 21 will increase the number of problem profile levels from the default of 3 to 4 levels, increasing this from it's default value of 16 to 26 will increase the number of problem profile levels from the default of 3 to 5 levels.... NOTE:

the maximum number of levels is 8 therefore the maximum value that this parameter should be set to is 41).

7. In the Database Schema Browser pane scroll to the PCDESC table and click on it so that it is highlighted. In the Columns tab on the right hand side double click on the CODE column to open up it's properties. Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.

8. In the Database Schema Browser pane scroll to the PCINFO table and click on it so that it is highlighted. In the Columns tab on the right hand side double click on the CODE column to open up it's properties. Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.

9. In the Database Schema Browser pane scroll to the PROBCODE table and click on it so that it is highlighted. In the Columns tab on the right hand side double click on the CODE column to open up it's properties. Increase the "Max Data Size" value to match the value entered into the properties of the OPENCALL.PROBCODE field and OK the change.

10. Once these changes have been made from go to the toolbar of Supportworks Database Schema Editor utility and from the "Database" pull down menu select the option to "Apply Specification to Physical Database".

11. Close the Supportworks Database Schema Editor utility.

12. Start the SwServerService service.

13. Log into a Supportworks client and test.

Retrieved from ‘https://wiki.support-works.com/index.php?title=Expanding_the_Number_of_Available_Levels_For_Problem_Profile_Codes&oldid=1513’