NextCallRef error on Server Service startup

You may find that the Supportworks Server service is unable to start and the following error is displayed in the swserver logs:

[ERROR]:[5972] Invalid callref: an entry in opencall is greater than nextcallref!

To resolve this issue the following steps should be completed on the Supportworks Application database:<br\>

1. Enter the following via your preferred database query tool:

   select MAX(callref) from opencall

   <br\>

   This will return the last call reference number used, please make a note of it.

2. Using the Interactive SQL tool, enter the the following, replacing the "####" with the callref value returned above:

   use sw_systemdb; [RETURN]

   update system_counters set count = #### where name = 'nextcallreference'; [RETURN]<\pre>