Difference between revisions of "NextCallRef error on Server Service startup"
Jump to navigation
Jump to search
(Created page with "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 ...") |
|||
| Line 5: | Line 5: | ||
The error is apparent in the log file, then you will need to go into your MsSQL database and run the below query on the Supportworks database: | The error is apparent in the log file, then you will need to go into your MsSQL database and run the below query on the Supportworks database: | ||
| − | select callref from opencall | + | 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. | 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 | + | 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] | use sw_systemdb; [RETURN] | ||
update system_counters set count = #### where name = 'nextcallreference'; [RETURN] | update system_counters set count = #### where name = 'nextcallreference'; [RETURN] | ||
Revision as of 14:50, 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!
The error is apparent in the log file, then you will need to go into your MsSQL 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]