SAP Knowledge Base Article - Preview

2279010 - Procedure sp_iqversionuse invoked from dbisql, IQCockpit or SCC may fail on hextoint function error - SAP IQ 16

Symptom

  • Calling sp_iqversionuse from IQCockpit, SCC or dbisql may fail with error:
2016-01-08 16:21:55,073 [WARN ] [jmx.ManagedObjectGateway                     ] [scc-ui::289137] - Failed to invoke managed object 'D5A7E4A8B56711E58000F8B54AAEBF57' mbean operation retrieveVersionUsageKPA([]): com.sybase.jdbc4.jdbc.SybS
QLException: SQL Anywhere Error -1090: Function 'hextoint' has invalid parameter '1' ('173512987')
2016-01-08 16:21:55,076 [ERROR] [scc.jmx                                      ] [scc-ui::289137] - managedObjectGateway.invoke( [LoginVO [localeName=en_US, sessionToken=1-
  • Or
Could not execute statement.
Function 'hextoint' has invalid parameter '1' ('17490E3C0')
SQLCODE=-1090, ODBC 3 State="08004"
  •  Or
Could not execute statement.
Value -2119995654 out of range for destination
SQLCODE=-158, ODBC 3 State="22003"
  • If the option CONVERSION_ERROR is set to OFF the procedure may fail with a message similar to the following instead...
Msg 233, Level 16, State 0:
SQL Anywhere Error -195: Column 'VersionID' in table '#iqversionlist' cannot be NULL

Read more...

Environment

  • SAP IQ 16 all platforms

Product

SAP IQ 16.0

Keywords

CR794762, CR#794762, 794762, sybase, hextoint, hoxtobigint,  ' -1090', 1090, INT, BIGINT, iq_dummy, invalid parameter, IQcockpit, sp_iqversionuse, retrieveVersionUsageKPA, spiqversionuse, convertion, sybase, "version use" , 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.