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:


alter database upgrade 
-- 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 3587 with sqlcode -110 -- Msg 12006, Level 16, State 0: -- SQL Anywhere Error -110: Item 'sa_conn_list' already exists

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.