NextCallRef Issues: Difference between revisions
Jump to navigation
Jump to search
(Created page with "If you have found the following from the swserver logs. [ERROR]:[5972] Invalid callref: an entry in opencall is greater than nextcallref! The error is apparent in the log...") |
No edit summary |
||
| Line 7: | Line 7: | ||
select callref from opencall | select 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 below queries: | Then go onto the Supportworks Server, Start > All Programs > Hornbill Core Services > Interactive SQL and enter the below queries: | ||
Revision as of 11:01, 16 June 2015
If you have found the following from 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 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 below queries: use sw_systemdb; [RETURN] update system_counters set count = #### where name = 'nextcallreference'; [RETURN]