NextCallRef error on Server Service startup

From support-works
Revision as of 14:51, 20 July 2015 by Rickyf (talk | contribs)
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 then you will need to go into your SQL database and run the below query on the Supportworks database: 

select MAX(callref) from opencall

This will give you a list of the call references in the system, please make a note of the highest call reference number.

Then go onto the Supportworks Server, Start > All Programs > Hornbill Core Services > Interactive SQL and 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]
Retrieved from ‘https://wiki.support-works.com/index.php?title=NextCallRef_error_on_Server_Service_startup&oldid=680’