Managing Sequence Numbers

[kiethboots]

I find that sequence numbers for certain unique ids get mixed up. Occasionally these cause duplicate key row issues. I would have assumed that these numbers stay in a correct sequence. At the moment I have to shut down the server, and replace the the maxsequence number for a particular unique id with a larger number, to increment the sequence number, hence (xxxx.Nextval) greater than the maximum in the core table. Maybe i don't understand how sequence numbers are determined, incremented or changed by Maximo. What causes sequence numbers to get out of sequence, and how do i manage this?

[amdisuk]

I have never seen sequence numbers getting out of sequence with Maximo Mbo's before. Is the sequence problem on a custom mbo? Basically every time a record is inserted into the a tyable the sequence number 'should' be incremented. This sounds to me like you have some custom code that is inserting records but not incrementing the sequence number for that table.

Al

[amdisuk]

Depending on the table, it sounds like your sequencing is working generally. Otherwise you weould be getting lots of these errors.

[kiethboots]

Its not on a custom table, its on the joblabor table, joblaborid. How can sequence numbers be changed through the application (if there is a way)? Are there other ways to change it manually? I am not aware of the history of this system, but I have been told that is a vanila system (i.e. no significant customisations). Is manually changing the maxsequence table the best approach?

[amdisuk]

It sounds strange to me. I would check that the sequence table is indeed working correctly. Insert a record and see that the sequence increments. If it does then you must have some custom code (maybe some raw sql code) that is inserting records. If the sequence doesn't work then obviously that is the place to look. Have a look at the record insert trigger and see that it is enabled and working.

Al

[Ethen]

for every table sequence no is based on site and orgid if the table is site or org level.. for different sites same sequence no may be generated.... if you want different sequence no's for different sites or orgs you have to modify autokey table...

query would look like
Update autokey set seed = ‘100000’ where orgid=’EAGLENA’ and autokeyname=’PRNUM’


where seed is the base value where the sequencing will start and autokeyname is the name of the table...

give large different in seed for different orgs or sites..

[jyoti sukhani]

Hi

If you are working in maximo 7

than you can do the squencing in organisation application select action also

[Ethen]

yeah ryt...   but i guess there are some limitations there..

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]