BPM, Workflow, and Case

 View Only
  • 1.  Snapshots Deletion

    Posted Mon May 06, 2024 09:37 PM

    Is there any column that specifies the snapshot is the first snapshot of the branch in below tables?

    LSW_BRANCH,lsw_snapshot, lsw_project 

    We are trying to automate the deletion of archived snapshot and constantly running into below command failure. 

     BPMSnapshotCleanup failed due to: The first snapshot in the branch can not be deleted.



    ------------------------------
    Harish Puli
    ------------------------------


  • 2.  RE: Snapshots Deletion

    IBM Champion
    Posted Tue May 07, 2024 01:01 AM

    Hi Harish,

    It's the BASE_SNAPSHOT_ID in the LSW_BRANCH table.

    Thanks!



    ------------------------------
    Atanu Roy
    Lead Engineer
    London Stock Exchange Group
    ------------------------------



  • 3.  RE: Snapshots Deletion

    Posted Tue May 07, 2024 09:47 PM

    Thank you Atanu Roy!



    ------------------------------
    Harish Puli
    ------------------------------



  • 4.  RE: Snapshots Deletion

    IBM Champion
    Posted Tue May 14, 2024 02:07 AM

    Hi Harish,

    We generally avoid having to query the main IBM BPM tables. Maybe you can use 

    -deleteArchivedSnapshot true|false 

    so you're only deleting archived snapshots? 

    Hope this helps

    Thanks



    ------------------------------
    Thong Huynh
    Sydney NSW
    ------------------------------