Can't Delete Enrollments When Attempts Exist
Why does one get the error "you cannot delete class because there are attempts against this class" when attempting to deleting a class?
Content attempts are a lower level of of detail, subordinate to the class catalog object. Once a learner "plays" content and a row is inserted into the "Attempts" table, the current OLM architecture prevents the catalog object from being deleted. A history will be maintained of the learning for data integrity purposes.
We can use below data Fix
select * from ota_activity_versions
where version_name like 'SkillSoft Books 24 X 7';-- course
select * from ota_events
where activity_version_id=94037;-- class
select * from OTA_OFFERINGS
where activity_version_id=94037;-- offering
select * from OTA_DELEGATE_BOOKINGS
select * from ota_performances
where learning_object_id=97018; -- contains test results
select * from ota_attempts
delete from ota_attempts
delete from ota_performances