Setting EnsLib.SQL.Snapshot = "" vs EnsLib.SQL.Snapshot.Clean()
In tracking down some of our Orphaned message issues, I was wondering if setting our EnsLib.SQL.Snapshot variable equal to "" was the same as calling the .Clean() method on EnsLib.SQL.Snapshot? Are they the same?
should I be possibly using ##class(EnsLib.SQL.Snapshot).%Delete() instead?
$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2U) Tue Apr 30 2024 16:06:39 EDT [HealthConnect:7.2.0-1.r1]
Discussion (2)1
Comments
Hello Scott,
we are also having issues with orphaned messages. I tried this Clean(), %Delete() but didnt work.
When I tried the %OnDelete(object.%Oid()), this cleared the data but visual trace/message viewer also lost the data which is issue with debugging.
Let me know if you find any solution for this.
I ended up putting statements into my BP that set the EnsLib.SQL.Snapshot variable = "" after use.