SAP Knowledge Base Article - Preview

2921852 - SQL replication may not work correctly for ANSI joins queries or sginal 11 raised from function LeSQLRep::_sqlRepParamSet - SAP ASE

Symptom

D/I/U with Ansi jins may be incorrectly replicated with SQL replication.
The problem is that for Ansi joins the marker for 'FROM' clause is incorrectly constructed.

Or Signal 11 raised from LeSQLRep::_sqlRepParamSet

Only can see cpu register table information in ASE errorlog file with routine LeSQLRep::_sqlRepParamSet as the following.

Current process (0x210011) infected with signal 11 (SIGSEGV)
Current Process is running on Engine 2
server is using elf symbols for stack decoding (125500 symbols found)
Address 0x0x0000000000953c5e (LeSQLRep::_sqlRepParamSet(ExeCtxt&, e_param*, SQLBuf*)+0x404), siginfo (code, address) = (128, 0x(nil))
**** Saved signal context (0x0x000000014dc3d500): ****
uc_flags: 0x1, uc_link: 0x(nil)
uc_sigmask: 0x7bfbf037 0xb 0x80 0x0
uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
General Registers (uc_mcontext.gregs):
PC : 0x0000000000953c5e (LeSQLRep::_sqlRepParamSet(ExeCtxt&, e_param*, SQLBuf*)+0x404)
RAX : (nil) RBX : 0x5f4e45475f4d2e34
RCX : 0x0000000003903044 RDX : 0x000000025239e2f0
RBP : 0x2e325420524f2020 RSP : 0x000000014dc3da88
R8 : (nil) R9 : 0x0000000000001f85
R10 : 0x0000000146d15000 R11 : 0x00007f030b52a750
R12 : 0x57202029204d554e R13 : 0x5420282045524548
R14 : 0x434e45475f4d2e32 R15 : 0x35203d2050545255
RDI : 0x000000025239cbe0 RSI : 0x000000024d4bb800
RIP : 0x0000000000953c5e CSGSFS : 0x0000000000000033
TRAPNO : 0x000000000000000d ERR : (nil)
EFL : 0x0000000000010202
**** end of signal context ****
************************************


Read more...

Environment

    SAP Adaptive Server Enterprise (ASE)

    Product

    SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

    Keywords

    CR821558, CR#821558, 821558, SQLDML Replication , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

    About this page

    This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.