SAP Knowledge Base Article - Preview

3357780 - ALTER DATABASE UPGRADE fails due to SQLCODE=-1987 - SAP IQ

Symptom

When you upgrade IQ 16.0 to 16.1, you will perform "ALTER DATABASE UPGRADE PROCEDURE ON" on new version.
Then you may get the below error:

(DBA)> ALTER DATABASE UPGRADE PROCEDURE ON
Could not execute statement.
  Database upgrade not possible; database has auditing enabled
  SQLCODE=-1987, ODBC 3 State="08004"

Line 1, column 1
  ALTER DATABASE UPGRADE PROCEDURE ON

Press ENTER to continue...


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

Database upgrade not possible, database has auditing enabled, ALTER DATABASE UPGRADE , KBA , BC-SYB-IQ , Sybase IQ , 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.