SAP Knowledge Base Article - Preview

3260360 - upgrading ASE fails with error 'You can't run SELECT INTO in this database' and 'Failed to disable auditing before upgrade. ' - SAP ASE for Business Suite

Symptom

  • Upgrading ASE failed from ASE16 SP03 to ASE SP04
  • See the following error in the file 'dev_sapdbctrl' :

    DESCRIPTION: Server message: Number 268, Severity 16, State 1, Line 188, Server S01, Procedure sp_configure --- Message string: You can't run SELECT INTO in this database. 
    Please check with the Database Owner.LAST OS-ERROR: (0) : Success
    ERROR AT sybServer.cpp:luAppendResult:39724 TIME: 2022 Oct 15 11:30:36 DESCRIPTION: Failed to disable auditing before upgrade LAST OS-ERROR: (0) : Success
    *** ERROR => 'Database live update' failed: Failed to disable auditing before upgrade. [sapdbctrl.cp 4572]



Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Failed to disable auditing before upgrade, sp_configure, tempdb, upgrade

, 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.