Problem
The ingestion job is stuck on file copy step. We want to forcefully skip these files.
Resolution
Please make sure you have identified these files as junk files or the files you do not want at all. Then you can run the following update statement.
The first statement will keep a backup record for the files whose copy completed status has not been completed.
The second statement will mark the those files as copied, even if they have not been copied.
begin transaction
select * into tbl_ig_MediaCopyStatus_bckup from tbl_ig_MediaCopyStatus
where mediaid=<give your media id> and copycompleted<>1 --media id found in tbl_ex_media
update tbl_ig_MediaCopyStatus set copycompleted= 1 where mediaid=<give your media id> and copycompleted<>1
commit
Remember, manipulating database records should be done with extreme caution. Always ensure you have backups and consider the potential impacts on your system before proceeding. If you're not comfortable with these operations, consider reaching out to a database administrator or an expert in your team.
Comments
0 comments
Please sign in to leave a comment.