Symptom
>>Getting error while ASE version upgrade:
# ./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
----- 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 ASE 16.0
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.