SAP Knowledge Base Article - Preview

3257658 - Arithmetic overflow updating identity_burn_max value using sp_chgattribute- ASE

Symptom

  • Version 16.0 SP03 PL10 and above
  • updating identity_burn_max value greater than 30 digits
  • The following error is displayed:

    Msg 247, Level 16, State 1:

    Server 'Server_Name', Procedure 'sp_chgattribute', Line 1734:

    Arithmetic overflow during implicit conversion of NUMERIC value

    '250000000000000000000000349895330' to a NUMERIC field .
     123456789012345678901234567890123.......................................33 digits


Read more...

Environment

Known Versions where this error has occurred:

  • Adaptive Server Enterprise 16.0 SP03 PL10
  • Adaptive Server Enterprise 16.0 Sp03 PL11
  • Adaptive Server Enterprise 16.0 Sp04
  • Adaptive Server Enterprise 16.0 SP04 PL01
  • Adaptive Server Enterprise 16.0 SP04 PL02

Product

SAP Adaptive Server Enterprise all versions

Keywords

sp_chgattribute Arithmetic overflow 247 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.