SAP Knowledge Base Article - Preview

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


SAP Adaptive Server Enterprise 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 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.