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
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.
SAP Knowledge Base Article - Preview