Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE"

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 ...

    • Validating and Repairing a Corrupt database

      This document describes the process of Database Validation and Repairing. It should be run directly on the host machine. Partners have the same tools available to them as Development-X. If the database is still corrupt after performing the DOS level ...