Precisely Enterworks

 View Only

  • 1.  Mass Delete

    Posted 03-26-2021 12:51
    We need to delete all the records from a repo (in the millions) and the usual 'delete all' command is progressing very slowly. Is there a faster way of doing this, given we're deleting all records? Is deleting records from B_MASTER_REPOSITORY_ITEM faster/safe to do?

    Thanks!

    ------------------------------
    Sidd Shenoy | Sr Dir Enterprise Master Data
    Thomson Reuters Corporation | (646) 540-2371
    ------------------------------


  • 2.  RE: Mass Delete
    Best Answer

    Employee
    Posted 03-27-2021 04:42
    Sidd,

    If you don't need to capture the deletions in the history table, then a faster way to clear a repository is to use the CreateDataCleanCommands.sql script that can be found in the Services Framework deployment folder.  This script will generate the SQL commands to remove records directly from each of the EnterWorks tables for each of the specified repositories.  The script includes instructions as comments on how to use it.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 9099009179
    ------------------------------



  • 3.  RE: Mass Delete

    Posted 03-28-2021 11:19
    You're the man, Brian! Worked like a charm. Thanks!

    ------------------------------
    Sidd Shenoy | Sr Dir Enterprise Master Data
    Thomson Reuters Corporation | (646) 540-2371
    ------------------------------

    Original Message