Run UpdateSequences.pl perl script and Correct Invalid Data for Integrator.
1. On non-production application server launch a command prompt window as administrator.
2. Go to data directory: cd D:\JDA\[Your_Instance]\LES\data
3. Run environment file: env.bat
4. Go to scripts directory: cd D:\JDA\[Your_Instance]\DCS\scripts
5. Run perl script: Perl UpdateSequences.pl -v –u
6. This script will take some time to run; it will update all sequences in the system to be at the correct stating point
except for Integrator.
7. Bounce MOCA Service for non-production instance.
8. Login to Dlx Client.
9. Go to Integration -> Diagnostics -> Correct Invalid Data
10. Select all, then Run.
11. This will fix all integrator sequences. This may take some time to finish (about 30 minutes or less depending on data volume).
How to check if a sequence was updated, such as, adr_id sequence?
1. From Dlx Client, select Server Command Operations.
2. Check maximum adr_id entry: [select max(adr_id) from adrmst where adr_id like 'A0%']
3. Check the sequence’s next value from database: select * from dba_sequences where sequence_name
like '%ADR%'
4. Make sure the sequence’s next value is greater than the max value in adrmst above.
5. If it’s not greater than or equal to that value then run the MOCA command below replacing the seed value
with the max number. In this example we’re reseeding the adr_id sequence.
reseed sequence where sequence_name = 'ADR_ID' AND SEED = 52338
|
