Unifier_i18n_scan_custom_strings_## Job fires constantly and causes HOGGING then STUCK threads in We
We are on premise and I have noticed after our upgrade from 18.8 to 19.12.6 that a certain job gets fired a lot and seems to hog resources in Unifier. The job title leads me to believe that it is for Internationalization, but the select statement for the job has nothing to do with Internationalization. Here is the query that the job runs ALL OF THE TIME.
What is this for and is it really necessary to run constantly?
SELECT id, report_source, report_name, report_desc, report_type, access_type, company_id, project_id, created_by, created_date, unifier_version, last_modified_by, last_modified_date, send_email, send_email_multiple, frequency, runday, month_date, todo, end_date, type, output_format, integration, session_id, content, database_checked, database_locked, database_tablename, database_columnmap, bundle_tag, bundle_date, default_tz, saved_result, save_to_dms, save_filename, location FROM sys_user_report user_report where company_id = ? OR (company_id = 0 AND project_id IN (SELECT project_id FROM unifier_project_info_view project_info_view where companyid = ?) );