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

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

Symptom

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().

 


Read more...

Environment

SAP Adaptve Server Enterprise (ASE) 15.7 

 

Product

SAP Adaptive Server Enterprise 15.7

Keywords

sp_options, sysoptions, invalid column length, stacktrace, collocate, Msg: 515 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.