Skip to Content
0
May 13, 2010 at 09:46 PM

USR02 wiped out during client export (users) from BW production system

71 Views

Hi,

I am sharing my experience about a strange incident , where USR02 table

got wiped out , when Basis was performing client copy export(users) in BW production system.

In that strange critical situation , SAP Supports answer was to restore the last backup, which

was not considered as a time efficient solution , since time required for this was more.

Only approach left was to create the users again , and assign roles.

Thanks to SUIM change documents which was working at that movement , and I was able to extract list

of users , and their roles assignments . Which was a starting point to create and restore users back using

CATT script. which was accomplished within few hours.

This remains a mystery how and why only USR02 table got wiped out from a production environment.

Whether SAP Support has an answer for this or not ?

Has anyone else experienced same problem earlier.please share

Thanks

Puneet