Duplicate key error while client import

[Former Member]

hi,

system

OS UX 11.B

SAP R/3 4.7

ORACLE 9.2.0

While doing client import on QAS i got the error as

SQL error 30036 accessing ACCTIT: ORA-30036: unable to extend segment by 8 in undo t

Duplicate Key error during insert into table ACCTIT occured

Please help.

Thanks and Regards,

Sam

[Former Member · Accepted solution]

Add space to Undo tablespace and redo the Client import

Even better if you can do a client delete and then do the import all over

Pravin

[Former Member · Accepted solution]

thx Pravin ...

how much space should i added to undo table?

means any calculation..

other point is

in tp system log it shows stop single import

in import history it shows import in error

in trjob ,trbat have some entries

in /usr/sap/tmp no entries of request

in stms it shows truck

can pls any 1 tell if its really aborted or not..

deleting client is 1 solution.is any other way to solve it?

Thanks n regards,

Sam

[Former Member · Accepted solution]

Is a TP process running at OS level ??

Is there a .loc file in /usr/sap/trans/tmp directory ??

ACCTITI is big table.

You can always reclaim Undo space so add as much space as you can.

If you have undo to be 10G double it. make it at least 20G to start with.

Clean up the following tables

Transport Cleanup Tables

TRBAT, TRJOB TPSTAT, TMSTLOCKR, TMSTLOCKP

If they have reference to the client import then delete that entry ONLY

Restart the client import

pravin

[Former Member · Accepted solution]

Thx Pravin..

Its solved..its having issue with buffer.

We renamed old buffer,added 10 more GB to Temp table nad reduced the undo_retention parameter.

Regards,

Sam

[Former Member · Accepted solution]

Hi Sam,

I too face the same problem in client export/import.Please help me on this to solve the issue.

I have mentioned below my table space sizes and undo retension details.

Please advice me the changes that i should do from the below and also about buffer.

PSAPTEMP 2416640 KB

PSAPUNDO 13385728 KB

SQL> show parameter undo

NAME TYPE VALUE

inmemory_undo boolean FALSE

undo_management string AUTO

undo_retention integer 43200

undo_tablespace string PSAPUNDO

Thanks,

Hari

[Former Member · Accepted solution]

Hi,

What is your exact error ?

Mark

[Former Member · Accepted solution]

Hi Hari,

Reduce undo_retention parameter to 2000.Keep the PSAPUNDO space equal to 4 times the biggest table.

Regards,

Sam