2598232 - Problems running ALTER DATABASE UPGRADE - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2598232 - Problems running ALTER DATABASE UPGRADE - SAP IQ

Symptom

When running ALTER DATABASE UPGRADE, you may run into problems such as:

alter database upgrade JCONNECT ON;
-- Database upgrade started
-- Creating system views
-- Creation of system views completed
-- Creating DBO views
-- Creation of DBO views completed
-- Creating system procedures
-- Error! The connection to the database was closed by the server.
-- Connection was terminated
-- SQLCODE=-308, ODBC 3 State="HY000"

Or:

alter database upgrade JCONNECT ON
-- Database upgrade started
-- Creating system views
-- Creation of system views completed
-- Creating DBO views
-- Creation of DBO views completed
-- Creating system procedures
-- Error in file sybprocs.sql at line 49 with sqlcode -110
-- Could not execute statement.
-- Item 'sp_tsql_feature_not_supported' already exists
-- SQLCODE=-110, ODBC 3 State="42S01"

Or, after running ALTER DATABASE UPGRADE, there are stored procedures such as sp_login_user_check missing.


Read more...

Environment

  • SAP IQ 16
  • SAP IQ 16.1

Product

SAP IQ 16.0

Keywords

EXCLUDEOBJECT , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.