Zurück
-
Titel
After a schema extension, "Enable Constraints 2" or "Disable Constraints 2" is "stuck" in DBQueue -
Beschreibung
After a schema extension the tasks "Enable Constraints 2" or "Disable Constraints 2" are "stuck" in DBQueue, i.e.not processing. -
Ursache
Database inconsistency -
Lösung
1. Restore the One Identity database from the backup taken before the schema change
OR
2. Repair the inconsistencies using the following Data Consistency Checks:- Content/DynamicFKInvalid/Okject keys or FK invalid
- Configuration/Dynamic FK
- Content/consistency
- Database Model/Relationships
For more information, please refer to the Operational Guide, Checking data consistency.
When the repairs are complete, enable constraints again using the following:
EXEC QBM_PTriggerEnable '%'
EXEC QBM_PConstraintEnable '%' -
Änderungsanforderung
30447/30573/30626