NextCallRef error on Server Service startup

From support-works
Revision as of 16:13, 20 July 2015 by Rickyf (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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:
    USE swdata
    SELECT MAX(callref) FROM opencall
    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]