Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Unable to purge Project Detail

Posted on by Microsoft Employee

Client has a number of projects they'd like to purge and have set the status to Purge. Running the Delete Project Detail process (Project tab), we receive a list of errors similar to these for the projects: 

Analysis of project V20101 beginning

Transaction record(s) (PJTRAN) exist for project V20101 that are equal to or greater than the current fiscal year 201910

Analysis of project V20102 beginning

Transaction record(s) (PJTRAN) exist for project V20102 that are equal to or greater than the current fiscal year 201910

Even selecting the Purge Projects with warnings does not remove them. I ran the below script in SQL and received no records:

SELECT PROJECT, * FROM PJTRAN WHERE fiscalno >= '201910' AND PROJECT LIKE 'V%'

Finally, I tried Initialize mode to no avail. Any suggestions on what could be causing this?

Thanks!

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Unable to purge Project Detail

    Dear Stuart,

    Yes it should have set it to delete, if its only a warning. But it won't do that if its an "error" it may consider this an error because it thinks there are records. I'm speculating.

    But go to the Help file for that screen and look at Delete Project Detail Historical Purge -Error Conditions that block a purge

    Perhaps we should run a trace to see if we can catch exactly what its finding on that project.

    Best,

    Jana

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to purge Project Detail

    Good afternoon, Jana. Nice to see you.

    Yes, I did the query directly for both of the projects noted above. The current fiscal year is 2019 with a current period of 10-2019. All of the records in PJTran for these projects were less than 201910. These were both small projects so there weren't many transactions involved.

    As noted above, I checked the option to delete projects with warnings. Shouldn't that have set the flag to delete?

    Thanks!

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Unable to purge Project Detail

    Dear Stuart,

    What is the current fiscal year?

    Did you try the select directly to pull all the transactions? Order by fiscalno and see what we get.

    Best Regards,

    Jana MacDonald

    MSDSL Support

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans