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

      Amending the Database Sweep Interval Setting Overview: On some large databases, performance issues maybe experienced due to the database Sweep Interval setting being set at a higher level than need be. By default the Sweep Interval setting is set to ...

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

    • Internal GDS Error

      User gets this message "Internal gds software consistency check (can't continue after bugcheck)." There could have been an event (i.e. power surge, shutting down the PC while Ostendo was running, hard disk corruption etc...) that has caused a ...

    • Error Message - Error in expression when running a Report. [Square Brackets]

      The F4 function Key in Ostendo automatically inserts a date and timestamp along with the UserName all enclosed in Square Brackets. Unfortunatley sometimes when reports are generated with this data contained, throw an error message Error Message ...