unable to Delete client

[Former Member]

hi

i have creat new client 300, but it is not working properly that's why i want to del it but unable to delete this , also i have test run to delete client showing error timeout

" Runtime Errors TIME_OUT

Date and Time 26.03.2009 10:28:43

What happened?

The program "SAPLSCCM" has exceeded the maximum permitted runtime without

interruption and has therefore been terminated. "

plz tell me how can i delete that client

regard

[Former Member · Accepted solution]

Hi

I would prefer to leave it like this only

but there is one more method by which you can delete the client by using R3trans at OS level

1. Create a R3trans control file ie remove_300 enter the following

in the file:

clientremove

client = 300

select *

2. Then from the OS command line run: R3trans -v remove_200

This will produce a file called trans.log showing the steps done.

Ths method is faster,so if you want you can try this

Rohit

[Former Member · Accepted solution]

Thanks

How can i create control file and save in which format (e.g bat, txt, or...)

regard

[Former Member · Accepted solution]

just open notepad file and save your entries there,save in the format .bat

Then you can execute that file

Rohit

[Former Member · Accepted solution]

i have create control file with .bat and palce in bin folder , but when i execute command

it generate error

G:\usr\sap\trans\bin>R3trans -v remove_300

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

2EETW152 Cannot open file "remove_300".

R3trans finished (0012).

[Former Member · Accepted solution]

Imran,you will have to give the path of the remove_300 file where it is located

i.e R3trans -v <complete path of remove_300 file>

Rohit

[Former Member · Accepted solution]

Imran,

1. Login at OS level as <sidadm> and CD to /usr/sap/trans/bin directory.

2. Create a control file (text file), for eg., client_del.ctl with the text below ( u can use touch or vi for this)

clientremove

client=<nnn>

select *

where <nnn> is the client number to be deleted.(300 in ur case; )

3. Save the file and execute the below command (as user sidadm, always)

R3trans -w client_del.log -u 1 client_del.ctl

4. to view the progress of logs,

$ tail -f client_del.log

thanks

Bhudev

[Former Member · Accepted solution]

hi

i already did the same that you told but after 2 hrs it shows error and terminated which is below :

2EETW000 sap_dext called with msgnr "900":

2EETW125 SQL error "2289" during "" access: "ORA-02289: sequence does not exist"

so why this error occur and how to solve this

rgds

imran

[Former Member · Accepted solution]

Hello Imran,

Thats why I suggested you not to go for deletion of client through OS level as you have already started through.That might have caused some inconsistencies.

As the error suggests there is some sequence missing in the client.is that all what error logs says,doesnt it refers to some table,please paste the full logs

Rohit

[Former Member · Accepted solution]

Imran

There is a note 185821 which you can refer for this error.It talks about DDLOG table and I guess your issue should get resolved

Try executing this

Log on to the Oracle database as user SAPR3, and execute the following statements:

truncate table ddlog;

create sequence ddlog_seq minvalue -2147483640 maxvalue 2147483640

increment by 1 cache 50 noorder nocycle;

It might help

Rohit

[Former Member · Accepted solution]

hi

we execute the command of truncate table ddlog and run again the r3trans after finishing it without error log is as under

-

---

4 ETW000 Summary:

4 ETW000

4 ETW000 Totally 3 table entries deleted.

4 ETW000 [dev trc ,00000] Fri Mar 27 12:20:10 2009 761620839 5072.293064

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 757540 5073.050604

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 993 5073.051597

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=00000000050FE5A8,usrhp=00000000050F9738)

4 ETW000 3700 5073.055297

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=00000000050FE5A8,srvhp=00000000054F30E8)

4 ETW000 525 5073.055822

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 599 5073.056421

4 ETW000 [dev trc ,00000] Disconnected from connection 0 17 5073.056438

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

4 ETW000 19 5073.056457

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 17 5073.056474

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 27.03.2009 - 12:20:10

-

---

after that we stop mmc and db also restrat the system but when we logon to the client 300 i connected to this , so tell me deletion is performed or not

rgds

imran

[Former Member · Accepted solution]

How much time did it took?

I would suggest you check the size of client to check whether it is deleted,execute the report RSSPACECHECK to check the size and also check SCC3,there you can find the client deletion logs,if it over it will show that client has been deleted successfully

Rohit

[Former Member · Accepted solution]

hi..

it takes more than 1 hour , nothing shows in scc3, how i execute report RSSPACECHECK

Regard

imran

[Former Member · Accepted solution]

I guess it has been deleted than....log into another client and in SCC4 delete the entry of client 300(which you have deleted).

You can execute the report by logging in the client which you have deleted and use SE38 ,type the name of report and execute it

Rohit

[Former Member · Accepted solution]

Thanks Rohit

Client has been deleted ,

Best Regard

Imran Khan

[Former Member]

i also have a proble in deleting a client

here's some info

-

---

Client to be Deleted	600
Copy Type	Delete Complete Client
Status	Cancelled
User	SAP*
Start on	06.11.2009 / 13:48:31
Last Entry on	06.11.2009 / 13:57:39
Last Action:	Copy/Delete Tables
- Table Being Edited:	BFOD_A
Statistics for this Run
- No. of Tables	6707 of 54438
- Number of Exceptions	11
- Deleted Lines	0
Check System Log (SM21)

