SAP Knowledge Base Article - Preview

2315373 - msg 247 "arithmetic overflow during explicit conversion of VARCHAR" - SAP ASE

Symptom

  • when sp_spaceused is run on a table which has more than 200,00,00,000 err
  • sp_spaceused reports arithmetic overflow for bigger tables
  • Msg 247, Level 16, State 1:
    Procedure 'sp_f_getuint', Line 43:
    Arithmetic overflow during explicit conversion of VARCHAR value '4294967296' to
    a UNSIGNED INT field .
    (return status = -6)

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • Solaris on Sparc 64 bit
  • Solaris on x86_64 64bit

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

msg 247, Severity 16, sp_f_getval, sp_spaceused, value '2550000000', UNSIGNED INT, CR#731171, CR731171, 731171 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.