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