[rt-users] Oracle sequences in Tickets table being skipped

[Nathan, Ahalya]

Thanks a ton for the link. It helped. 

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District 
(402) 504-7180 phone
(402) 504-5180 fax



-----Original Message-----
From: Robert Blackwell [mailto:rdblackw at robertblackwell.com] 
Sent: Monday, January 09, 2006 12:16 PM
To: Nathan, Ahalya
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Oracle sequences in Tickets table being skipped



On Mon, 9 Jan 2006, Nathan, Ahalya wrote:

> Hi all,
> We are using RT 3.4.4, fastcgi and Oracle in our production
environment.
> The problem that we are facing right now is that ticket creation is
> created in skipped sequences. I checked up the TICKETS.SEQUENCE script
> and found that there is a cache option=20 being provided. I did check
up
> on the internet and found this website:
> http://www.arikaplan.com/oracle/ari82599.html , which says that :
> Applications which use Oracle sequences which have the CACHE option
> enabled will often 'skip' values.
>
> DROP SEQUENCE RT.TICKETS_SEQ;
>
> CREATE SEQUENCE RT.TICKETS_SEQ
>   START WITH 6051
>   MAXVALUE 999999999999999999999999999
>   MINVALUE 1
>   NOCYCLE
>   CACHE 20
>   NOORDER;
>
> Did anyone have this problem of skipping oracle sequences? If yes, how
> did you solve it? It would be really helpful if some one could give me
> tips how to go about this.
>
> Thanks,
> Ahalya Nathan
> Senior Programmer / Analyst
> Information Technology, Metropolitan Utilities District
> (402) 504-7180 phone
> (402) 504-5180 fax
>
>
>

This also explains a bit about the "problem".
http://asktom.oracle.com/pls/ask/f?p=4950:8:13106606684696238736::NO::F4
950_P8_DISPLAYID,F4950_P8_CRITERIA:530735152441