SAP Knowledge Base Article - Preview

2559986 - Cannot enable the "enforce dump tran sequence" option with Error 17957 - SAP ASE for BS

Symptom

The below error message has appeared when you change the "enforce dump tran sequence" option to true.

1> use master
2> go
1> sp_dboption "<SID>","enforce dump tran sequence", true
2> go
Msg 17957, Level 16, State 1:
Server '<SID>', Procedure 'sp_dboption', Line 1092:
You cannot set the 'enforce dump tran sequence' database option because the database '<SID>' is either marked as needing a database dump, an unlogged operation was performed or the transaction log was truncated. Dump the database, then retry setting the option.
(return status = 1)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.