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 for Me (Login required).

Search for additional results

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