cancel
Showing results for 
Search instead for 
Did you mean: 

SUM Error (HANA 1503) Execution Step

former_member217141
Active Participant
0 Kudos

Dear Gurus,

We are taking error at SUM execution step "MAIN_TRANSEXEC/TABIM_TRANS".

Hana 1503 ERP is upgrading for Insurance addons.

---------

HANA DB (SUSE)

128 GB Virtual

6 x core

128 gb RAM

-----------

SAP APP Server

4 x core

16 Gb Ram

------------

SUM Version : SUM10SP14_8-20006676

Kernel Version : Tried both 7-42(sp:300) and 7-45(sp:23) Kernels with same error.

SOFTWARE UPDATE MANAGER

---------------------------------------------------------------------------------------------------------

Checks after phase MAIN_TRANSEXEC/TABIM_TRANS were negative!

Last error code set: Detected 1 aborted activities in 'TABIMTRNS.ELG'

Calling 'D:\usr\sap\VEM\DVEBMGS00\exe/tp' failed with return code 12, check D:\SUM\SUM\abap\log\SAPup.ECO for details

ERROR: Detected the following errors:

# D:\SUM\SUM\abap\log\SAPI-700COINMSG.VEM: 4 ETW000 [ dev trc,00000] sc_p=00000047D534E888,no=85,idc_p=00000047D53B2930,con=0,act=1,slen=60,smax=256,#vars=8,stmt=00000047DA25C800,table=DOKTL 4 ETW000 [ dev trc,00000] stmtid = <3/DOKTL /268435456/20140925204956> 4 ETW000 [ dev trc,00000] INSERT INTO "DOKTL" VALUES( ? , ? , ? , ? , ? , ? , ? , ? ) ; 4 ETW000 [ dbtrtab ,00000] ***LOG BY4=>sql error 129 performing SEL on table DOKTL 4 ETW000 [ dbtrtab ,00000] ***LOG BY0=>transaction rolled back by an internal error: AttributeEngine: not enough memory 2EETW000 sap_dext called with msgnr "1": 2EETW000 ---- db call info ---- 2EETW000 function: db_docu 2EETW000 fcode: CI_CLOSE_SEQ_ACCESS 2EETW000 len (char): 68 2EETW000 key: FU/MSG/BAPI_VTG_CREATE_COMMENT DT0002 2EETW000 retcode: 1 2EETW000 sql error: 129 transaction rolled back by an internal error: AttributeEngine: not enough memory 2EETW125 SQL error "129" during "" access: "transaction rolled back by an internal error: AttributeEngine: not enough memory"

A trouble ticket and an archive with all relevant log files have been generated. Trouble ticket: "D:\SUM\SUM\abap\log\SAPup_troubleticket.log" Log archive: "D:\SUM\SUM\abap\log\SAPup_troubleticket_logs.sar"

---------------------------------------------------------------------------------------------------------------------------

TABIMTRNS.html

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MAIN IMPORT ERRORS and RETURN CODE in SAPI-700COINMSG.VEM

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETW000 [ dev trc,00000] sc_p=000000CF05F1BE60,no=14,idc_p=000000CF05F813D0,con=0,act=1,slen=69,smax=256,#vars=1,stmt=000000CF0A5CF470,table=E071

4 ETW000 [ dev trc,00000] stmtid = <3/E071 /1619001408/20160112192251>

4 ETW000 [ dev trc,00000] SELECT * FROM "E071" WHERE "TRKORR" = ? ORDER BY "TRKORR" , "AS4POS" ;

4 ETW000 [ dbtrtab ,00000] ***LOG BY4=>sql error 2048 performing SEL on table E071

4 ETW000 [ dbtrtab ,00000] ***LOG BY0=>column store error: search table error: [6952] AttributeEngine: not enough memory

2EETW000 sap_dext called with msgnr "1":

2EETW000 ---- db call info ----

2EETW000 function: db_setget

2EETW000 fcode: RT_SETB (65535)

2EETW000 tabname: E071

2EETW000 len (char): 20

2EETW000 key: SAPK-700COINMSG

2EETW000 retcode: 1

2EETW000 sql error: 2048 column store error: search table error: [6952] AttributeEngine: not enough memory

2EETW125 SQL error "2048" during "" access: "column store error: search table error: [6952] AttributeEngine: not enough memory"

1 ETP111 exit code : "12"

-----------------------------------------------------------------------------------------------------------------------

SAPUP

