Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Please close the Project Closing window first to complete the closing process

(0) ShareShare
ReportReport
Posted on by 880

This is an interesting one. Using the Project Closing window, anytime I select a particular contract, the prompt "Please close the Project Closing window first to complete the closing process" appears.

It's just this contract

I've cleared all activity tables (including PA000001) & cannot for the life of me figure out what's stuck with this project.

Any $.02 would be much appreciated.

pastedimage1618342900407v1.png

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Please close the Project Closing window first to complete the closing process

    Hi Kyle,

    it might not be an open Project window that's causing the message to pop up, but an actual record that is locked in a table.. could you please check if there is anything in the Dex_lck table ?

    When looking up the contract number in the PA Closing window, GP goes thru quite a range of SP's to do validation, and it seems to fail at one of them..

    Before you even get a chance to list the contracts, this is what runs in the background:

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(149028504):*/

    { CALL DYNAMICS.dbo.zDP_SY01600SS_1 ( 'sa', 'Fabrikam, Ltd.', 'PA_Contract_Lookup', 'Contract_Lookup' ) }

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(148976944):*/

    { CALL TWO.dbo.zDP_SY00700SS_1 ( 'Contract Lookup' ) }

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(149022176):*/

    SELECT COUNT(PACONTNUMBER) FROM TWO.dbo.PA01101

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(148959160):*/

    {CALL TWO.dbo.zDP_PA01101F_1(NULL,NULL)}

    Then comes a huge SELECT query that ends with :

    SELECT TOP 25 * FROM TWO.dbo.PA01101 WHERE PACONTNUMBER = 'ADAMPHOTEL' ORDER BY PACONTNUMBER ASC

    Followed by another one with :

    FROM TWO.dbo.PA01101 WHERE PACONTNUMBER = 'COHONET' ORDER BY PACONTNUMBER ASC

    As next comes several validations which might be one of the culprit to your pop-up:

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148929688):*/

    { CALL TWO.dbo.zDP_PA000001SS_1 ( 7, 'COHONET' ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149021272):*/

    BEGIN DECLARE @num int EXEC TWO.dbo.zDP_PA000001SI 'sa', 7, 'COHONET', 7, 0, @num OUT SELECT @num END

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149027600):*/

    { CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( -1, 258, 6, 0 ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149032120):*/

    {CALL TWO.dbo.zDP_PA11900F_1(NULL,NULL,NULL,NULL)}

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148959160):*/

    { CALL TWO.dbo.zDP_PA01101SS_1 ( 'COHONET' ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148926976):*/

    {CALL TWO.dbo.zDP_PA01201F_9('COHONET','','COHONET','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148955544):*/

    { CALL TWO.dbo.zDP_RM00101SS_1 ( 'COHOWINE0001' ) }

    I'd check the PA11900 table to see if there is any previou left over records, as this is the PA Project Closing HDR Work table, or by that matter, any PA1190x tables, as they are all linked to the PA closing process and should be empty in normal time.

    You could also run some checklinks across the PA module to see if there are any inconsistencies.. of course after full backup :-)

    PS: if you have GPPT, enable DEXSQL trace right before opening the lookup for the Contract #.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans