Inform Adapter/ ODM "ORA-00942: Table or View Does not Exist" Error (Doc ID 1513859.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

An attempt to download data through the Inform Adapter ODM Interface results in the following response:

 Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx,    OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at PhaseForward.Platform.Storage.Providers.CommandProxy.System.Data.IDbCommand.ExecuteReader() in E:\ICEPlatform\AppServer\Storage\Providers\CommandProxy.cs:line 49
   at PhaseForward.Platform.Storage.DBProvider.ExecuteReader(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 1069.  DB Command Text : select /*+ FIRST_ROWS(500) */ externalguid, x.xmlnode.GETCLOBVAL() from pfex_transactionxml x
                                      where xmlid in (select /*+ FIRST_ROWS(500) */ xmlid from
                                         (SELECT  /*+ FIRST_ROWS(500) */ rownum, xmlid FROM pfex_transactionxml x where xmlid > :xmlId order by xmlid)
                                         where rownum <= :transactionCount)
                                         order by xmlid. ---> ORA-00942: table or view does not exist

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.