-

---

Notice the STATUS | CANCELLED

[Former Member]

Hello Imran

start the deletion in the background mode,you will be able to delete that

login in which client do u want to delte.. enter scc5 in the t code field ..and choose the client.. start

deletion in the background process(there is an option there)

Rohit

[Former Member]

hi rohit

l also try to delete client through scc5 in the t code field ..and choose the client.. start

deletion in the background process(there is an option there).

after taking too much time, it not delete even 1 table outof 54652

regard

imran

[Former Member]

how many background processes did you choose

Also give it some time,dont jump the gun,guve it few hours and monitor the deltion through SCC3

Rohit

[Former Member]

Ok i left it alone for Few hours

In SAP MCC there r 3 BTC process.

[Former Member]

hi ...

it is looking stuck , after appox. 2 hour it not delete even single table deleteing CCSELTAB table for 2 hour,

"Client to be Deleted 300

Copy Type Delete Complete Client

Status Processing...

User SAP*

Start on 2009-03-26 / 11:26:00

Last Entry on 2009-03-26 / 11:26:58

Statistics for this Run

- No. of Tables 0 of 54652

- Deleted Lines 0 "

in SM50 it is showing below detail

"BGD 5104 Running Yes 6336 SAPLSCCM 300 SAP* Delete CCSELTAB"

plz tell me

still wait or do some thing

Regard

Imran

[Former Member]

Hello Imran,

just check whether your online redo log file directory has some space or not?

If it is free,I would assume you wait for some more hours

Rohit

[Former Member]

hi

there is lot of space on all drive of dev system,

i left it for some more hours

Regard

Imran

[Former Member]

hi

still its not showing any status i mean on same step in which 0 table is copied

now i thnik there is something problem in it

plz tell me whats wrong with that

Regard

Imran

[Former Member]

Imran let it run

Also what do you see in SM50,is something happening there,also check SM21 logs for any errors

but dont cancel the job

Rohit

[Former Member]

in SM50 it is showing below detail

"BGD 5104 Running Yes 6336 SAPLSCCM 300 SAP* Delete CCSELTAB"

in SM21

" 11:26:03 BTC 012 300 SAP* BX F Table logging in program RSCLXCOP disabled by user SAP*

11:26:03 BTC 012 300 SAP* B6 B Syn. MC maintenance deactivated fully from RSCLXCOP by user SAP*

11:26:03 BTC 012 300 SAP* BB 1 Buffer TABL reset

11:26:03 BTC 012 300 SAP* BB 1 Buffer TABLP reset

11:26:58 DIA 001 300 SAP* TZ 1 The System's Time Zone Cannot be Determined. Enter it Using STZAC.

11:29:19 DIA 002 000 SAPSYS AB 0 Run-time error "RAISE_EXCEPTION" occurred

11:29:21 DIA 002 000 SAPSYS AB 1 > Short dump "090326 112919 devsap_D EV_00 " generated

11:29:21 DIA 002 000 SAPSYS D0 1 Transaction Canceled 00 671 ( RAISE_EXCEPTION 20090326112919devsap_DEV_00 SAPSYS 000 )

11:34:18 DIA 001 000 SAPSYS AB 0 Run-time error "RAISE_EXCEPTION" occurred

11:34:18 DIA 001 000 SAPSYS AB 1 > Short dump "090326 113418 devsap_D EV_00 " generated

11:34:18 DIA 001 000 SAPSYS D0 1 Transaction Canceled 00 671 ( RAISE_EXCEPTION 20090326113418devsap_DEV_00 SAPSYS 000 )

12:30:27 DIA 000 300 SAP* AB 0 Run-time error "LIST_TOO_MANY_LPROS" occurred

12:30:28 DIA 000 300 SAP* AB 1 > Short dump "090326 123027 devsap_D EV_00 " generated

12:45:43 DIA 001 300 SAP* AB 0 Run-time error "LIST_TOO_MANY_LPROS" occurred

12:45:44 DIA 001 300 SAP* AB 1 > Short dump "090326 124543 devsap_D EV_00 " generated "

Runtime error is due to too many refesh i made

regard

imran

[Former Member]

Hello Imran,

I guess Time zone of the server is not maintained

"

11:26:58 DIA 001 300 SAP TZ 1 The System's Time Zone Cannot be Determined. Enter it Using STZAC."* as said in the logs

Just maintain the time zone of the server using STZAC transaction and then check,it might help

Rohit

[Former Member]

Ok

i have change time Zone in 100 client whcih is a golden client, but client deletion status is same

Regrad

Imran

[Former Member]

Hi Rohit ..

i waiting ur respose , tell me can i cancel client deletion again or left it alone . or there any other way to delete client

regard

Imran

[Former Member]

Dear Imran

you can check ur deletion client is working through se 16

put table name and click table contents

after that click on number of entries...

it should be less from ur last entries..

regards

Anil Kumar