Issues that may be caused by a large Log Viewer:

• Slow performance in Sage 300 CRE
  • How do I troubleshoot slow performance in Sage 300 Construction and Real Estate and Sage Estimating?
• Files in use, files locked open, error TS 2606
  • Error: "File in Use" or "Record in use"
  • Error: "STOP! Another user has locked a portion of the data file required by this task."
  • Error: "Program aborted. Record not locked [TS 2606]"
• False Pervasive status code 2 errors.
• False Pervasive status code 54 errors.
• ODBC operations not functioning properly or errors occurring
  • Error: "[42000] [Sage][SQLEngine] (31732) Driver is read-only and does not permit UPDATE operations."

If interfacing software uses an ODBC connection, entries will be logged to the Log Viewer every time it syncs or makes a connection. This can cause multiple entries because of the continuous syncing, some programs will continue to sync overnight. Refer to Log In/Out entries from interfacing software are filling the Sage Log Viewer for instructions.

To identify the size of the Log Viewer file:

1. Using File Explorer, browse to the Global folder on the server (default location is C:ProgramData\Sage\Timberline Office\9.5\Accounting\Global or \\[serversname]\Timberline Office\9.5\Accounting\Global\).
2. In the Global folder, open the PVData folder.
3. Right click on the master_qlm folder, then select Properties.
4. Make note of the Size.

When the master_qlm size is approaching 2GB, consider archiving.