When a query of the form:
select * from master.dbo.sysoptions
Or the procedure:
sp_options 'show' is run, Adaptive Server Enterprise (ASE) may fail with errors:
- Msg 515, Level 16, State 3: "Attempt to insert NULL value into column '%.*s', table '%.*s'; column does not allow nulls. Update fails.%S_EED", NULL},
- Msg 19613, Level 16, State 1: "The session id %d does not exist."
and errorlog reports:
- Msg 290024 : "Invalid Column Length. 106. Value must be between 0 and 100 at offset 10 for 'all-pages' row with minimum row length of 8."
- followed by a stacktrace in functions collocate() and LeSubst().
SAP Adaptve Server Enterprise (ASE) 15.7
sp_options, sysoptions, invalid column length, stacktrace, collocate, Msg: 515, CR#793594, 793594, CR793594 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.