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 , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

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.