'Refresh Source Terms Mat. Views' job completes with 'FAILURE' status (due to 'ORA-12048' / 'ORA-12034' errors)
(Doc ID 2625885.1)
Last updated on NOVEMBER 01, 2023
Applies to:
Oracle Thesaurus Management System - Version 5.2.1 and laterInformation in this document applies to any platform.
Symptoms
1)
'TMS: Definition > Jobs > Refresh Source Terms Mat. Views' completes with 'FAILURE' status.
2)
The following errors are returned when running 'tms_user_synchronization.RefreshMviews' in SQLPLUS when logged on as the same TMS application user (equivalent to running the 'Refresh Source Terms Mat. Views' job):
Error starting at line : 1 in command -
BEGIN tms_user_synchronization.RefreshMviews; END;
Error report -
ORA-12048: error encountered while refreshing materialized view "TMS"."TMS_USER_SOURCE_EXT_V1"
ORA-12034: materialized view log on "TMS"."TMS_SOURCE_TERMS" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at "TMS.TMS_USER_SYNCHRONIZATION", line 1799
ORA-06512: at line 1
12048. 00000 - "error encountered while refreshing materialized view \"%s\".\"%s\""
*Cause: Some problem occurs during refresh of multiple materialized views in
atomic mode. The materialized view whose refresh failed has raised
this error.
*Action: Examine the other messages on the stack to find the refresh problem.
BEGIN tms_user_synchronization.RefreshMviews; END;
Error report -
ORA-12048: error encountered while refreshing materialized view "TMS"."TMS_USER_SOURCE_EXT_V1"
ORA-12034: materialized view log on "TMS"."TMS_SOURCE_TERMS" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at "TMS.TMS_USER_SYNCHRONIZATION", line 1799
ORA-06512: at line 1
12048. 00000 - "error encountered while refreshing materialized view \"%s\".\"%s\""
*Cause: Some problem occurs during refresh of multiple materialized views in
atomic mode. The materialized view whose refresh failed has raised
this error.
*Action: Examine the other messages on the stack to find the refresh problem.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |