AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
AcumaticaDB Locked
 
Notifications
Clear all

Questions AcumaticaDB Locked

 
Everything Else
Last Post by Tim Rodman 7 years ago
6 Posts
3 Users
0 Reactions
6,077 Views
RSS
Posts: 11
 Christopher van Heerden
Topic starter
January 7, 2019 7:06 am
(@christopher-van-heerden)
Member
Joined: 7 years ago

Good day everyone.

Today I tried adding a new company to my Acumatica instance.

 

I followed the process as Tim shows on how to add a new company and at the time the progress bar showed, the system seemed to take forever to complete the step so I hit CTRL+ALT+DEL in order to kill the current AcumaticaERP process.

 

The problem/s I have now is that my site is currently under maintenance mode and if I try to anything in the wizard; I get the error/notification that the Acumatica DB has been locked by another process.

 

Does anyone know how to get out of this predicament please?

I would like to first delete the test company I created and then recreate a new company again.

 

Thank you in advance for your assistance.

 

Kind regards,

Christopher


5 Replies
Posts: 11
 Christopher van Heerden
Topic starter
January 7, 2019 7:10 am
(@christopher-van-heerden)
Member
Joined: 7 years ago

I have also executed a iisreset command but that is not resolving this lock.


Reply
Posts: 11
 Christopher van Heerden
Topic starter
January 7, 2019 7:38 am
(@christopher-van-heerden)
Member
Joined: 7 years ago

Good news:

I decided to use the Acumatica Framework Config Wizard and I did a "Setup database" run on the AcumatiFrameworkDB.

 

Problem seems to be resolved as I can see my new company now and log in at that too.

 

Warm regards,

Christopher


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
January 9, 2019 1:30 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I wonder if the update process just had to run its course. It takes a while to complete. It might not have been anything that you did, just the process finishing on its own.


Reply
Posts: 1
 MWA Demo
January 16, 2019 11:40 am
(@mwa-demo)
Member
Joined: 7 years ago

I ran into the same issue today (fortunately on a test system), but my machine did a windows reboot during an upgrade.

I could not run the upgrade again (customizations), so had to run the old version, but received this error.

I tried the Acumatica Framework suggestion, but that Setup Database was not available for me (2018 R1).

I ended up deleting a record from the UPLock table in the relevant Acumatica database, and that seemed to help me get past the error.


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
January 24, 2019 4:01 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Thanks for sharing MWA. I didn't know about the UPLock table.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,529 Topics
  • 11 K Posts
  • 30 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Nathan Deardorff
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×