D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AX 2012 R3 Clean up

  • 1.  AX 2012 R3 Clean up

    Posted 14 days ago
    looking for some info on TMSTransaction table clean up options. , this is one of our larger tables,  struggling to find some info on how to
    clean it up , thanks,

    ------------------------------
    Bill Fuller
    Mgr. System Administration Team

    Allegion Information Technology
    11819 North Pennsylvania St
    Carmel, IN 46032
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: AX 2012 R3 Clean up

    Posted 13 days ago
    Hi Bill,

    Have you tried the 'Transaction purge' option under Transportation management - Periodic tasks?  That should allow you to specify how many days of information you would like to keep while removing the rest.  Naturally, i would recommend validating this in a Dev / Test environment.

    ------------------------------
    Michael Sigler
    Rangeline Solutions
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: AX 2012 R3 Clean up

    Posted 13 days ago
    Thanks Michael   , Found it . !   will give this a try and do some testing  ..

    ------------------------------
    Bill Fuller
    Mgr. System Administration Team

    Allegion Information Technology
    11819 North Pennsylvania St
    Carmel, IN 46032
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: AX 2012 R3 Clean up

    TOP CONTRIBUTOR
    Posted 13 days ago

    Hi Bill -

    TMSTransaction table contains transportation transactions for historical purposes.

    We do have an option to delete the records on this table. See, Transportation management > Periodic > Transaction purge. The periodic routine will delete all the records if you are running with parameter Days = 0. Days is the number of days of transaction data to keep.

    As with any of these cleanups, best to test first and understand everything the process is doing. SQL Profiler filtering by Deletes is great way to evaluate.

    I ran a quick test and only one statement was the result.

    DELETE FROM TMSTRANSACTION WHERE (((PARTITION=@P1) AND (DATAAREAID=@P2)) AND (MODIFIEDDATETIME<@P3))

    Thanks.....Dave



    ------------------------------
    Dave Phillips
    Sr Support Escalation Engineer
    Microsoft
    Fargo ND
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: AX 2012 R3 Clean up

    Posted 13 days ago
    Thank you , Dave     Appreciate the help, will give this a try and do some testing ..

    ------------------------------
    Bill Fuller
    Mgr. System Administration Team

    Allegion Information Technology
    11819 North Pennsylvania St
    Carmel, IN 46032
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role