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.
SAP Knowledge Base Article - Preview