Why I obtain this "Arithmetic overflow error converting numeric to data type numeric" into this simple insert query on Microsoft SQL Server? -

-

i pretty new database , have problem insert query insert record on microsoft sql server.

so have qs_tirpolizza table having following fields:

id  bigint polizzaid   bigint bankerid    varchar retevendita varchar percentualerendimentodainiziogestione   decimal percentualerendimentodainizioanno   decimal percentualerendimentodainiziotrimestre  decimal datacalcolobf   datetime annoriferimento int premioinizialeversato   money premiversatiinannoriferimento   money importiriscattatiinannoriferimento  money cedoleerogateinannoriferimento  money controvaloretotale  money datariferimentonav  datetime risultatoannuoinannoriferimento money premioinizialeversatodainiziogestione   money premiversatidainiziogestione    money importiriscattatidainiziogestione   money cedoleerogatedainiziogestione   money risultatoannuodainiziogestione  money capitalecasomorte   money timestamp   datetime quotetotale decimal percentualerendimentodainiziomese   decimal percentualerendimentodainiziosemestre   decimal controvaloretotaleannoprecedente    money datacontrovaloretotaleannoprecedente    datetime msgpercentualerendimentodainizioanno    varchar msgpercentualerendimentodainiziogestione    varchar msgpercentualerendimentodainiziomese    varchar msgpercentualerendimentodainiziosemestre    varchar msgpercentualerendimentodainiziotrimestre   varchar istiranomalo    bit

and insert query:

insert qs_tirpolizza(     annoriferimento,      bankerid,      controvaloretotale,      datacalcolobf,      datariferimentonav,      percentualerendimentodainizioanno,      percentualerendimentodainiziogestione,      percentualerendimentodainiziomese,      percentualerendimentodainiziosemestre,      percentualerendimentodainiziotrimestre,      polizzaid,      premioinizialeversato,      premioinizialeversatodainiziogestione,      quotetotale,      retevendita,      timestamp,      istiranomalo  ) values  (      2015,      'xxxxxxxxxxxxxxxxxxxx',      2993197.200971,      '2015-05-30 14:22:54',      '2015-05-30 14:22:56',      -139852.94674,      -0.22452,      null,      null,      -115890.54469,      123456789,      2999932.770000,      2999932.770000,      255388.71925,      'test',      '2015-05-30 14:23:25',      0  )

where fields percentualerendimentodainizioanno, percentualerendimentodainiziogestione, percentualerendimentodainiziomese, percentualerendimentodainiziosemestre, percentualerendimentodainiziotrimestre have decimal type on table definition.

the problem performing previous query obtain following error message , record not inserted:

15:00:14 [insert - 0 row(s), 0.000 secs] [error code: 8115, sql state: s0008] arithmetic overflow error converting numeric data type numeric.

i think problem these values have digits because reducing digits related entire , decimal sections of these number works fine. infact second version of query (that have number less digits previous fields) works fine:

insert qs_tirpolizza(     annoriferimento,      bankerid,      controvaloretotale,      datacalcolobf,      datariferimentonav,      percentualerendimentodainizioanno,      percentualerendimentodainiziogestione,      percentualerendimentodainiziomese,      percentualerendimentodainiziosemestre,      percentualerendimentodainiziotrimestre,      polizzaid,      premioinizialeversato,      premioinizialeversatodainiziogestione,      quotetotale,      retevendita,      timestamp,      istiranomalo  ) values  (      2015,      'xxx123yyy',      2993197.200971,      '2015-05-30 14:22:54',      '2015-05-30 14:22:56',      -139.9,      -0.22,      null,      null,      -110.54469,      1234567890,      2999932.770000,          2999932.770000,          255388.71925,     'ispb',      '2015-05-30 14:23:25',      0  )

these value generated java application , can't truncate can do? exist better data type can correctly contain these data on sql server?

you should mention size of datatype while creating tables in sql server. in case should mention precision , scale. please alter table datatype below.

decimal decimal(18,6) varchar varchar(500)

once made appropriate changes run insert script


Comments

Post a Comment

Popular posts from this blog

java - Static nested class instance -

-
this question has answer here: java inner class , static nested class 23 answers i came across in java, know static nested class why create instance of 'static'. isn't whole idea of 'static' use without instance? understand concept of inner classes, why (and frankly how possible to) create 'instance' of 'static' member @ ? why this: 1- outerclass.staticnestedclass nestedobject = new outerclass.staticnestedclass(); 2- nestedobject.anestedclassmethod(); and not this: 1- outerclass outerinstance=new outerclass(); 2- outerinstance.staticnestedclass.anestedclassmethod(); use on inner classes, keyword static indicates can access inner class without instance of outer class. for example: public class outer { public static class inner { /* code here. */ } } with construction, can create instance of inn
Read more

c# - Bluetooth LE CanUpdate Characteristic property -

-
i building xamarin.forms cross platform mobile app, uses monkey.robotics bluetoth low energy functionality. connecting mbed based implimentation of custom gatt service . in xamarin c#, triggers characteristic. canupdate property in monkey.robotics? this standard example c# based on: if (characteristic.canupdate) { characteristic.valueupdated += (s, e) => { debug.writeline("characteristic.valueupdated"); device.begininvokeonmainthread( () => { updatedisplay(characteristic); }); isbusy = false; // spin until first result received }; isbusy = true; characteristic.startupdates(); } this has been working, since changed own custom gatt service connecting to, canupdate property false. property , how triggered? me debugging gatt service code. thanks monkey.robotics open sour
Read more

JavaScript - Replace variable from string in all occurrences -

-
ok, know if have character '-' , want remove in places in string javascript, ... someword = someword.replace(/-/g, ''); but, when applying array of characters, s not working ... const badchars = ('\/:*?"<>|').split(''); let filename = title.replace(/ /g, '-').tolocalelowercase(); (let item = 0; item < badchars.length; item++) { // below not work global '/ /g' filename = filename.replace(/badchars[item]/g, ''); } any ideas? /badchars[item]/g looks badchars , literally, followed i , t , e , or m . if you're trying use character badchars[item] , you'll need use regexp constructor, , you'll need escape regex-specific characters. escaping regular expression has been well-covered . using that: filename = filename.replace(new regexp(regexp.quote(badchars[item]), 'g'), ''); but , don't want that. want character class: let filename = title.replac
Read more