Difference between revisions of "NextCallRef error on Server Service startup"

From support-works
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
You may find that the Supportworks Server service is unable to start and the following error is displayed in the swserver logs.
+
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!
 
  [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:
+
To resolve this issue the following steps should be completed on the Supportworks Application database:<br\>
−
 
−
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:
 
  
−
 
+
# Enter the following via your preferred database query tool:
−
use sw_systemdb; [RETURN]
+
#:<pre>USE swdata</pre>
−
+
#:<pre>SELECT MAX(callref) FROM opencall</pre>
−
update system_counters set count = #### where name = 'nextcallreference'; [RETURN]
+
#:This will return the last call reference number used, please make a note of it.
 +
#Using the Interactive SQL tool, enter the the following, replacing the "####" with the callref value returned above:
 +
#:<pre>USE sw_systemdb; [RETURN]</pre>
 +
#:<pre>UPDATE system_counters SET count = #### WHERE name = 'nextcallreference'; [RETURN]</pre>

Latest revision as of 16:13, 20 July 2015

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]
Retrieved from ‘https://wiki.support-works.com/index.php?title=NextCallRef_error_on_Server_Service_startup&oldid=689’