Difference between revisions of "Expanding the Number of Available Levels For Problem Profile Codes"
| Line 1: | Line 1: | ||
| − | + | ||
| − | + | In accordance with good working practice, it is advisable to backup your database files before commencing any operation that will change live data. | |
| − | In accordance with good working practice, it is advisable to backup your database files before | + | |
| − | commencing any operation that will change live data | + | |
| − | 2. | + | 2. Ensure all Support-Works Clients Are Logged Off for the duration of these instructions. |
| − | Ensure all Support-Works Clients Are Logged Off for the duration of these instructions. | + | 3. On the Supportworks Server - stop the SwServerService service. |
| − | 3. | + | 4. On the Supportworks server run the following: |
| − | On the Supportworks Server - stop the SwServerService service. | + | |
| − | 4. | + | Start ... Programs Hornbill Core Services.... Database Schema Editor |
| − | On the Supportworks server run the following: | + | |
| − | 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). |
| − | 5. | + | 6. In the Database Schema Browser pane click on the "opencall" table so that it is highlighted. |
| − | In the Database Schema Browser pane expand the database used by the Supportworks | + | 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. |
| − | server (by default this is the "swdata" database). | + | |
| − | 6. | + | 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 Database Schema Browser pane click on the "opencall" table so that it is highlighted. | + | 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 |
| − | 7. | + | value of 16 to 26 will increase the number of problem profile levels from the default of 3 to 5 levels.... NOTE: |
| − | With the opencall table selected scroll down to the "probcode" columns, in the Columns tab | + | |
| − | on the right hand side and double click it. | + | the maximum number of levels is 8 therefore the maximum value that this parameter should be set to is 41). |
| − | 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 | + | 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 |
| − | example increasing this from it's default value of 16 to 21 will increase the number of problem | + | 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. |
| − | profile levels from the default of 3 to 4 levels, increasing this from it's default value of 16 to 26 | + | 9. In the Database Schema Browser pane scroll to the PCINFO table and click on it so that it is highlighted. |
| − | will increase the number of problem profile levels from the default of 3 to 5 levels.... NOTE: | + | In the Columns tab on the right hand side double click on the CODE column to open up it's properties. |
| − | 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 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. | ||
| − | 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. | + | 10. In the Database Schema Browser pane scroll to the PROBCODE table and click on it so that |
| − | In the Database Schema Browser pane scroll to the PROBCODE table and click on it so that | ||
it is highlighted. | it is highlighted. | ||
In the Columns tab on the right hand side double click on the CODE column to open up it's | In the Columns tab on the right hand side double click on the CODE column to open up it's | ||
| Line 46: | Line 31: | ||
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. | ||
| − | 11. | + | 11. Once these changes have been made from go to the toolbar of Supportworks Database |
| − | 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 | Schema Editor utility and from the "Database" pull down menu select the option to "Apply | ||
Specification to Physical Database". | Specification to Physical Database". | ||
| − | 12. | + | 12. Close the Supportworks Database Schema Editor utility. |
| − | Close the Supportworks Database Schema Editor utility. | + | 13. Start the SwServerService service. |
| − | 13. | + | 14. Log into a Supportworks client and test. |
| − | Start the SwServerService service. | ||
| − | 14. | ||
| − | Log into a Supportworks client and test. | ||
| − | |||
Revision as of 15:55, 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.
2. Ensure all Support-Works Clients Are Logged Off for the duration of these instructions.
3. On the Supportworks Server - stop the SwServerService service.
4. On the Supportworks server run the following:
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). 6. 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.
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).
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 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. 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. 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. 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 Specification to Physical Database". 12. Close the Supportworks Database Schema Editor utility. 13. Start the SwServerService service. 14. Log into a Supportworks client and test.