Skip to Content
0
Former Member
Jan 20, 2011 at 03:29 PM

How can I recreate user SAP*?

134 Views

Hello everybody,

Last week I needed to log on 000 client whit user SAP*, but I did not remember the password, so I used these sentences to restart it:

db2 "select * from sapsol.usr02 where mandt='000' and bname='SAP*'"

db2 "delete from sapsol.usr02 where mandt='000' and bname='SAP*'"

Now I can log on to 000 as SAP, but jobs defined previously for this user are canceled and the message "Logon of user SAP in client 000 failed when starting a step" appears in the log.

I tried to create it using SU01 but it fails and the abap dump "SAPSQL_ARRAY_INSERT_DUPREC" is generated, which indicates "The ABAP/4 Open SQL array insert results in duplicate database records."

What can I do?

Thanks in advance.