IIQ 8.4
NA
NA
*The SQL Query for SPT_TASK_RESULT results into zero rows to get the last execution and status of the “*Full Text Index Refresh” task
By default, Previous Result Action has a value of Delete for the Full Text Index Refresh task. Make it to Rename Old or Rename New. After that, you will be able to see the history of these tasks in the Task Results page.
Hi Manish,
Thanks for your response. I checked and we have set the value to “Rename Old”.
Any pointers of the SQL as well will be helpful. The use case is when I make any updates to a Role, it’s not clear how long will it take to reflect. In certain scenarios the need is immediate and hence if there is a way to determine when the task will run next or when it last executed along with run status it will make things more manageable.
Regards,
Nilesh
Schedule “Full Text Index Refresh“ task to run at a regular interval. In this way, you have an idea when it is running.
3-4 Times daily scheduling can be done.
In order to check the last run of a task, you can utilize SailPoint IIQ APIs to retrieve the time.
The challenge is that since the task result for the Task “Full Text Index Refresh” is not visible on the UI and the database, I am not sure if this information is available in SailPoint IIQ to retrieve it via APIs as well.
The scheduled run time makes the overall experience cumbersome for a globally distributed team.
Regards,
Nilesh
This task does not run automatically. So, how are you planning to run this task.
I did more debugging an understood that the “FullText Refresh” is a Service Definition and is scheduled to run in an automatic fashion. The interval can be configured. However the question still remains on how to determine when the task was last executed in a successful fashion.
Moving on, the base reason behind determining when the Full Text Refresh was last executed and if it ran successfully was to determine if by when the new role which I have created or if I have made an existing role requestable=true, will be reflected in the Access Request catalog.
I stumbled upon the blog post Programmatically Adding a Single Role to the Full Text Index in IIQ which helps control how and when I want the Text refresh to be executed. Also it seems I can control the roles which need refresh which would better the performance in my opinion.
Wanted to know if anyone has tried using this approach and what were the findings.
Thank you
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
