SAP Knowledge Base Article - Preview

2152520 - Upgrade Cannot delete PUBLIC option 'float_as_double' SAP IQ


Error message while doing the upgrade from IQ 15.2:

(DBA)> alter database upgrade commit
Database upgrade started
Creating system views
Creation of system views completed
Creating DBO views
Creation of DBO views completed
Creating system procedures
Creation of system procedures completed
Error in file upgrade.sql at line 2481 with sqlcode -896
Could not execute statement.
  Cannot delete PUBLIC option 'float_as_double' since user settings exist
  SQLCODE=-896, ODBC 3 State="42000"
  Line 1, column 1
  alter database upgrade commit
Press ENTER to continue...



  • SAP IQ 15.2 
  • SAP IQ 16.0


SAP IQ 16.0 ; SAP Sybase IQ 15.2


FLOAT_AS_DOUBLE, upgrade, SQLCODE=-896 , 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.