When trying to run:
delete IdentityRequest *
I get an error of
sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.items
select * from spt_identity_request_item where id is null; returns no results.
I'm reaching for straws and have attempted to repair the table, in case that is what is causing the issue. The table types they use for their db is innodb. sailpoint
repair table spt_identity_request_item; yields a note of
The storage engine for the table doesn't support repair
I've also tried the command:
sudo mysqlcheck --repair --databases identityiq -u identityiq -p
While it runs, it gives a bunch of notes of:
note : The storage engine for the table doesn't support repair
Is this command actually doing something to repair the issues? If not, is there a way to repair this and how?