SAP Knowledge Base Article - Preview

3577799 - Sybase DB upgrade failed with error Number 17954, Severity 16, State 1 - SAP ASE for BS

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.