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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Mass Delete/purge Inte...
Microsoft Dynamics GP (Archived)

Mass Delete/purge Integration Manager Logs

(0) ShareShare
ReportReport
Posted on by WindyCityGP 1,069

Is there a way to mass delete/purge the logs in Integration Manager?  It doesn't appear as though the multi-select works in the Integration Logs window (View>>Integration Logs in IM).

Thank you.

*This post is locked for comments

I have the same question (0)
  • 26P2ER Profile Picture
    26P2ER 1,775 on at

    Hello WindyCityGP (Are you based in Chicago?)

    To the best of my knowledge this is supposed to work one integration at a time. I just tried this out in GP 2010 SP1 and it worked for me.

    Best of luck,

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at

    Hi Ven,

    You are correct, I am in Chicago :) .  I couldn't find a mass delete so I went ahead manually deleted 1,000+ logs.

  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Integration Manager's IMD file happens to be a Microsoft Access database. Here's what you can do to clear the logs table:

    1) Backup your IMD file

    2) Copy/Paste it as a different file

    3) Rename the copied file, i.e., if your IMD file name is IntegrationManager - Copy.IMD, you can rename to IntegrationManager.MDB

    4) Open the MDB file with Microsoft Access

    5) Locate the Logs table, right click and select Open

    6) Highlight and remove the records in the file

    7) Repeat step 5 for the LogDocuments, LogDocumentActivity, and LogActivity tables

    8) Click on File, then select the Compact and Repair option

    9) Go to File > Close

    10) Rename your MDB file back to IMD. NOTE: save off your backup copy (original) taken in step 1 before renaming file back to IMD.

    You should now see all the logs gone.

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at

    Hi Mariano,

    Unfortunately, I do not have Microsoft Access, but have no doubt your solution would work.  After manually deleting a year's worth of logs, for kicks I created a new .imd file and imported all my integrations into that one.  Of course, all the logs were gone, plus it reduced the size of my .imd file by 25MB.

    Thank you. 

  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Now I feel silly! In order to purge an integration log, open the integration, right-click on name of the integration and select Properties. Click on the Logs tab, then click the Purge button.

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at

    I was looking for a way to do a mass purge/delete since you can't multi-select in any of the Log windows, but it doesn't sound as if there is unless you have MS Access.

  • Verified answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    I guess I didn't make myself clear. Purge IS native to IM. Just right-click on the integration, select Properties, then go to the Logs tab. You will see a Purge... button.

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at

    Thanks for the clarification.  If you do not highlight any of the logs and click on Purge, IM will present "Purge ALL Integration Logs for this Integration?" message.  If you have 1 log highlighted and click on Purge, the message will be "Purge 1 Selected Integration Log(s) for this Integration?".

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans