Article Details
Id: | 16682 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 3.02.04 |
Opened: | 22/01/2020 |
Closed: | 23/01/2020 |
Released: | 11/02/2020 |
Job: | J023574 |
Purge; purging Service Logs may fail
Purging Service Logs may fail with the error "Failed to Purge Database. Failed to purge Service Logs. Failed to execute SQL. The record cannot be deleted or changed because table 'ISServiceLog' includes related records.".
This occurs where "Purge Service Logs flagged as purgeabe?" is checked and a child service log is purged before the parent service log.
Note, the Service Log purge function has been updated to firstly purge "failed" service logs first.