Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE"
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE",value"*** null ***".
At Trigger 'JOBLINE_ADDFIELD_INSERT' line: 162, col: 6.
This error is displayed when Ostendo is attempting to resolve the Sell Price for a new Job Line when it is added. The cause of this error is because the "Round Up to nearest value" has been set to 0.00 or blank
This would have been caused by importing incorrect data directly into this field against the ItemMaster as the Ostendo Item Pricing screen does not allow this value to be stored.
Amend this value to 0.001 to resolve this problem as this is the default value
Related Articles
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE"
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE",value"*** null ***". At Trigger 'JOBLINE_ADDFIELD_INSERT' line: 162, col: 6. This error is displayed when Ostendo is attempting to resolve the Sell Price for a new ...Database Sweep Interval Setting To Improve Performance
Overview: Garbage Collection: This is the ongoing cleaning of the database and is performed in the background around the clock. This constantly reorganises the memory space used by the database. If you don't clean up the database performance will ...Manually Running a Database Sweep
The default database sweep value is 20000. If this value has been amended to Zero, it will be necessary to empty out accumulated 'garbage'. This can be achieved by either performing a Firebird Validate / Backup and Restore of the database, or ...08/05/2025 - Database Sweep Interval Setting To Improve Performance
Database Sweep Interval Setting To Improve Performance Correction to previous Article (Please Note: This is an amended version to the previous article on Sweep Interval. There was a syntax error in the DOS commands) On occasions sites can suffer ...Database Utilities Integrity Check Error When Backing Up a Database already Upgraded to Continuum
As part of the process of upgrading a Firebird 2.5 Continuum database, a Firebird 2.5 backup must first be performed. This is typically done using the existing dbutils.exe (Database Utilities) program included within an Ostendo 242 environment. When ...