Difference between revisions of "NextCallRef error on Server Service startup"
Jump to navigation
Jump to search
| 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 | + | To resolve this issue the following steps should be completed on the Supportworks Application database:<br\> |
| − | + | ||
| − | + | # Enter the following via your preferred database query tool: | |
| − | + | #:<code>select MAX(callref) from opencall</code><br\> | |
| − | This will give you | + | # This will give you the last call reference number used, please make a note of it. |
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: | 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: | ||
Revision as of 15:06, 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\>
- Enter the following via your preferred database query tool:
select MAX(callref) from opencall<br\>
- This will give you the last call reference number used, please make a note of it.
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]