Cleaning up the migration-center database manually by deleting the history of the scanners or importers can be tedious task depending on the number of scanner/importer runs. The task can be greatly facilitated by running a stored procedure on the database level.
First, install the stored procedure in the migration-center database:
Run the attached script (del_job_history.sql) in SqlPlus or SQL Developer connected as user FMEMC.
Second, run the script with the appropriate scanner/importer ID:
For deleting all runs of a scanner or importer, run the following command in SqlPlus or SQL Developer connected as FMEMC user (replace 1000 with your scanner/importer id):
exec del_adaptor_history(1000);
IMPORTANT NOTES:
The stored procedure will delete the complete history of the specified scanner or importer. So please use it with great care!
We strongly recommend to create a backup of the migration-center database before you execute this stored procedure!
Deleting a scanner history will delete all scanned objects that have been scanned by the specified scanner. The migset where those objects have been selected, will just be emptied but not deleted.
0 Comments