Change Workorder ID in an active system

I have been resetting the ticket number to the following format year and sequential. Example is 20191900. I am currently at Version : 9.4 Build 9423 on SQL Server 2014, I have used an SQL script for the past 3 years to change the first 4 digits of the ID to set the new year. It has worked without issue for several years, I would stop the services, run the script to inject a workorder, reboot the ServiceDesk server to restart all services. Normally the next ticket to be created would be the next in sequence with the ticket number.

This year, that did not happen. I have tried it 4 times after injecting the new record, still using the 2018 format. What have I missed? Has the process changed that I need to inject a record somewhere else?

Thank you for any assistance, I am intending on upgrading to the latest version but am holding off till I get this resolved.