Error: "File in Use" or "[Record] in use"
Description
Cause

A record or file is locked by another user or workstation or is locked open on the server.

A large Log Viewer file (QLM file) can also cause "file in use" messages or files to become locked.

Resolution

[BCB:3:Network warning:ECB]

 

  1. Have all users exit all Sage 300 CRE applications.
  2. Have all users exit any third-party programs that access Sage data.
  3. Relaunch Sage 300 CRE and try the tasks again.
  4. If the message persists, have the affected user reboot their workstation.
  5. Have users in remote sessions log off properly.
  6. If this doesn't resolve it, release the files at the server.
  7. Test the tasks again.
  8. If the issue continues, archive or move the Log Viewer file.
  9. After resolving the error, restart services for any third-party programs to refresh the connection to Sage data.

 

These steps work for the following issues and messages.

Issues

  • Background Tasks window is spinning
  • PJ change order says "read only"
  • The program window is stuck
  • The printer is stuck
  • Tasks aren't working
  • Crystal report returns error: "unable to locate table"
  • When I try to close the month, or period, in my application I get a "File in Use" error
  • 0 posted 0 rejected on posting journal when there are entries or invoices to post

Errors

  • File in use
  • PR transaction file in use
  • Invoice in use
  • Header in use
  • Master file in use
  • Transaction file in use
  • Contract is in use
  • CN Derived file in use
  • Read-only Record in use
  • TS 3712
  • Batch in use
  • Bank Account in use
  • Employee record in use
  • Job Record in use
  • Vendor in use
  • This vendor is being used by another task or workstation
  • Session is in use by another task or workstation
  • Payroll (PR) Transaction file in use
  • TSIO in use error
  • General Ledger (GL) Current transaction file in use
  • TS 3407
  • Cash receipt Batch in use
  • GL Master file in use
  • The file that contains the application settings (ts.ctl) is in use
  • GL file in use
  • GL budget file in use
  • AP master file in use
  • Commitment record is in use
  • PM accum file in use
  • mnu file in use
  • Bank account in use
  • Commitment xxx file is in use
  • File is locked
  • PR Transaction file is in use
  • PM deposit in use
  • PJ record says "read" at the top
  • BL invoice in use
  • JC master file in use
  • PJ 1820
  • AR Deposit is currently in use. Try again later
  • Waiting on another print job
  • Attachments in use
  • PM Error: 3426 Lease in Use
  • Locked file
  • Billing is already in use

 

 

[BCB:156:Chat 300 CRE US:ECB]





 

Steps to duplicate
Related Solutions

Issues caused by a large Log Viewer file (QLM)

How to archive the Log Viewer

Files are being locked by third-party programs (Sage Paperless Construction, TimberScan, MyAssistant, etc)

How do I use the Pervasive Software Monitor Utility (PMU/PSMU) to unlock a file on a server that uses a Windows operating system?