Hello Folks;
I'm working on SAS Visual Investigator and after uploading a data and making it relationships after that, I'm doing the indexing of the data, indexing procedure is only running it's not getting complete or not getting kill by clearing it caches. Is there any other way to stop this indexing as it is taking a long time to get it complete and it is still in process.
Find the attached file.
Do the needful;
Regards and Thanks;
Deepak Chaudhary.
Hi,
The only way to stop the indexing job would be to restart the instance of the Datahub Service that the job is running on. If you have more than one instance of the Datahub Service running you should be able to tell from messages in the log which instance to restart.
Thanks,
Owain
For anyone reading this retrospectively - Job Cancellation was added in VI 10.8.
The API is here: http://swagger.na.sas.com/apis/svi-indexer/v2/redoc.html#tag/Job-Cancellation/operation/cancelJob.
Hello Craig,
I am currently facing difficulty stopping an Index Job, but I cannot access the API link you have provided to have a more detailed look about a solution.
Would you mind re-uploading another link for it?
Thanks in advance.
Hi there.
Have you stopped and started Datahub and/or SVI-index?
Is the index job stuck on "pending" / "running" ect?
You most likely need to check within postgres:
select job_id, *
from feature.job
order by started_at_dttm desc;
--VI Indexing Tasks table
select parent_id, name_nm, status_cd, message_txt , started_at_dttm, ended_at_dttm, *
from feature.task
where status_cd <> 'Completed'
order by status_cd;
If it i still "stuck" after the services reboot then you will need to change the stat of the index job.
-cancel job indexing from VI
update feature.job
set status_cd = 'Cancelled'
where job_id in ('value job_id');
-cancel VI indexing tasks
update feature.task
set status_cd = 'Cancelled'
where parent_id in ('value job_id');
Hi @adedja
Feel free to raise a Technical Support case and we can help you with your request, about cancelling an indexing job. I understand it might not be an issue you are currently experiencing but that might help you in the future.
And we might be able to share some advices about your indices and more.
Cheers, Damo
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.