SAP Knowledge Base Article - Preview

3790446 - Stack trace with error 622 or error 225 after VEH_Optimize - SAP ASE

Symptom

Many stack traces with error 622 or error 225 after "VEH_Optimize":

====

SIGSEGV is caught by VEH_Optimize()
Return VXACTION_CONTINUE from VEH_Optimize()
Error: 225, Severity: 16, State: 3
Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.
Address 0x0x0000000001518e6b (bufallunkeep+0x52b), siginfo (code, address) = (1, 0x0x0000000000000008)
Current process (0x30610284) infected with signal 11 (SIGSEGV)
...
...
kisignal
bufallunkeep
closetable
close_range
s_handle
exc__raise
exc_raise
s_recompile
...
...

*******
......
......
SIGSEGV is caught by VEH_Optimize()
Return VXACTION_CONTINUE from VEH_Optimize()
Error: 622, Severity: 20, State: 1
Opentable was passed a varno of 250. Object '' in database 'tempdbxx_IMDB' already has that session descriptor in use. This occurred while opening object id -yyyyyyyyy in database id xx.
....
.....
exc_raise
sdes_hookup
crt_work
run_crtable
stat_crt_worktable
stat_create_dummy_worktable
ups_init_statglobalnosort
update_statistics_col_hash
update_statistics_colset_driver
update_statistics
update_statistics_implicit
st_readstatistics
st_getstats
qry_init_stats
st_readallstats
....
...

====

They are using stats hashing. This parameter is enabled: update statistics hashing = on


Read more...

Environment

SAP Adaptive Server 16.0 SP04 PL03 HF1

Product

SAP Adaptive Server Enterprise 16.0.4

Keywords

Error 622, Error 225, 622, 225, VEH_Optimize, CR 832440, CR832440, CR#832440, 832440, bufallunkeep, closetable, close_range, update_statistics_col_hash, sdes_hookup, crt_work, run_crtable, stat_crt_worktable, stat_create_dummy_worktable, ups_init_statglobalnosort , KBA , 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.