When Attempting To Mask Database Getting the Following Errors: ORA-12008: error in materialized view refresh path and ORA-01013: user requested cancel of current operation
(Doc ID 2248362.1)
Last updated on AUGUST 25, 2020
Applies to:
Oracle Agile PLM for Process Feature Pack - Version 3.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to mask database getting error
Error 1/31/2017 5:52:40 PM - Xeno.Data.DataAccessException: Update specsummaryname Set Name = 'SpecName' ---> Oracle.DataAccess.Client.OracleException: ORA-12008: error in materialized view refresh path
ORA-01013: user requested cancel of current operation
ERROR
-----------------------
table = specsummaryname
Error 1/31/2017 5:52:40 PM - Xeno.Data.DataAccessException: Update specsummaryname Set Name = 'SpecName' ---> Oracle.DataAccess.Client.OracleException: ORA-12008: error in materialized view refresh path
ORA-01013: user requested cancel of current operation
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Xeno.Data.XDataQueryIsolated.executeNonQuery(String statement)
--- End of inner exception stack trace ---
at Xeno.Data.XDataQueryIsolated.executeNonQuery(String statement)
at DataMask.MaskManager.doQuery(String sql) in c:\TeamCity\BuildAgent\work\4e892a3c092e4535\Code\Apps\DataMaskUtil\DataMask\MaskManager.cs:line 268
Records Updated No Exclusions = 0
Records Updated With Exclusions = 0
table = gsmShortNameML
Error 1/31/2017 5:53:40 PM - Xeno.Data.DataAccessException: Update gsmShortNameML Set Name = 'SpecShortName' ---> Oracle.DataAccess.Client.OracleException: ORA-12008: error in materialized view refresh path
ORA-01013: user requested cancel of current operation
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Xeno.Data.XDataQueryIsolated.executeNonQuery(String statement)
--- End of inner exception stack trace ---
at Xeno.Data.XDataQueryIsolated.executeNonQuery(String statement)
at DataMask.MaskManager.doQuery(String sql) in c:\TeamCity\BuildAgent\work\4e892a3c092e4535\Code\Apps\DataMaskUtil\DataMask\MaskManager.cs:line 268
Records Updated No Exclusions = 0
Records Updated With Exclusions = 0
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 |
Cause |
Solution |
References |