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.
SAP Knowledge Base Article - Preview