Unifier (MOSC)

MOSC Banner

Unifier_i18n_scan_custom_strings_## Job fires constantly and causes HOGGING then STUCK threads in We

edited Aug 8, 2020 12:07PM in Unifier (MOSC) 4 commentsAnswered

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 = ?) );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center