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 MARCH 27, 2017

Applies to:

Oracle Agile PLM for Process Feature Pack - Version 3.0 and later
Information 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms