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

Search for additional results

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