Having the wrong SQLORA8.DLL living on a workstation, might cause the system to create double batch entries after the count of entries, into one batch, has hit or exceeded 20 accounts.  Upon installation or Upgrade, please make sure to perform this step at each workstation and at the server AFTER the Campaign software has been fully installed/upgraded.

Search the local workstation for file SQLORA8.DLL or go to C:\Program Files\Common Files\Borland Shared\BDE to find the file.  Check the date on the existing file - if anything other then 06.16.2000, please download and use the SQLORA8.DLL patch utility to replace the file with the correct version.

For more information on downloading and installing this update, please see http://douglas-associates.com/files/folders/csi/entry44.aspx

Updating the SQLORA8.DLL file is a simple operation and can be done by the user.  If a batch actually has duplication and needs repair, this is an advanced operation and it is recommended that you call Douglas Associates for assistance.

1. Search for file SQLORA8.DLL on the workstation
    - the correct file should be dated 06.16.2000 
    - if the DLL is dated 1999, replace with the current version.
The current version of the DLL is found in file SQLORA8_512.exe
Double click the icon, choose YES to over write the current old version.
Close the window. 

If duplication has happened prior to the application of the  new .DLL

2. Take a backup of the database
3. Get the exact batch number(s) needed for repair  (see this query for more information)
4a. From SQL run, DELETE FROM PR_JOURNAL WHERE batch in ('9104','3837')
4b. From SQL run, DELETE FROM XBATCH WHERE batch in ('9104','3837')
4c. From SQL run, UPDATE BATCH_MAIN SET STATUS='OPEN' WHERE batch_number in (9104,3837)
5. Commit changes.
6. Repost the batch(s) using the software, POST button from batches.
7. Run reports (either pledge and/or payments to ensure correct numbers.