Friday, February 02, 2007

Basis Ninja No More

My Basis Ninja membership was revoked last Wednesday when I committed an error of disastrous proportions. I was trying to resolve an issue with our TMS system because transports were not getting exported to our QA system. I decided to remove and then add the QA system from the transport domain. In order to do so, I have to log on to client 000 of the QA system. Well, the problem was I didn't have a login to that client and I couldn't get in with SAP* or DDIC. So, I thought I would be smart by deleting the SAP* user from the database and logging in with password 'pass'. The only problem was I didn't know the exact command to delete the SAP* user. And I was working from home on the VPN, so I couldn't google the command which is what I normally do. I start guessing the syntax but nothing is working. Then, I type 'delete from sapr3.usr02' and hit enter, hoping that would give me a clue as to what values it was looking for after. Well, the command completed successfully. I didn't think it did anything or wasn't paying enough attention so I ran a couple of other delete commands after this. That effectively committed the delete command that I ran earlier. All of a sudden I have about fifteen AIM boxes popping up with people asking if something was wrong with QA. It was then that it hit me like a ton of bricks. I was on the phone with Baxter. I had this sick feeling in my stomach. I said, "You're going to kill me." Then I told him what happened. To make a longer story less long, the restore didn't work that night, so we've been recreating users as they request them. That was my first big Basis blunder, but I'm sure it won't be my last. If it was Production instead of QA, it might have been my last.

3 Comments:

At 8:16 PM, Blogger TJ said...

Damn! See what happens when you try to go above and beyond the call of duty? You try to do something good like sneak in, and it bites you in the ass. I've googled that damn command multiple times. I think it's something like, delete * from databasename.usr02 where mandt=clientno and bname=sap*.

That being said, I'd have no idea how to do that on any of our systems running iSeries / DB2. The database / table names are weird.

 
At 8:21 AM, Blogger BigCountry said...

Yeah, apparently in DB2 you don't have to have the *. That is why I didn't think it would delete everything when I typed 'delete from sapr3.usr02'.

 
At 8:52 AM, Blogger ROCau said...

Yeah...that definitely sucks. We usually just change the profile for SAP* but you have to recycle to do that. I've never actually deleted the SAP* but I know how to change the password for DDIC so I usually just do that.

 

Post a Comment

<< Home