Issue Summary

When bulk archive objects in an Oracle database environment, the object will show as archived for a sec but back to not archived after reindex.

This is reproducible on Data Center: yes

Steps to Reproduce

1. Create object schema and objects
2. Go Object Schema view
3. Click on Bulk archive objects
4. Once bulk archive objects finished
5. Refresh the page, the objects archived might disappear
6. Go to reindex Assets
7. Once reindex finished, go the Object Schema view again

Expected Results

The archived objects shouldn't show up in Object Schema view as they are archived

Actual Results

The archived objects showed

The below exception is thrown in the xxxxxxx.log file:

2024-02-16 00:12:36,374+0000 insight-InsightThreadGroup-worker-thread-0 ERROR admin     [c.r.j.p.i.s.c.d.dao.sql.AbstractAOService] Error querying database:
java.sql.SQLException: Invalid column type
... 

Workaround

There is no workaround with this issue for users in Oracle databases.