Best way to purge person table that will include all associated tables

I am in the process of migrating our 6.3 IAM product to 8.1, but after making significant schema mods to the person table and I want to clean out the 300 test records.

Is there  away to do this as a batch process so that I can ensure that all associated table's records will get cleared out as well. I know about the Delete feature in Object Browser I was hoping there was a straight SQL route.

Thanks

Parents Reply Children
  • Executing this QER_PPersonDelete_GDPR takes about few minutes and then throws an error. It only removes the entry from Person table but kept the records in other tables

    Msg 266, Level 16, State 2, Procedure QER_PPersonDelete_GDPR, Line 64
    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
    Msg 3998, Level 16, State 1, Line 1
    Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
    Msg 50000, Level 18, State 1, Line 67
    error(s) detected, select dbo.QBM_FGISessionErrorForLog() to see details
    Total execution time: 00:05:06.681

     

  • How and where did you execute the SQL procedure?

    What version are you using?