Skip to main content

null value in column "packing_option_id" of relation "box" violates not-null constraint

Pankaj Singhal avatar
Written by Pankaj Singhal
Updated this week

Error: null value in column "packing_option_id" of relation "box" violates not-null constraint

What does this error mean?

This error occurs when ScanPower fails to save the packing option for the shipment plan. This normally happens automatically but can be easily fixed. Since the packing_option_id field is mandatory, the box creation operation is rejected when it finds a missing (null) value.

Why does it happen?

There are a few possible reasons for this error:

  • The packing option linked to the box was not properly saved or has been deleted.

  • The system failed to assign the default packing option during processing.

  • A data integrity issue occurred while generating or modifying the batch.

How to resolve it?

This error cannot be fixed directly by the user. Please contact the Support Team to fix the issue or if you have not created the boxes yet, you can cancel the shipment plan and create it again.

Did this answer your question?