Sources for Exceptions When You Save Data into a Batch

When you save data into a batch table through the batch grid user interface, exceptions may arise from many sources:

Without some background, it can be hard to decipher where errors originate. So let's explore some of the ways that you can cause exceptions when you save rows to a batch.

Exceptions from Form Field Metadata

Form Metadata helps to ensure data integrity and can cause exceptions when you save a batch with form fields that contains built in validation metadata such as required. As a review, our batch table is named USR_BATCHFOODITEMADD. This table contains a NAME field that is required. The NAME field was created by the following field in the TableSpec:

<TextField Name="NAME" Length="100" Required="true" />