Is it possible to increase the request ID value or adjust the request number sequencing. Lets say we now have request ID for the latest Catalog request as 10100 and we want to have the next request to get the number 20001. Is that possible?
CA Service Catalog 17.3 and higher
Please try the following to see if this addresses the issue:
SELECT * FROM [usm_lastid] where name = 'request_id'This DB query will list the most recent request_id number that was assigned Catalog request ticket.
update [usm_lastid] set id = 20000 where name = 'request_id'
The new ticket created after the above change will be 20001.
Please test the above in a non-prod testing environment first and make appropriate database backups before trying the change in production.