Error: Procedure or function [xxxx] expect parameter [xxxx], which was not supplied

You might experience this error while developing a custom batch type and have made changes to one of the forms on the batch type. When the Infinity platform loads a custom batch type it creates stored procedures that setup the interface and call the ones in forms.  This problem occurs in the case that you add a field from the forms and load the form but don't reload the batch type.
  1. Adminstration -> Applicaiton -> Catalog Browser
  2. Select Type: Batch Type
  3. Select Source: your custom assembly
  4. Click Apply
  5. Locate your custom batch type
  6. Click Load Item

Steps to Duplicate

1. Create a Custom Batch Type
  • do NOT include the @CURRENTAPPUSERID field on the commit form stored procedure.
  • CURRENTAPPUSERID is not defined on the form definition just the stored procedure
2. Load the custom batch type
3. Create a batch template from the batch type
4. Create a batch from the batch template.
5. Add test data to the batch.
6. Save and close the batch.
7. Modify the Add Commit form and Add the field CURRENTAPPUSERID.
8. Load just the Add Commit form.
9. Open the test batch.
10. Validate the Batch

Was this article helpful?