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



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';



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.