1891069 - Queries against master.dbo.sysoptions including execution of sp_options stored procedure may fail with errors and stacktraces - SAP ASE

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