RE: [sap-basis] Dump duplicated record when creating a new user
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by D. Caddick (SAP NetWeaver/BASIS Consultant) on May 3 at 3:06 PM |  Mark as helpful |
Hi,
You should not delete entries from SAP tables without getting assistance from SAP. There are too many other links.
Anyway this is a Question for the SAP-SECURITY group. Please post answers to this question in the SAP-SECURITY Group.
Regards
From: Steve99 via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 03 May 2010 19:36
To: D. Caddick
Subject: RE:[sap-basis] Dump duplicated record when creating a new user
Posted by Steve99
on May 3 at 2:33 PM Mark as helpful
yes...you could delete if confirm that this user should be deleted from the db. use the select statement
SQL> delete from SAPR3.USR02 where MANDT='<client_xxx>' and BNAME='<name>';
SQL> update SAPR3.USR02 set UFLAG='0' where MANDT='client_xxx' and BNAME='<name'';
SQL>commit;
this should delete user from table and update it..
---------------Original Message---------------
From: Pedro de Paula
Sent: Monday, May 03, 2010 2:07 PM
Subject: Dump duplicated record when creating a new user
> Hi all. What's happening is this.
>
> I'm want to create a "new" user but when I save after put all datas like (name, password...), I receive a dump SAPSQL_ARRAY_INSERT_DUPREC. If I try to remove the same user the system response that doesn't exist this user. It's happening for only one user.
> I saw in some tables (USR21, USREFUS) that there is a record with user but in USR02 it's not true, there isn't this user.
>
> I would like to know if we can remove, with any program or function, those entries from the tables where its exists and recreate the user.
>
>
> Thanks for your help.
__.____._ You should not delete entries from SAP tables without getting assistance from SAP. There are too many other links.
Anyway this is a Question for the SAP-SECURITY group. Please post answers to this question in the SAP-SECURITY Group.
Regards
From: Steve99 via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 03 May 2010 19:36
To: D. Caddick
Subject: RE:[sap-basis] Dump duplicated record when creating a new user
Posted by Steve99
on May 3 at 2:33 PM Mark as helpful
yes...you could delete if confirm that this user should be deleted from the db. use the select statement
SQL> delete from SAPR3.USR02 where MANDT='<client_xxx>' and BNAME='<name>';
SQL> update SAPR3.USR02 set UFLAG='0' where MANDT='client_xxx' and BNAME='<name'';
SQL>commit;
this should delete user from table and update it..
---------------Original Message---------------
From: Pedro de Paula
Sent: Monday, May 03, 2010 2:07 PM
Subject: Dump duplicated record when creating a new user
> Hi all. What's happening is this.
>
> I'm want to create a "new" user but when I save after put all datas like (name, password...), I receive a dump SAPSQL_ARRAY_INSERT_DUPREC. If I try to remove the same user the system response that doesn't exist this user. It's happening for only one user.
> I saw in some tables (USR21, USREFUS) that there is a record with user but in USR02 it's not true, there isn't this user.
>
> I would like to know if we can remove, with any program or function, those entries from the tables where its exists and recreate the user.
>
>
> Thanks for your help.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. CaddickSAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
