web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

New company 'locked by another user'?

(0) ShareShare
ReportReport
Posted on by

Hi

I am in the trial period and I created another company a while ago to test something. But now when I try and interact with it I am no longer able to do anything - if I try and rename or delete the company I get this error:

The operation could not complete because a record in the Account. Period table was locked by another user. Please retry the activity.

I also get the error when attempting to change company from Cronus to this test company - I can no longer access it.

I don't know what is going on because the record cannot be locked by another user - I know that I am the only user currently on the system.

Can anyone help?

Categories:
I have the same question (0)
  • katrina.caswell Profile Picture
    on at

    Update: Now I can't actually switch company at all. When I click on the ellipsis next to company under My Settings, I get this error:

    Invalid object name 'msuk1a9310t69419032_msuk1neuas9363.dbo.Test Company Ltd$Job Queue Log Entry'.

    Statement(s) could not be prepared.

    Page Allowed Companies has to close

  • Suggested answer
    MCarrero Profile Picture
    774 on at

    Are you within the 30 day trial period?

    If so, then I would suggest you check your user permissions.  you need to make sure you have super with no specific company listed in your permission set.

    If not, when you create a new company, you have to specifically assign permissions for that company.

  • katrina.caswell Profile Picture
    on at

    I am within the 30 day period, yes. I am a super user like you described.

    I think I must have deleted something I should not have, because I could access the 'companies' page before but I cannot anymore.

  • Verified answer
    Chris Bulson Profile Picture
    Microsoft Employee on at

    Hello,

    Please confirm that you have SUPER with No Company specified.  The no company specified is the important piece that most people miss.

    Could you also Private Message me your tenant (URL you use to access Financials).

    Thanks,

    Chris

  • Verified answer
    Chris Bulson Profile Picture
    Microsoft Employee on at

    This issue was resolved offline and required backend intervention.  It was the result of a failed company rename.

    Thanks,

    Chris

  • Community Member Profile Picture
    on at

    Hi Chris, I ran into a similar situation. I try to create a company in Business Central, the setup was being cutoff and it kicked me out. When I tried to log back in, it gave me a blue screen and didn't even give me a chance to switch companies. What kind backend intervention you done to fix Katrina's issue above? Thanks.

  • Chris Bulson Profile Picture
    Microsoft Employee on at

    Hello,

    I'm not sure, but if you can give me some more information I may be able to help.  What error are you seeing when you attempt to log in?  Please either provide a screenshot or the exact verbatim error.

    Thanks,

    Chris

  • Community Member Profile Picture
    on at

    Thanks for the Reply Chris, below is screen shot when I start BC. I do have multiply companies set up there, it remember my last choice and doesn't even give me opportunity to choose other company, so I am kind stucked here.

    Thanks,

    Ray

  • Community Member Profile Picture
    on at

  • Community Member Profile Picture
    on at

    ops,it filters my picture out, not sure how I can post it or send

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans