Client import error

[former_member227600]

Hi Friends,

I am performing Client refresh using export import method. I export my client successfully But when i am improting this request it terminate with error code 16 & give error in log

ORA-01562 : failed to extend rollback segment

after thst i applied Snote 648701

And when i am trying to restart the import process i get a message

import for request PRDKX00033 is already running

Now how can i restart the import of this terminated request.

Thanks & regards

Karan

[Former Member]

Hi,

first check import monitor is request is still importing or it's ended with error?

if it's ended with error and import queue is showing the truck icon then proceed as follows

regards,

kaushal

[former_member227600]

Hi Kaushal,

I open TMSTLOCKR using se16 & switch on debug using /h

but the the delete option is not working. And when i consult with my abaper,he is saying you need access key to delete this entry. I am performing client import in QUALITY server.

Now please tell me how can i delete tthis entry from this table

Thanks & regards

Karan

[Former Member]

Hi,

delete the entry at OS level from database table TMSTLOCKR.

after delete press refresh in STMS.

regards,

kaushal

[former_member227600]

Hi ,

Thanks for reply.

Can you tell me how can i delete this entry at OS level .

Can i delete entry using this command.

Delete <req. no.> from tablename;

Thanks & Regards

karan

[Former Member]

HI,

use following

1. login as ora<SID>

2. sqlplus /@<SID>

3. delete from tmstlockr where TRKORR = 'request'

regards,

kaushal

[former_member227600]

Hi Kaushal,

When i am trying the command than i get this error

SQL> delete from tmstlockr where TRKORR='PRDKX00033';

delete from tmstlockr where TRKORR='PRDKX00033'

*

ERROR at line 1:

ORA-00942: table or view does not exist

Thanks & Regards

Karan

[Former Member]

Hi,

problem with query only try following

delete TMSTLOCKR where TRKORR = 'PRDKX00033'

if you still getting problem then ask your ABAPER to write one single query report which delete the entry from

TMSTLOCKR and transport this program in QAS and execute it.

regards,

kaushal

[former_member227600]

Hi ,

I get the same error message.

SQL> delete TMSTLOCKR where TRKORR = 'PRDKX00033';

delete TMSTLOCKR where TRKORR = 'PRDKX00033'

*

ERROR at line 1:

ORA-00942: table or view does not exist

We have no another way to restart the import process.

Thanks & Regards

Karan

[Former Member]

Hi,

ask your ABAPER to write one single query report which delete the entry from

TMSTLOCKR and transport this program in QAS and execute it.

regards,

kaushal

[former_member227600]

Hi kaushal,

Problem has been solved but when i reimport the request than i get the same error

ORA-01562: failed to extend rollback segment

And the process terminated with return code 16.

I am trying to import this client in to a existing client which is a clone of PRD system. I built my QAS system using System copy from PRD system. & QAS have only one client & i am trying to import request in this client .

Now please suggest me some solution of this error

Thanks & Regards

Karan

[Former Member]

Hi,

you get following error

ORA-01562: failed to extend rollback segment

which is not an independent error, provide the detail log.

make sure that tablespace is not full in your QAS system.

also check Note 16277 - ORA1562 / ORA1628

regards,

kaushal

[former_member227600]

Hi kaushal,

I checked tablespace in QAS system .Tablespace PSAPTEMP shows 0 size & when i am trying to increass the size of PSAPTEMP than i get error permision denied ,i checked permision of brspace it have 777 permision. would

i drop this tablespace & again create the new table space or any other solution to increass the size of this tablespace.

Thanks & Regards

Karan

[Former Member]

Hi,

check following notes

Note 659946 - FAQ: Temporary tablespaces

Note:113747 - Permissions for DBA tools BR*Tools and SAPDBA

Note 651351 - BR tools on UNIX: Error due to executable permissions

regards,

kaushal

[former_member227600]

Hi Kaushal,

I increass the size of my PSAPTEMP using command

SQL> alter tablespace PSAPTEMP add tempfile '/oracle/PRD/sapdata3/temp_1/temp.da

ta2' size 10000M;

Tablespace altered.

And it successfuly altered but still it shows 0 size in DB02 & i have also restart the the database.

Regards

karan

[Former Member]

Hi,

I'm not sure why it's showing 0 size for PSAPTEMP

try to apply Note 1158313 - data or temp files return no data in old dob02

regards,

kaushal