Error in TR import during Client Export Import process

[farkathulla_cikkanther]

Hello Friends,

I am doing Client export and import. During the TR import in STMS_Import below error was occurred.

=============================================================================================================

3 ETW674Xstart import of "R3TRTABUBSIS" ...

3WETW019 No memory for space allocation left ("1140000000").

4 ETW000 twrtab reached memory limit; memory usage 1135000000

4 ETW000  [     dev trc,00000]  Mon May 30 03:13:53 2016

4 ETW000  [     dev trc,00000]  check2: OCIStmtExecute() failed with -1=OCI_ERROR

4 ETW000  [     dev trc,00000]          SQL error 30036:

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => Error 30036 in stmt_execute() from oci_execute_stmt(), orpc=0

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => ORA-30036 occurred at SQL stmt (parse error offset=12)

4 ETW000  [     dev trc,00000]  Dump statement cache (after SQL error):

4 ETW000  [     dev trc,00000]  sc_p=0000000002ACC3B8,no=123,idc_p=0000000000000000,con=0,act=1,slen=36,smax=512,#vars=1,stmt=000000000B6EC3E0,table=BSIS                      

4 ETW000  [     dev trc,00000]  DELETE FROM "BSIS" WHERE "MANDT"=:A0;

4 ETW000  [     dev trc,00000]     statement for table 'BSIS                          ':

4 ETW000  [     dev trc,00000]         DELETE FROM "BSIS" WHERE "MANDT"=:A0                                                                                  

4 ETW000  [     dev trc,00000]     stmt_execute() -> orc=30036 (orc1=30036), rc=99=DBSL_ERR_DB

4 ETW000  [     dev trc,00000]  Dump statement cache (rc=99=DBSL_ERR_DB):

4 ETW000  [     dev trc,00000]  sc_p=0000000002ACC3B8,no=123,idc_p=0000000000000000,con=0,act=1,slen=36,smax=512,#vars=1,stmt=000000000B6EC3E0,table=BSIS                      

4 ETW000  [     dev trc,00000]  Dumping stmt. cache (DBSL private attributes):

4 ETW000  [     dev trc,00000]  sch=02ACC3B8, scp=02ADA510, ups_sch=NULL, stp=0B0A93F8, r_c=0

4 ETW000  [     dev trc,00000]  prep=0, dbds=0, lit_cnt=0, lob_cnt=0, fae_cnt=0, xop=1, dbcount=0

4 ETW000  [     dev trc,00000]  IN : col_cnt=1, row_max=1, row_xcnt=1, row_pcnt=0, row_i=0, row_total=1,

4 ETW000  [     dev trc,00000]       row_upto=4294967295, row_size=6, vda_max=64, bound=1, itp=02B1FAB0, vda_arr=0B693710

4 ETW000  [     dev trc,00000]       lob_anz=0, lob_max=0, lob_pw=0,  lobarr=NULL, rows_ret=0

4 ETW000  [     dev trc,00000]  OUT: col_cnt=15, row_max=342, row_xcnt=0, row_pcnt=0, row_i=0, row_total=4680,

4 ETW000  [     dev trc,00000]       row_upto=0, row_size=350, vda_max=32, bound=0, itp=NULL, vda_arr=0B09D810

4 ETW000  [     dev trc,00000]       lob_anz=0, lob_max=0, lob_pw=0,  lobarr=NULL, rows_ret=0

4 ETW000  [     dev trc,00000]  DELETE FROM "BSIS" WHERE "MANDT"=:A0;

4 ETW000  [    dbtran  ,00000]  ***LOG BY4=>sql error 30036  performing DEL on table BSIS                      

4 ETW000  [    dbtran  ,00000]  ***LOG BY0=>ORA-30036: unable to extend segment by 8 in undo tablespace 'PSAPUNDO'

4 ETW000  [     dev trc,00000]  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL'

4 ETW000                         RSLT: {dbsl=99, tran=1}

4 ETW000                         FHDR: {tab='BSIS', fcode=194, mode=2, bpb=0, dbcnt=0, crsr=0,

4 ETW000                                hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,

4 ETW000                                init:p=0000000000000000, init:#=0, wa:p=0X000000000200B610, wa:#=10000}

4 ETW000  [     dev trc,00000]  dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL'

4 ETW000                         STMT: {stmt:#=0, bndfld:#=1, prop=0, distinct=0,

4 ETW000                                fld:#=0, alias:p=0000000000000000, fupd:#=0, tab:#=1, where:#=2,

4 ETW000                                groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0}

4 ETW000                         CRSR: {tab='', id=0, hold=0, prop=0, max.in@0=1, fae:blk=0,

4 ETW000                                con:id=0, con:vndr=5, val=2,

4 ETW000                                key:#=3, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=0X00000001410DDCD0}

2EETW125 SQL error "30036" during "30036" access: "ORA-30036: unable to extend segment by 8 in undo tablespace 'PSAPUNDO'"

4 ETW690 COMMIT "16768" "-1"

4 ETW000   0 entries from BSIS (410%) deleted.

3WETW000 Duplicate Key error during insert into table BSIS occured

2EETW125 SQL error "30036" during "30036" access: "ORA-30036: unable to extend segment by 8 in undo tablespace 'PSAPUNDO'"

4 ETW000   0 entries for BSIS imported.

==========================================================================================================

  Please find the log file for reference.

As of the above log i added a 10gb space to PSAPUNDO.

Where PSAPUNDO space only the issue or some other?

How to restart the TR import to continue the process?

Kindly help...

Regards,

Farkath C

PR11IT00065.QA1_log_file.txt.zip

[farkathulla_cikkanther]

Hello Friends,

  Any update on this issue,

Regards,

Farkath C

[former_member182967]

Hi Farkathulla,

Mostly, your undo tablespace is not enough, please try to extend to more space than you mentioned.

After client import, you can switch undo tablespace to reduce its size to the normal situation.

For how to continue client import after error fixing, refer to

As a suggestion, please delete the existing client before import, thus can reduce the size for undo tablespace usage.

Regards,

Ning

[Former Member]

Hi Farkath,

Try to reduce the time of UNDO_RETENTION to a lower value and keep Undo tablespace on auto_extend ON.

Regards

Prithviraj