We have Attain360 and are seeing the above SQL error whilst capacity value entries are being written to the database.
This has only just recently happened and we are suspecting a corrupt table. We can’t reproduce the error on any other database.
It it easy to replicate whilst simply creating a new record in T5802 (Value Entry ) directly, and then updating the “Cost amount (actual)” to anything from 0.
There is no ONVALIDATE or ONMODIFY/ONINSERT code on the table so does any one have any ideas?