My Oracle Support Banner

CD Installation fails with error "ORA-00942: table or view does not exist" (Doc ID 2065845.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Central Designer - Version 2.1.1.1 and later
Information in this document applies to any platform.

Symptoms

User is upgrading version of Central Designer.

Installation fails, error message states to review installer.log

Installer.log provides:

Performing Installation Operations... ***=== Installer Started 10/7/2015 12:38:22 PM  ===*** bin directory is <Install Dir>\Oracle Health Sciences\Central Designer\Bin\ input=<company> output=<company> input=<company url> output=<company url> Setting up IIS directories ... 10/7/2015 12:38:24 PM : Configuring IIS ASP.NET Version - APPPOOL object "DefaultAppPool" changed 10/7/2015 12:38:25 PM : Configuring IIS ASP.NET Version - APPPOOL object "DefaultAppPool" changed Setting up IIS directories -- Success Creating encryption key and initialization vector ... Creating encryption key and initialization vector -- Success Setting Configuration Information ... Setting Configuration Information -- Success Setting database configuration ... Program Args: Oracle.Designer.DesignerInstallerWin.exe CONFIG;//DEBUGME;FP=C:\Users\<username>\AppData\Local\Temp\2\{<GUID>}\InstallParameters.txt;MA=<MachineName>;LO=<Logfile>;MU=<Web server root>;TA=<Tablespace>;TL=<Index Tablespace>;TE=<Temp Tablespace>;PN=53000;CN=<company>;CU=<company url>;UU=<web server root>;<...other...>;<...parameters...>;<...>;<...> 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, Boolean bCheck)    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)    at PhaseForward.Designer.Installer.InstallerTasks.ReadSystemSettingsValue(String propertyName, DatabaseOptions options, Boolean throwOnFail) in c:\ICEDesigner\Server\DesignerInstaller\DesignerInstaller.cs:line 1962    at PhaseForward.Designer.Installer.InstallerTasks.ConvertOldDesignerSchemaVesionToNewIcrementalSchemaVersion(Logger logger, DatabaseOptions options) in c:\ICEDesigner\Server\DesignerInstaller\DesignerInstaller.cs:line 361    at PhaseForward.Designer.Installer.InstallerTasks.UpdateDBParams(UInt32 startingStep, Logger logger, DatabaseOptions options, InstallDirectories dirs, String jobSchedulerUserPassword) in c:\ICEDesigner\Server\DesignerInstaller\DesignerInstaller.cs:line 2272    at PhaseForward.Designer.Installer.InstallerTasks.DoTasks(Logger logger, InstallerArgs args) in c:\ICEDesigner\Server\DesignerInstaller\DesignerInstaller.cs:line 726    at PhaseForward.Designer.Installer.DesignerInstallerCore.InstallHelper(String[] args, RunningMode runningMode) in c:\ICEDesigner\Server\DesignerInstaller\DesignerInstaller.cs:line 86  

 

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

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