Symptom
- A varchar(60) column was altered to be varchar(100).
- A trigger references this table and altered column and was not recreated or have dbcc upgrade_object run against it.
- Subsequent executions of the trigger resulted in a SEGV at sqlexc_prepare_current_block along with a stacktrace similar to this:
sqlexc_prepare_current_block
s_compile
sequencer
exectrig
s_execute - Recreating the trigger resolves the problem.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
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