2623201 - Error 247: Arithmetic overflow during explicit conversion of DECIMAL value ... to NUMERIC. - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2623201 - Error 247: Arithmetic overflow during explicit conversion of DECIMAL value ... to NUMERIC. - SAP ASE

Symptom

  • Received the following error:

Msg 247, Level 16, State 1:
Server 'myASE', Line 1:
Arithmetic overflow during explicit conversion of DECIMAL value '4440585983' to a NUMERIC field .

  • When changing a column's datatype as:

alter table  mytable modify mycolumn  DT_IDENTITY_9 null

  • The table has several columns defined as:
 Column_name    Type             Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity
 -------------- ---------------- ------ ---- ----- ----- -------------- ------------ --------- ---------------- ---------------------- ----------
 col1           DT_DECIMAL4_0         3    4     0     0              0 NULL         NULL      NULL             NULL                            0
 mycolumn       DT_DECIMAL10_0        6   10     0     0              0 NULL         NULL      NULL             NULL                            0
 col3           DT_DECIMAL2_0         2    2     0     0              0 NULL         NULL      NULL             NULL                            0
 col4           DT_IDENTITY_6         4    6     0     0              0 NULL         NULL      NULL             NULL                            0
 col5           DT_INDIC_SEQNR_3      3    3     0     0              0 NULL         NULL      NULL             NULL                            0
 col6           DT_IDENTITY_6         4    6     0     0              0 NULL         NULL      NULL             NULL                            0
 col7           DT_SEQNR              4 NULL  NULL     0              0 NULL         NULL      NULL             NULL                            0
 col8           DT_IDENTITY_9         5    9     0     1              0 NULL         NULL      NULL             NULL                            0
 …

Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

range, digit, precision , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.