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.