Announcement

Collapse
No announcement yet.

Need Help in OTM Purging

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need Help in OTM Purging

    Hi Gurus,

    I am new to this OTM Purging and Archival and I need to Purge the business objects in OTM like ORDER BASE,ORDER RELEASE,SHIPMENT,SELL SIDE SHIPMENT,ITEM and INVOICE.

    I knew the front end navigation where I can mark these objects for Purge but I need your expert advice in creating the Saved Queries for these objects.

    Kindly share your ideas and please share the sample saved queries for the above.

    Regards,
    Muzaffar

  • #2
    Re: Need Help in OTM Purging

    Hi Muzaffar,

    Mentioned tables does not have much size at database level

    Transmission and Transaction related XML BLOB data consumes lot of space at database end

    To purge XML BLOB transmissions/transactions you can refer 'Manually Purging Transmissions from the Database' segment in OTM Administration Guide

    If you have any problem in this process then, please let us know

    Also, you can refer, http://www.otmfaq.com/forums/f21/pur...rocesses-8077/


    Thank you


    -Prasad-
    Last edited by Prasad Chandane; October 13, 2014, 13:52.
    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: [email protected]

    If my post was helpful, then click on the Like button

    Comment


    • #3
      Hi All,

      Is there a way of sending notifications or setting some alerts for purge completion.

      Comment


      • #4
        Hello,

        You may create a simple shell script that checks the status of purging in the DATA_PURGE_HISTORY table and once it shows COMPLETED then, it will send an email via multiple utilities e.g. sendmail, mail etc.

        PS: Frequency can be changed in crontab as per your schedule purge


        -Prasad
        Let's connect on LinkedIn
        Mobile: +91 973 049 6886
        E-mail: [email protected]

        If my post was helpful, then click on the Like button

        Comment

        Working...
        X