cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ASE SQL Error 5702 during HR import

aloezcan
Explorer
0 Kudos

Hi all,

during import of package SAPKE604D8 the follow error occurs. SAP ASE DB Version is 15.7 PL 135 and SAP Basis Release is 740 PL19

Signal 11 was written in ASE <SID>.log and the following output comes in import file

4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 27519] 4 ETW000 [ dev trc,00000] (5702) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this proces 4 ETW000 [ dev trc,00000] s. 4 ETW000 [ dev trc,00000] sql statement is ==> SELECT * FROM "T512G" WHERE "SPRSL" IN ( ? , ? ) AND "MANDT" = ? AND "MOLGA" = ? 4 ETW000 [ dev trc,00000] AND "FORML" = ? FOR UPDATE 4 ETW000 /* R3::0 T:T512G */ 4 ETW000 /*9*/ 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 47231] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dbtran ,00000] ***LOG BY4=>sql error 5702 performing SEL on table T512G 4 ETW000 [ dbtran ,00000] ***LOG BY0=>[ASE Error SQL5702][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process. 4 ETW000 [ dev trc,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' 4 ETW000 RSLT: {dbsl=99, tran=1} 4 ETW000 FHDR: {tab='T512G', fcode=69, mode=2, bpb=0, dbcnt=0, crsr=1, 4 ETW000 hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0, 4 ETW000 init:p=(nil), init:#=0, wa:p=347cda0, wa:#=542} 2EETW125 SQL error "5702" during "T512G" access: "[ASE Error SQL5702][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process." 4 ETW690 COMMIT "7094" "832764" 4 ETW000 [ dev trc,00000] ERROR: -1 in function PrepOperation (SQLAllocStmt) [line 29339] 4 ETW000 [ dev trc,00000] (30102) [HY010] [SAP][ASE ODBC Driver]Function sequence error 4 ETW000 [ dev trc,00000] sql statement is ==> INSERT INTO DDLOG ( TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( ? , ? , ? 4 ETW000 [ dev trc,00000] , ? ) 4 ETW000 /* R3:/bas/753_REL/src/krn/dbi/dbs/dbsynseq:566 T:DDLOG */ 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 47225] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dbsynseq,00000] ***LOG BY4=>sql error 30102 performing INS on table DDLOG 4 ETW000 [ dbsynseq,00000] ***LOG BY0=>[ASE Error SQL30102:HY010][SAP][ASE ODBC Driver]Function sequence error 4 ETW000 [ dbsync ,00000] ***LOG BZY=>unexpected return code 2 calling ins_ddlog 4 ETW000 [ dev trc,00000] db_syflush (TRUE) failed 4 ETW000 [ dev trc,00000] db_con_commit received error 1024 in before-commit action (con_hdl = 0, th_commit = 1, returning 8 4 ETW000 [dbeh.c ,00000] *** ERROR => missing return code handler 4 ETW000 caller does not handle code 1024 from dblink#1[356] 4 ETW000 ==> calling sap_dext to abort transaction 2EETW000 sap_dext called with msgnr "900": 2EETW125 SQL error "30102" during "" access: "[ASE Error SQL30102:HY010][SAP][ASE ODBC Driver]Function sequence error" 4 ETW000 [ dev trc,00000] ERROR: -1 in function DbSlRollback (ROLLBACK) [line 7868] 4 ETW000 [ dev trc,00000] (30273) [08003] [SAP][ASE ODBC Driver]Attempting to use a dead connection in Rollback. 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 47225] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dev trc,00000] Rollback Work (99) 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: COMMIT/ROLLBACK failed without RECONNECT error code 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: marking CONNECTION as closed 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: DB-ROLLBACK detected RECONNECT state 4 ETW690 ROLLBACK "7094" "832764" 1 ETP154 MAIN IMPORT 1 ETP110 end date and time : "20190704125806" 1 ETP111 exit code : "12" 1 ETP199 ######################################

And the stack trace is:

Kein Titel

00:0002:00000:00179:2019/07/04 11:20:04.24 kernel Current process (0x3790002) infected with signal 11 (SIGSEGV)

00:0002:00000:00179:2019/07/04 11:20:04.24 kernel Address 0x0x000000000089b240 (OptGlobal::OptGlobal(Node<Lop>*, tree*, OptPool*)+0x7882), siginfo (code, address) = (128, 0x(nil))

00:0002:00000:00179:2019/07/04 11:20:04.24 kernel **** Saved signal context (0x0x000000014c8b0400): ****

00:0002:00000:00179:2019/07/04 11:20:04.24 kernel uc_flags: 0x0, uc_link: 0x(nil)

00:0002:00000:00179:2019/07/04 11:20:04.24 kernel uc_sigmask: 0x416000 0xb 0x80 0x0

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel General Registers (uc_mcontext.gregs):

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel PC : 0x000000000089b240 (OptGlobal::OptGlobal(Node<Lop>*, tree*, OptPool*)+0x7882)

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RAX : 0x0000000001d00000 RBX : 0x00000001e2f27a88

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RCX : 0x0000000000000001 RDX : 0x00000001e2ed77d0

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RBP : 0x000000014c8b0860 RSP : 0x000000014c8b0850

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R8 : 0xfffffffffffffff8 R9 : 0x0000000143aba618

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R10 : 0xfffffffffffffff8 R11 : 0x00000001e2ed8050

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R12 : 0x00000001e2ed4850 R13 : 0x00000001e2ed4850

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R14 : 0x00000001e2f4e9e0 R15 : 0x00000001e2ec91d8

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RDI : 0x00000001e2f27a88 RSI : 0x00000001e2ed4850

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RIP : 0x000000000089b240 CSGSFS : 0xffff000000000033

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel TRAPNO : 0x000000000000000d ERR : (nil)

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel EFL : 0x0000000000010206

00:0002:00000:00179:2019/07/04 11:20:04.25 kernel **** end of signal context ****

Thanks a lot.

Kind Regards

Ali Özcan

Accepted Solutions (0)

Answers (1)

Answers (1)

jong-un_seo
Participant
0 Kudos

Hi Ali,

Please check 'optimizer level' configuration parameter.

If it set as ase_default, please change it to ase_current.

sp_configure 'optimizer level', 0, 'ase_current'
go

Best regards,
Jongun