Address Book Next Numbers skipping

i_stevens

i_stevens

Member
Hi All

First of all, please forgive me as I know this has been discussed on the list
before. I have searched the archives and drawn a blank, so I need your help.

Our address book next numbers are skipping sporadically. This has previously
been reported to JDE and their suggested resolution is to monitor when they are
changing and work out what Applications/UBE's may be being used when the next
number skips. Not an easy task ! Since going live, we have added approximately
5000 records to our address book, but the system thinks we have used 62,000
records (at this rate, we might run out as we have lots of employees and lots of
suppliers).

We have reviewed several things:
- we don't have check digits on
- we are sure there is no conlict between any environments (ie. we are not using
a common Next Numbers file between Dev and Prd).
- we have reviewed all tables that have changed on a particular day, but can't
find any that contain a number that looks like it's been drawn from the Address
book next number range.

I have tried to put event rules on the Next Numbers table to output to a new
table with the User Id and Program Id of the user making the change. As soon as
i put Event Rules on the Next Numbers table, I get "Business Function caused a
memory violation" when trying to enter a new Address Book Record.

I would appreciate any help you can give:

1. Has anyone out there stumbled across a solution for the A/B next numbers
skipping
2. Anyone know why I am getting "Business Function Memory Violation" after
adding new Event Rules to the Next Numbers table
4. Any other ideas for tracking changes to the Next Numbers table (it doesn't
contain the usual "Audit fields" like most tables do).

Please help !

Desperate and about to tear my hair out !

FYI - I am posting this on both the Jdelist and Jdelist Developers forums.

Thanks
Ian

B733.2 SP11.1, AS/400 V4R4M0, World 11 X2 Coexistence.

View our website at http://www.monadel.com.au

|---------------------------------------------------------------------------|
| |
| If this communication is not intended for you and you are not an|
| authorised recipient of this email you are prohibited by law from dealing|
| with or relying on the email or any file attachments. This prohibition|
| includes reading, printing, copying, re-transmitting, disseminating,|
| storing or in any other way dealing or acting in reliance on the|
| information. If you have received this email in error, we request you|
| contact us immediately by returning this email to|
| [email protected] and destroy the original. |
|---------------------------------------------------------------------------|






B733.2 SP11.1, A73 Cum 11 (Payroll)
Ent Svr AS/400 V4R4, Dep Svr NT4 SP5
 
Ian,

Since your on an AS/400 why not switch on journaling on F0101 for a while.
You should then be able to trace the problem

/ Ian








Xe, Oracle 8, NT
 
IStevens,
Look up SAR #5242341 it will refer to ESU JD13532.
It also corrects the Phonelist overwriting numbers on it's own.

Bob Duben

*JDE CNC, CMA
AS400@V4R5, Xe SP16.1 XU3/A73 CUME11, CoExist, NT4.0 (SP6a), NT4.0 Citrix, Win2k Citrix XPe
500 mixed clients
 
Back
Top