icons are missing after Homogenous system copy

[Former Member]

Hi,

I suspect that this may not be i5 specific but need to start somewhere.

We hare having a wierd issue with our GUI users since we did a homogenous system copy of PRD back to TRN. The icons below the menu bar are now all buttons with text. We have another instance (DEV) on the same server using the same version of the Kernel (117 unicode) so I think that rules out PTF's and kernel. I also tried it with two different patch levels of the 640 GUI and one test with the 7.10 GUI. The results are the same.

Further we deleted Screen Loads and ran SGEN with no change. Has anyone run ito this before? Our R/3 version is 4.7 unicode running on V5R3.

Thanks,

Craig

[Former Member · Accepted solution]

The issue is with the replication of files with field types of LOB .......most specifically DBCLOB. There were issues in the summer of 2006 in the newer releases of SAP and with the information that MIMIX received from IBM in the journal streams. These issues were resolved but it sounds like they have not been implemented in your environment.

Replication must be using remote journaling. Using remote journaling likely eliminates the needs for the OS PTF's that were suggested for the specific issue if memory serves me right. Remote journaling is also more efficient for replicating the files of this type.

You should also be at the lates MIMIX service pack of at least SP078.02. There may have been earlier MIMIX releases that supports the above, but I do not recall at what levels. If you send me the service pack level you are at, I can research to see if you have a level that will work.

Audits will report the differences for the files in question but cannot repair them at OSV5R3. MIMIX can repair the differences if using MIMIX V5 and OS V5R4.

[Former Member]

Volker/Victor - Do either of you know the probable extent of the problem? I'm just curious if it would affect large numbers of tables or is localized to only a few. We have a HA switch planned for Friday the 13th. I am pretty sure based on the information from this message chain, we will test the switch one way then just restore the MIMIX copy.

Victor, do you happen to have the PTF numbers? I hope to have any patches they require applied before the test.

Thanks to you both,

Craig

[Former Member]

Hi Craig,

Not many tables are impacted, and very likely other tables have 0 records. If you have done a full backup/restore after SAP release upgrade, likely only those 2 tables are affected.

Sorry that I don't have those PTF numbers... You can contact Mimix support, or just get the full PTF list (the pdf file) from the website.

I did the following to fix the issue: (Assuming that Mimix is patched already.)

1. Apply the PTFs on the backup server

2. About 10 minutes before the switch, sync those tables manually with SAVRST method (In my case, most of the screens look ok after switch, but it is not a sure thing...)

3. Switch over (hope the best )

4. Apply the PTFs on the production server

5. Sync those tables again (either DATA or SAVRST should work now)

6. Switch back

Best regards,

Victor

[Former Member]

Hi Craig,

I can only support Victor that mostly only these 2 tables are affected. But, I would like to warn you with a role swap before the PTFs are fixed and a backup and restore to test shows, that it really works fine ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hi Craig,

are you really talking of a restore of the backup of your "true database" or of a mimix or whatever replication ?

I had this some times in the past when the backup on the mirror, because with older tools and/or OSs it was "typical" that the mirror is outdated :-(((

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hi Volker,

Are you saying you saw this exact problem with other replication copies?

You are correct this was on the MIMIX copy. Our Mimix version is fairly current as is V5R3. So are you thinking that there is no hope of getting this to work or are there some tables that could still be copied over from "real" PRD to recover?

Perhaps the audit programs are not sufficent?

Thanks,

Craig

[Former Member]

Hi Craig,

I would say, now you are in really bad luck !

Why ? Not because of this wrong copy - this could be perhaps "more or less" corrected with recreation of the GUI states etc.

BUT:

You are obviously doing your PRD backup on the mirror and the mirror is OUTDATED !!!!!

You should contact Mimix and tell them on this. It will deal with the effect, that BLOB fields cannot or are not correct synchronized. I heard, that there are features in the OS/400 were missing - but I really don't know that ...

At least: THIS is the root cause of your problem !

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hi Craig,

Volker is totally correct on locating the root cause for your problem... From what I experienced, this issue should have been fully solved by IBM and Lakeview regarding one data type used in table D345T and D346T.

Lakeview has its own PTF recommendation - a pdf file downloadable from its website. In the list, 2 PTFs are related to this issue. And without them, those tables are not correctly synchronized, and the audit program cannot detect the data difference.

If you have strong ABAP support, regenerate all the screen/GUI with tools like LSMW. As I remember, SGEN doesn't solve this issue as you also tried.

I never tried to restore only D345T and D346T from current PRD database to TRN/TST. Not sure what you would get.

Best regards,

Victor