SAP Knowledge Base Article - Preview

2123826 - Errors 3935, 9591, and 515 are returned when running an INSERT command that references reserve_identity() function. - ASE

Symptom

INSERT-VALUES query that calls the built-in function "reserve_identity()" as an expression in the VALUES list will return errors:

  • Msg 3935, Level 20, State 1:
    Server '<server>', Line 1:
    Fatal protocol error. xact_beginupdate() API was invoked in the wrong context.
    The transaction is currently in 'Command-attached' state.

  • Msg 9591, Level 18, State 1:
    Server '<server>', Line 1:
    The specified identity reservation size for table '<table>' exceeds the maximum reservation size. Please use sp_configure to increase the 'identity reservation size'.

  • Msg 515, Level 16, State 3:
    Server '<server>', Line 1:
    Attempt to insert NULL value into column '<column>', table '<table>'; column does not allow nulls. Update fails.
    Command has been aborted.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP131

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.