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

Can you please specify in which of your version you want to delete your test records?

Identity Manager 8.1

Identity Manager 8.1

Take a look at the stored procedure QER_PPersonDelete_GDPR to delete your persons including all related data.

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?