Hello Kimberly!When pVault/Sage Paperless Construction client is open, or Application server is running, Sage 300 (v18) table files are being kept open which becomes an issue when certain Sage 300 processes require that no files be in use (specifically Payroll has been reported as an issue).
Sage has provided a hotfix for their customers to be used in conjunction with modifications provided in pVault Version 188.8.131.52 and Sage Paperless Construction 184.108.40.206 which has been made available to all customers NOTE: The customer has to be running Sage 300 18.2.1 in order to use this hotfix.
Hotfix details are below (these instructions were provided by Sage). Please note that this has to be done on every workstation and server which has Sage 300 installed on it and where Paperless is being run. Any workstation which is left unpatched by not applying the hotfix, or by not updating to the correct version of pVault or Sage Paperless Construction, will continue to cause the files to be locked. I have performed verification tests here locally and the hotfix in conjunction with our updated version to support their hotfix does in fact appear to resolve the issue.
INFORMATION FROM SAGE REGARDING HOTFIX
The hotfix will be required on any machine that is going to access data using ODBC to correct the issue. The hotfix changes the connection to the way it was before version 18.2 but requires a connection string change to make that possible.
Steps for applying the hotfix:
The hotfix is available here:
Home of the Connection Café.
100 Village Blvd., Suite 200, Princeton, NJ 08540Phone: 609-452-8000 | 888-421-9996 | Fax: 609-452-0474 | firstname.lastname@example.org