Logged in to PSU this morning and found that I had a Health Check Failure, specifically the Groom Job.
Groom job failed. Refer to the log for more information
If it matters, the jobs it’s trying to remove is a scheduled script that runs every 10 minutes and calls other scripts with a tag (frequently 4 other scripts). Wondering if the nested jobs are introducing complexity in the removal.
Environment is installed on Windows Server 2022
2023-11-08 10:44:01.980 -06:00 [WRN] Failed to delete entity Job (6571)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
—> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: ‘FOREIGN KEY constraint failed’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
— End of inner exception stack trace —
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at PowerShellUniversal.SQLite.SqlTable`1.Delete(T item) in C:\actions-runner_work\universal\universal\src\PowerShellUniversal.SQLite\Database.cs:line 486
at UniversalAutomation.GroomService.DeleteEntity[T](T entity) in C:\actions-runner_work\universal\universal\src\Universal.Server\Services\GroomService.cs:line 282
Looking for a method on how to clear this up.
Product: PowerShell Universal
Version: 4.1.8