Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

ID ServiceCall - clearing ID counter after testing system

Highlighted
OlArt
Super Collector

ID ServiceCall - clearing ID counter after testing system

Hi!
After testing generation Service Calls, now number (ID) of ServiceCall is starting from 318. What can I do for clearing ID counter and start new ServiceCall from ID=1?
Thanks.
4 REPLIES
Ruth Porter
Honored Contributor

Re: ID ServiceCall - clearing ID counter after testing system

Hi there,

You will need to run some SQL; for example we have used this on sQL server:

UPDATE IFC_SEQUENCES
SET SEQ_USN=new value
WHERE SEQ_CAT_OID in (
SELECT ENT_OID
FROM IFC_ENTITIES
WHERE ENT_NAME=â Service Callâ );

where new value is the number you wnat to start at

BUT you must remove all calls with IDs >= to the new value.

Hope this helps

Ruth
http://www.teamultra.net
Raghunathan Tik
Frequent Visitor

Re: ID ServiceCall - clearing ID counter after testing system

Hi,

follow the below instructions:

NOTE: BE VERY VERY CAREFUL WHILE EXECUTING THESE COMMANDS
# first you need to find out what seq_cat_oid you need,
# this the unique oid for each of the modules in sd so run the following query

select ent_name,seq_cat_oid from dbo.ifc_entities,dbo.ifc_sequences where ent_oid=seq_cat_oid;


## now write down the number (seq_cat_oid)for the module you want to change.
## STOP the app-servers !!! and PURGE all the caches !!! and then run the following

update ifc_sequences
set seq_usn=
where seq_cat_oid=;



Regards,
raman
Marcelo Sano
Super Collector

Re: ID ServiceCall - clearing ID counter after testing system

Ruth,
It´s possible to do this reset without delete the calls? I just want to reset when the year ends. When a new year begin, I need to start the ID with "1" and a prefix like 2007 - .
Peter Magdina
Regular Collector

Re: ID ServiceCall - clearing ID counter after testing system

Hi,

see http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1127674

This is the reason why you cannot start from 1 again without deleting old servicecalls. Unfortunately ServiceDesk does not support custom numbering.
//Add this to "OnDomLoad" event