Working with RSBatch

The RSBatch interface requires you to execute the LocalBatchComplete SQL script against the source Batchhis (batch journal) database. This script will add a new table called Local_BatchComplete and put a trigger on the source Batchhis table. You must provide permissions for the comxclient user in SQL so that comxclient has 'Select’ permissions against the source Batchhis table and 'Select’,’Update’ permissions against the Local_BatchComplete table.

The trigger on the Batchhis table will look for the record where the pvalue = 'End of Batch’. When it finds this record, it indicates that the batch has completed.  A row will then be inserted into the Local_BatchComplete table with the processed field set to '0’.  Model 5013 will fire on the interval specified when configuring the model and look to see if there are any unprocessed batches in the Local_BatchComplete table. If it identifies unprocessed batches, it will then select all the records from the Batchhis table, perform the required data mapping, insert the records into the Event_Transactions table, and mark the batch as processed in the Local_BatchComplete table.  

To configure Plant Applications

  1. Create a department, production line, and production unit in your Plant Applications plant model.

  2. Run the LocalBatchComplete.sql script, which is located in the C:\Proficy\Proficy Server\Support\RSBatch folder

  3. Configure Model 5013.

  4. Configure Model 118.

  5. Configure the following site parameters:

  6. Auto Configure Units

  7. Default Data Source

  8. Default Product Family

  9. Ignore Event Status Changes

  10. Purge Orphaned Records (Days)

  11. Purge Processed Records (Days)

  12. Wait Time (milliseconds)

Upgrading from earlier version of Plant Applications

In Plant Applications 5.0, the RSBatch interface has been modified so that updates/deletes no longer are done to the source Batchhis (batch journal) table. You can continue to use the existing interface until you decide to switch over to the new method.

If you are upgrading from an earlier version of Plant Applications and want to use the new interface, you must:

  1. Delete the existing spS88_RSBatch6Reader stored procedure

  2. Script in the new spS88_RSBatch6Reader stored procedure, which will be located in the ..Proficy\Proficy Server\Support\RSBatch directory.   

  3. Reconfigure Model 5013. In previous version of Plant Applications, there were multiple parameters that had to be defined in the spS88_RSBatch6Reader stored procedure that have now been set up as Event Configuration Properties, which must be defined in the Administrator, instead of altering the stored procedure. For instructions on configuring Model 5013, see the topic, Configure Model 5013