SAP Knowledge Base Article - Preview

2138327 - Column corruption. Error 2780 with stacktrace when querying table - SAP ASE

Symptom

  • On SAP ASE systems running non-SAP and custom applications, ASE error log reports the following error:

server Error: 2780, Severity: 20, State: 1
server maxlen (64) is less than length (255)

  • The following stacktrace is generated:

server SQL Text: select external_doc_id from case_document where @@@V0_INT=@@@V1_INT
kernel curdb = 6 tempdb = 8 pstat = 0x10000 p2stat = 0x40101000
kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x1 p7stat = 0x10000
kernel lasterror = 2780 preverror = 0 transtate = 1
kernel curcmd = 224 program = isql
kernel extended error information: hostname: xxxxx login: xxxxx
kernel pc: 0x00000000812e9198 pcstkwalk+0x18
kernel pc: 0x00000000812e8fe0 ucstkgentrace+0x23c
kernel pc: 0x00000000812e53dc ucbacktrace+0xd0
kernel pc: 0x000000008079f524 terminate_process+0x1138
kernel pc: 0x0000000080fe4be0 hdl_default+0x50
kernel pc: 0x0000000080fe40b4 ex_raise+0x640
kernel pc: 0x00000000805f1b84 _$o1ceyjN0.mk_constant+0x20
kernel pc: 0x00000000819ac9f4 boolAnyDataType::_computeBoolResult(int,AnyDataType&)+0xf8
kernel pc: 0x000000008064f2fc int StMergeHistCatalog::StmhIncrement(OptPool*,int,int,int)+0x17c
kernel pc: 0x0000000080652f54_$o1cezpU0.__1cIStTcInfoLStTcMrgBnds6MpnIOptBlock__v_+0x94
kernel pc: 0x000000008054eac4 void StgStatPkg::StgStatPkgSecondaryInit(OptBlock*)+0x2d0
kernel pc: 0x0000000080852b10 void OptGlobal::_GblSearchEngine(int*)+0x33
kernel pc: 0x0000000080850f98 PopBase*OptGlobal::GblOptimize(int*)+0x13c
kernel pc: 0x00000000806ad8b0 _$o1cfaeQ0.Optimize+0x5c
kernel pc: 0x0000000080549058 s_compile_stmt+0xa38
kernel pc: 0x000000008054840c _$o1ceybD0.s_compile+0x18c
kernel pc: 0x00000000805a0bdc _$o1ceyfL0.sequencer+0x19c
kernel pc: 0x0000000080524b94 execproc+0x414
kernel pc: 0x00000000804599bc _$o1cexiU0.s_execute+0x3fc
kernel pc: 0x0000000080520a54 sequencer+0x354
kernel pc: 0x00000000807e4808 tdsrecv_language+0x2ac
kernel pc:0x000000008059c330 _$o1ceyfI0.conn_hdlr+0x190
kernel pc: 0x0000000081316eb0 _coldstart
kernel end of stack trace,
spid 176, kpid 188809339, suid 54


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , ase is terminating this process , dynamic sql , prepared statements , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.