2 Replies Latest reply: Jul 23, 2012 2:31 AM by Luciano Muller Nicoletti RSS

7.6.04 set nextid=100000000000 doesn't work

Luciano Muller Nicoletti

Hi,

 

I need to reserve first IDs for imported incidents from old system into the new one, and then reset the incident ID counter to INC100000000000.

 

So I stopped arsystem then ran the following query :

 

update arschema set nextid=100000000000 where name = 'HPD:Help Desk';

update arschema set nextid=100000000000 where name = 'HPD:CFG Ticket Num Generator';

commit;

 

Then restarted arsystem, but when I create a new incident, I get a weird Incident ID number  = INC001410065410 instead of

INC100000000001 ...

 

For information, that's a clean installation of ITSM 7.6.04 SP2, there is no incidents created on the system yet and "Next ID Block Size" = 10 ;

 

I noticed that if I set nextid=1000000000 (9 zeros) instead of nextid=100000000000 (11 zeros) it works fine or, in other words, it works fine with nextid  INC001000000000  but not with nextid INC100000000000.

 

Any help would be appreciated.