SAP Knowledge Base Article - Preview

3577799 - ASE server upgrade failed with error 17954 - SAP ASE for BS

Symptom

  • Upgrading an ASE server to a higher version
  • Using saphostctrl fails with error 17954:

    # ./saphostctrl -user sapadm <passwd> -function LiveDatabaseUpdate -dbname <SID> -dbtype syb -updatemethod Execute -updateoption TASK=UPDATE_ASE -updateoption DROP_LOCATION="/usr/sap/<SID>/COMM"

    Error: Command execution failed. : Server message: Number 17954, Severity 16, State 1, Line 1061, Server <SID>, Procedure sp_dboption --- Message string: You cannot set the 'select into' database option to true when the 'enforce dump tran sequence' database option is on for database 'sybsecurity'.. (fault code: 127)
    Operation ID: 7F7A78BAAFB71EEFBDB617F6CDE3EC46
  • Similar message is printed in log trace output:

    ----- Log messages ----
    Info: saphostcontrol: Executing LiveDatabaseUpdate
    Error: sapdbctrl: Server message: Number 17954, Severity 16, State 1, Line 1061, Server <SID>, Procedure sp_dboption --- Message string: You cannot set the 'select into' database option to true when the 'enforce dump tran sequence' database option is on for database 'sybsecurity'..
    Error: saphostcontrol: LiveDatabaseUpdate failed (sapdbctrl exit code = 1)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 & 16.1 for Business Suite
  • SAP Hostagent

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0.3 ; SAP Adaptive Server Enterprise 16.0.4 ; SAP Adaptive Server Enterprise 16.1

Keywords

Error: Command execution failed, Server message: Number 17954, Severity 16, State 1, Line 1061 , Procedure sp_dboption , fault code: 127 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.