Posted: 2 May 2017 3:20 EDT Last activity: 2 May 2017 23:55 EDT
Maximum length of Decimal
I have problem that I can't insert or save a record with 10 digit or 1 billion in Decimal Data Type. How to resolve this? Is there any Numeric Data Type that have more than 10 Digit? I'm using DECIMAL in my Data Type.
Here is my ERROR log
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: numeric field overflow
Detail: A field with precision 18, scale 9 must round to an absolute value less than 10^9.
| SQL Code: 0 | SQL State: 22003
Can you please check the both DB Column data type and UI data type as Decimal and length of decimal characters in DB and UI field, if the length and decimal format was not mapping properly the above exception will throw from DB side.
coming to your exception your DB column field with precision 18, scale 9 . which means max number will allow 9 digits only.
alter the DB column (20,9) and try it once .
as per my experience with the same issue I solved like altered the decimal value DB column, for mapping same as both UI and DB.
So, PEGA only can save or insert less than 10 Digit in Numeric data type? because I make the table inside PEGA using Designer Studio in Menu ==> Data ==> Add data types. Where I can set the length in my PEGA table?