• New Sage Payroll Update v27.1 Released
    Includes ERR and CWPS enhancements
  • New Sage Payroll Update v27.1 Released

Sage Drive Issue – Waiting to Open Queue.dta

When using Sage Drive, when you open the software at either the main site or a secondary site, the following messages may appear:

  • ‘Waiting to open Queue.dta’
  • ‘Queue.dta is in use. Please wait until this file is available’
  • ‘The Sage ID user <<Sage ID email address>> on computer <<computer ID>> is currently processing at <<the main / a remote>> site.

 

To resolve this issue please click the appropriate options below:

Do you use Sage Drive? If Yes

Are all of your computers with a Sage installation running the latest build of your software version

If possible, restart the computer where your data is held.

If this isn’t possible, you must instead reset the Sage services and processes.

Reset the Sage services and processes

You must follow these steps on the computer or server where your Sage Accounts data is held. If using Sage Drive, you should carry these steps out at both the Sage Drive main site and remote site.

If you’re using a networked version of Sage Accounts, all other users must be logged out of the data.

  1. Close Sage Accounts.
  2. Hold down Ctrl + Shift + Esc to open the Windows Task Manager.
  3. Click the Processes
  4. Right-click the relevant process and click End Process then click End process.
Version Windows 7 and below Windows 8 and above
25 sg50svc_v25.exe *32

sg50CtrlSvc_v25.exe *32

Sage 50 Accounts Service v25

Sage 50 Accounts Control Service v25

24 sg50svc_v24.exe *32

sg50CtrlSvc_v22.exe *34

Sage 50 Accounts Service v24

Sage 50 Accounts Control Service v24

23 sg50svc_v23.exe *32

sg50CtrlSvc_v23.exe *32

Sage 50 Accounts Service v23

Sage 50 Accounts Control Service v23

22 sg50svc_v22.exe *32

sg50CtrlSvc_v22.exe *32

Sage 50 Accounts Service v22

Sage 50 Accounts Control Service v22

21 sg50svc.exe *32

sg50CtrlSvc.exe *32

 

Sage 50 Accounts Service

Sage 50 Accounts Control Service

 

5.In Task Manager click the Services

6.Right-click the relevant services and click Start Service.

v25 §  Sage 50 Accounts Service v25

§  Sage 50 Accounts Control Service v25

v24 §  Sage 50 Accounts Service v24

§  Sage 50 Accounts Control Service v24

v23 §  Sage 50 Accounts Service v23

§  Sage 50 Accounts Control Service v23

v22 §  Sage 50 Accounts Service v22

§  Sage 50 Accounts Control Service v22

v21 §  Sage 50 Accounts Service

§  Sage 50 Accounts Control Service

7.Close Task Manager window.

Stop the backup manager processes

  1. Hold down Ctrl + Shift + Esc to open the Windows Task Manager then click the Processes
  2. If listed, right-click the following processes and click Stop.
    • Sage 50 Check Data Standalone App – CheckDataStandaloneApp.exe *32
    • Sage 50 Backup Standalone App – BackupStandaloneApp.exe *32
    • Sage 50 Restore Standalone App – RestoreStandaloneApp.exe *32

These services will restart automatically when your next scheduled backup runs.

Delete the queue.dta if present in the data path  

Summary

If using Sage Drive, you should carry these steps out at both the Sage Drive main site and remote site.

  1. Stop the sage data service
  2. Check and stop any of the 3 backup manager process (i.e checkDataStandaloneApp, BackupStanaloneApp and RestoreDataStandaloneApp)
  3. Delete the queue.data in the data path on the server/Mainsite