2EETW000 sql error:  129 transaction rolled back by an internal error: AttributeEngine: not enough memory

2EETW125 SQL error "129" during "" access: "transaction rolled back by an internal error: AttributeEngine: not enough memory"

D:\usr\sap\VEM\DVEBMGS00\exe\R3trans.exe finished (0012).

--------------------------------------------------------------------------------------------------------------------

PHASES

2 ETQ399 Distribute 12 parallel processes to 2 tp and 6 R3trans.

3 ETQ120 20160112225745: PID 7708 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\DEFAULT.TPP" setstopmark "buffer=VEM" before SAPK-700COINMSG', output written to 'D:\SUM\SUM\abap\log\TP.ECO'.

3 ETQ123 20160112225745: PID 7708 exited with status 0 (time 0.000 real)

4 ETQ399 'tp' ignored "before SAPK-700COINMSG" phrase - moving STOPMARK manually there in buffer 'VEM'.

3 ETQ121 20160112225745: PID 4228 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\TABIMTRNS.TPP" put VEM "-Dmainimp_proc=2" "-Dparallel=6"' in background, output written to 'D:\SUM\SUM\abap\log\SAPup.ECO'.

3 ETQ123 20160112225825: PID 4228 exited with status 0 (time 0.000 real)

2 ETQ399 tp finished successfully.

4 ETQ399 Group 4: Calling 'tp put' for transports from 'SAPK-700COINMSG' to 'SAPK-700COINMSG'.

4 ETQ399 Distributing 12 parallel processes for import.

2 ETQ399 Distribute 12 parallel processes to 1 tp and 12 R3trans.

3 ETQ120 20160112225825: PID 7284 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\DEFAULT.TPP" setstopmark "buffer=VEM" before SAPK-603DFININSURANC', output written to 'D:\SUM\SUM\abap\log\TP.ECO'.

3 ETQ123 20160112225825: PID 7284 exited with status 0 (time 0.000 real)

4 ETQ399 'tp' ignored "before SAPK-603DFININSURANC" phrase - moving STOPMARK manually there in buffer 'VEM'.

3 ETQ121 20160112225825: PID 9836 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\TABIMTRNS.TPP" put VEM "-Dmainimp_proc=1" "-Dparallel=12"' in background, output written to 'D:\SUM\SUM\abap\log\SAPup.ECO'.

3WETQ123 20160112230420: PID 9836 exited with status 4 (time 0.000 real)

2 ETQ399 tp finished successfully.

4 ETQ399 Group 5: Calling 'tp put' for transports from 'SAPK-603DFININSURANC' to 'SAPK-60027INLSOFE'.

4 ETQ399 Distributing 12 parallel processes for import.

2 ETQ399 Distribute 12 parallel processes to 2 tp and 6 R3trans.

3 ETQ120 20160112230420: PID 9336 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\DEFAULT.TPP" setstopmark "buffer=VEM" before SAPK-100AGINUIEAAP01', output written to 'D:\SUM\SUM\abap\log\TP.ECO'.

3 ETQ123 20160112230420: PID 9336 exited with status 0 (time 0.000 real)

4 ETQ399 'tp' ignored "before SAPK-100AGINUIEAAP01" phrase - moving STOPMARK manually there in buffer 'VEM'.

3 ETQ121 20160112230420: PID 6180 execute 'D:\usr\sap\VEM\DVEBMGS00\exe\tp "pf=D:\SUM\SUM\abap\var\TABIMTRNS.TPP" put VEM "-Dmainimp_proc=2" "-Dparallel=6"' in background, output written to 'D:\SUM\SUM\abap\log\SAPup.ECO'.

1 ETQ124 Scanned file 'log\SAPI-700COINMSG.VEM' from offset 507057666 to 520025422 for errors.

1 ETQ124 Scanned file 'log\SAPI-603DZININSURANC.VEM' from offset 114 to 1350535 for errors.

What could be wrong ?

Best Regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Sriram2009
Active Contributor
0 Kudos

Hi Kemal.

Could you check this SAP Note and SCN thread for the error message "  2EETW000 sql error: 129 transaction rolled back by an internal error"

1983322 - Error “129 transaction rolled back by an internal error" when updating an item


Regards

SS

Former Member
0 Kudos

Hi

Please go through below sap notes

2057046 - FAQ: SAP HANA Delta Merges

1999997 - FAQ: SAP HANA Memory 

Regards,

Prithviraj