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

Last updated on JULY 08, 2014

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.3.5 and later
Information in this document applies to any platform.

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

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