Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Great Plains 2009 - Pr...
Microsoft Dynamics GP (Archived)

Great Plains 2009 - Project No Locked

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

A team member has attempted to process an invoice in the Billing Entry screen in GP 2009 and the following error arose:

The project is being used by another user. Please select another Project Number.
The project number is locked and the invocie is unable to be processed.

External IT support are suggesting to restart the SQL server where the Great Plains database sits on and this may unlock the project.

Are there any other options our company should consider as well as alternatives?

We're in the process of upgrading to a much new GP version.

Thanks

*This post is locked for comments

  • Suggested answer
    Squishy Worms Profile Picture
    Squishy Worms 15 on at
    RE: Great Plains 2009 - Project No Locked

    Sadly, I see this all the time in our company.  It's seems Microsoft Dynamics GP is dead set on keeping projects locked.

    I have often just use: DELETE PA000001; since the majority of projects should not be locked.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Great Plains 2009 - Project No Locked

    Thanks Irfan for the feedback.

  • Verified answer
    Irfan.Rasheed Profile Picture
    Irfan.Rasheed 715 on at
    RE: Great Plains 2009 - Project No Locked

    Hi,

    Use this script to company database.

    Select * from PA000001, that brings which user open specific project.

    From backend you can also remove that user from this project using

    Delete PA000001 where userid='XXXXXXXX'

    I hope it shall serve the purpose.

    Regards.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Great Plains 2009 - Project No Locked

    Richard, we got the locked project to clear with the help of your suggestions, thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Great Plains 2009 - Project No Locked

    Thanks Richard, I'll run your suggestion past our Great Plains and IT providers for guidance

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Great Plains 2009 - Project No Locked

    Change the last two to

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Great Plains 2009 - Project No Locked

    Before you reboot the server or simply stopping and starting he SQL service would do the same thing I would run these in SSMS:

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT  FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    Run these while no one is in GP. If any of these return records then

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE  FROM TEMPDB..DEX_LOCK

    DELETE FROM TEMPDB..DEX_SESSION

    Let us know how it goes.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Great Plains 2009 - Project No Locked

    Thanks Richard

    We found the exact same as well on the internet.

    Our Great Plains partner recommended the same solution and advised for our IT support provider to follow this recommendation.

    However they had no success and project is still locked.

    Is the IT support provider the correct party to be doing this?

    Anything else we could try or is this the correct & only suggestive approach to remedy when a Project No is locked?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Great Plains 2009 - Project No Locked

    The standard IT advice of rebooting the server will not correct this. Please refer to this KB.

    https://support.microsoft.com/en-us/kb/940834?sd=rss&spid=10479

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans