SAP Knowledge Base Article - Preview

2650745 - Function user_name() fails with error Value 2147484648 out of range - SAP IQ 


  • Execute the function user_name() to get the name of a user associated to a user ID.
  • The ID number of a user is greater than 2 147 483 647.
  • The execution fails with the following error message:

Could not execute statement.
Value 2147484648 out of range for destination
SQLCODE=-158, ODBC 3 State="22003"



  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4


user_name, 2147482648, 704155, CR704155, CR#704155, out of range, SQLCODE=-158 ODBC 3 State="22003" , 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.