3453333 - A select statement reports Error 1526 on cache when single page pool is low - SAP ASE

• A select statement may reports Error 1526 on tempdb cache when the single page size pool in the cache is low. It may also report the error on default data cache when the tempdb is not bound to any named cache.
• The query may use Union or IN list .
• Use sp_altermessage with stack option on Msg 1526, the following stack reports in errorlog when the query failed with Error 1526.

Error: 1526, Severity: 17, State: 5
Sort failure. The configure size for data cache (tempdb2_cache) is not sufficient to handle the sort buffers (128) requested. Please reconfigure the data cache or sort buffers and try the command again.
Printing stack trace for error 1526
pc: 0x000000000113cab7 pcstkwalk+0x28()
pc: 0x000000000113c74c ucstkgentrace+0x3b0()
pc: 0x000000000113920f ucbacktrace+0xba()
pc: 0x0000000001c8ddc0 ex_printmsg+0x230()
[Handler pc: 0x0x0000000000e74fe3 ex_stop_recursion installed by the following function:-]
pc: 0x0000000001c8d3bd ex__doprint+0x2fd()
pc: 0x0000000000b4d765 so_handle+0x6e()
pc: 0x0000000001bcedc8 le_execerr+0x6f8()
pc: 0x0000000001c929bd exc__raise+0x2dd()
pc: 0x0000000001c9263b exc_raise+0x11b()
pc: 0x000000000135ce51 LeHashContext::claimMoreBufs()+0x421()
pc: 0x0000000001f1c01a LeHashContext::ReserveBuffer(LeHashBuffer*, unsigned int)+0x10a()
pc: 0x000000000135b4bf LeHashPartition::AddBuffer(LeHashContext*, unsigned int)+0x83()
pc: 0x0000000001f1df65 LeHashTable::Build(LeAlignedDataRow*, unsigned char**)+0x345()
pc: 0x0000000001f1c9fd LeHashContext::ProcessTuple(LeAlignedDataRow*)+0xed()
pc: 0x0000000001f1c237 LeHashContext::GetNext(ExeCtxt&)+0x187()
pc: 0x0000000001f1aab4 LeHashOp::_LeOpNext(ExeCtxt&)+0x34()
pc: 0x00000000013dfe1e LeEmitSndOp::_LeOpNext(ExeCtxt&)+0x1ee()
pc: 0x00000000013d8a1e LePlanNext+0xfe()
[Handler pc: 0x0x0000000001bce6d0 le_execerr installed by the following function:-]
pc: 0x00000000015f6800 exec_lava+0x380()
pc: 0x0000000001606336 s_execute+0x1126()
[Handler pc: 0x0x0000000001c93070 hdl_stack installed by the following function:-]
[Handler pc: 0x0x0000000001c62460 s_handle installed by the following function:-]
pc: 0x00000000016292d1 sequencer+0xbb1()
pc: 0x00000000016876d4 tdsrecv_language+0x254()
[Handler pc: 0x0x0000000001e55140 ut_handle installed by the following function:-]
pc: 0x00000000013d0b46 conn_hdlr+0xc76()
end of stack trace, spid 393, kpid 15401078, suid 7

Error: 1526, Severity: 17, State: 7
Sort failure. The configure size for data cache (tempdb2_cache) is not sufficient to handle the sort buffers (128) requested. Please reconfigure the data cache or sort buffers and try the command again.
Printing stack trace for error 1526
pc: 0x000000000113cab7 pcstkwalk+0x28()
pc: 0x000000000113c74c ucstkgentrace+0x3b0()
pc: 0x000000000113920f ucbacktrace+0xba()
pc: 0x0000000001c8ddc0 ex_printmsg+0x230()
[Handler pc: 0x0x0000000000e74fe3 ex_stop_recursion installed by the following function:-]
pc: 0x0000000001c8d3bd ex__doprint+0x2fd()
pc: 0x0000000000b4d765 so_handle+0x6e()
pc: 0x0000000001bcedc8 le_execerr+0x6f8()
pc: 0x0000000001c929bd exc__raise+0x2dd()
pc: 0x0000000001c9263b exc_raise+0x11b()
pc: 0x00000000013d8756 LePlanOpen+0x766()
[Handler pc: 0x0x0000000001bce6d0 le_execerr installed by the following function:-]
pc: 0x00000000015f67ed exec_lava+0x36d()
pc: 0x0000000001606336 s_execute+0x1126()
[Handler pc: 0x0x0000000001c93070 hdl_stack installed by the following function:-]
[Handler pc: 0x0x0000000001c62460 s_handle installed by the following function:-]
pc: 0x00000000016292d1 sequencer+0xbb1()
pc: 0x00000000016876d4 tdsrecv_language+0x254()
[Handler pc: 0x0x0000000001e55140 ut_handle installed by the following function:-]
pc: 0x00000000013d0b46 conn_hdlr+0xc76()
end of stack trace, spid 399, kpid 16187516, suid 7

SAP Adaptive Server Enterprise (ASE)

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem