ESU restore removes entries from F9861

Hi,

With JD5550 on B7332 and SP 17.1, I installed an ESU (JD14114) where I found somes bugs (ST/OT not working). I wanted to revert to the state before applying the ESU, so I used the Software Update program and I restored the backup as explained in doc.

But unfortunately, I dicovered, when I run OL, that for all objects restored, all entries are removed from F9861 for all pathcode except the one where I installed/restored the ESU which is correct.

Anyone encoutered this problem ?
What is the best way to recover the lost entries in F9861 ? (the backup that I have is 2 days aged and cannot be used because some work on objects were made in the other environments since backup, and some objects are check-out ...)
I don't know if some other information is missing from the other tables? Can someone is familiar with software restore process in its internals ?

I am in hurry because I blocked everyone from doing any checkout/checkin till the problem will be resolved.

Please help !

Maher SAMET


OW B733.2 SP17.1 on NT4 SP6a and SQL 7/SP3.

Gee,

I though I was the only one!

This always, always, always happens to me in B733.2 and drives me nuts to no
end! I really try not to restore ESU but instead wait for a superceeding
ESU.

I haven't SAR'ed this yet but perhaps if we both call in they'll actually
believe us!

Here the crazy work around that I use.

What objects librarian records are missing?
1. You can look at the ESU object list. This will tell you all the objects
in all the 'other' pathcodes for which OL records got deleted. Ie if you
applied the ESU to DEVB733 all the records for CRPB733 and PRODB733 would be
gone.

2.Objects whose OL Records are in DEVB733 but are not in CRPB733:
SELECT SIOBNM from OBJB733.F9861 where SIPATHCD='DEVB733' minus SELECT
SIOBNM from OBJB733.F9861 where SIPATHCD='CRPB733'

NOTE: Look at the R98700 for the spec merge. This is the best record of what
the ESU actually did when it went in. This will also tell you what objects
previously existed (replaced) and what objects are new (added). Do not add
the OL records for the new objects to pathcodes where the ESU has not been
applied (assuming you apply ESU's to DEVB733, CRPB733 then PRODB733 in
order). As for what the ESU actually does when it's being restored - I have
no clue.

How do I restore the OL records?
1. Microsoft Access
Copy the F9861 to MS Access on a workstation and cut and paste in the
records you know are missing. Update the pathcode each time.

2. Database tools
Use the previous select to capture the records that have been lost (to a
temp table). Then remove any new objects added by the ESU. Update the
pathcode to CRPB733 and insert these records back in. Repeat for PRODB733.

Hope this helps.

Colin

B733.2 SP17.1_F1
Intel/NT/Oracle 8.1.7.1
FAT & WTS

How many objects are in the ESU? If there aren't a ton, you can update the entries in the F9860/F9861 via SQL.

Hope this helps.

Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000 Java Servers, Central Objects in Oracle.

Re: RE: ESU restore removes entries from F9861

Hi cdawes8/Colin,

Your Help is very precious. I was afraid that tables other than F9861 was touched (corrupted) by the restore.

I will do what you said (but starting from the nearest backup before the ESU restore) instead of copying the entries from DEV to CRP and PROD, it's perhaps better (the other columns are more realistic).

I called JDE, but after looking, they said "the only way to do this is to restore the JDEB733 database only (not business data)". Horrible, because they didn't thought enough of the loses of the other tables (I mean : why to restore all the database, if only copying the lines missing from the old backup for the only one table). Excuse my english.

I will respond to the call to open a SAR but I think nothing will be done before B7332 will be out "of support".

Anyway, thanks to you very much.

Bye.

Maher

Hi Matthew

After checking the differences (count(*) between the current situation and the last backup before the ESU restore), it seems that only the F9861 is corrupted. I will restore the entries of the objects that are missing 54 objets, so 108 entries in the table (CRP+PROD).

Thank you.

Maher

The SAR number for this is 5858911.

Colin

B733.2 SP17.1_F1
Intel/NT/Oracle 8.1.7.1
FAT & WTS