Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Video Training Guides
NEW

Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

HMRC Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

Error message when restoring database: Please close other [n] connections to DB (hub) and try again

Article ID: 2412
Last updated: 18 Mar, 2016

If you receive this error message when restoring a database, it means that the program is unable to close all the active connections to the database.

RSTORE ERROR   Please close other (n) connections to DB (hub) and try again

First, make sure that no other users are logged into TaxCalc and try to restore the database again.

If this doesn't work, follow these steps to restart PostgreSQL (TaxCalc database engine) and restore the database:

  1. Close TaxCalc.
  2. At the TaxCalc server go to START > Run (or Search depending on your operating system) and type services.msc.
  3. Press <return> or click OK.
  4. Once the Services window opens, scroll down to the PostgreSQL service and select it.
  5. Click Restart on the left-hand side of the  window.

     

  1. Once the service has restarted, open TaxCalc and restore the database.

IMPORTANT: If there is more than one PostgreSQL service, check with your IT staff or TaxCalc support so that you restart the correct one.

Article ID: 2412
Last updated: 18 Mar, 2016
Revision: 4
Views: 285
This article was:  


Also listed in
folder Technical -> Backing up and Restoring
folder Technical -> Database Related