Code Fix: An error occurs when returning a list of decimal values
KB003141
PRODUCTK2 Five 5.3
K2 Five (5.3) Fix Pack 2
Issue Description
When you create a custom assembly and register a new Endpoints Assembly service instance, after generating a SmartObject and executing the method to return a list of decimal values, an error occurs.
Error Message
The following error occurs: “Arithmetic overflow error converting numeric to data type numeric”.
Resolution
- Ensure you have K2 Five (5.3) installed.
- Download the K2 Five (5.3) FP2 from K2 Partner and Customer Portal.
- Install the K2 Five (5.3) FP2 to apply the fix.
- Edit the Endpoints Assembly service instance.
- Change the decimal precision value to “30,8”. The default value is “23,9”. This is relevant to Endpoints Assembly as well as Endpoints WebService.
- Refresh the Service instance.
- For reference on which precision would be best to use, go to https://docs.microsoft.com/en-us/sql/t-sql/data-types/precision-scale-and-length-transact-sql?view=sql-server-2017