Hi, I'm opening a new post on this problem I had. Our backup is going bad from some times, I've a support call opened but it seems that it takes ages to get an answer so I'm trying on the forum to see If I'm a bit more lucky here
I've manually replicated the procedure that backup do to get the real error message (it's not in the log so it seems difficult to understand why backup are getting wrong).
Being able to do the validate table on the manually copied and started up database i get this erro:
VALIDATE TABLE "DFM"."hsNotifications"
Primary key for "hsNotifications" has missing index entries
Foreign key "hostServiceId" has missing index entries
SQL error (-300) -- Run time SQL error -- Validation of table "hsNotifications" has failed
It seems that I should only need to recreate or correct those 2 tables.
I'm almost sure the problem was with some older data inside those table related to when I had onCommand Host 1.0 on a server that is no more inside dfm (it uninstalled not in a really good way).
The real problem is that there's no dfm hs delete -f so I'm not able to delete those stale entry.
THose are the dfm hs list, dfm hs list -a, dfm hs list -av. As you can see there are 2 hosts that are still inside the tables but that I've no way to remove and I'm sure the problem is there.