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.