PPM Database Connect Error - ORA-00942: Table Or View Does Not Exist

(Doc ID 1348490.1)

Last updated on NOVEMBER 15, 2016

Applies to:

Primavera Portfolio Management - Version 8.0 SP2 and later
Information in this document applies to any platform.
Checked for relevance on 11-May-2015

Symptoms

PPM 8.0 SP2 version, Setup Module

When attempting to connect PPM Console with Oracle database, the following error occurs.

ERROR
************** Exception Text **************
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.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,

CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at ProSight.Portfolios.Infrastructure.Database.psCommand.fillDataTable(IDbDataAdapter da, DataSet ds, Int32 iTableIndex, String iTableName)
at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataTableAddToDataSet(DataSet iDataSet, String iNewTableName, Int32 iTableIndex)
at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataTable()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psPropertiesObj.getDBUniqueID()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psUtilityObj.localServerIsBackEnd()
at psConsoleNew.psConsoleFlows.setLocalServerToBackEnd(psConnectionString iConnStr)
at psConsoleNew.psConsoleFlows.makeDBCurrent(psDatabaseItem iDB, psDatabaseList iDatabaseList)
at psConsoleNew.psConsole.btnMakeCurrent_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
psConsole
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase: file:///D:/Program%20Files/Primavera/ProSight/Portfolios/bin/psConsole.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3620 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
ProSight.Portfolios.Infrastructure
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/ProSight.Portfolios.Infrastructure/8.0.8456.0__94b68c3bc79486b2/ProSight.Portfolios.Infrastructure.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Oracle.DataAccess
Assembly Version: 2.102.4.0
Win32 Version: 2.102.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Oracle.DataAccess/2.102.4.0__89b483f429c47342/Oracle.DataAccess.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
ProSight.Portfolios.Application.Infrastructure
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/ProSight.Portfolios.Application.Infrastructure/8.0.8456.0__08fdd40588b17387/ProSight.Portfolios.Application.Infra

structure.dll
----------------------------------------
ProSight.Portfolios.BusinessLogic.Infrastructure
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/ProSight.Portfolios.BusinessLogic.Infrastructure/8.0.8456.0__30cecc1a7ea81843/ProSight.Portfolios.BusinessLogic.I

nfrastructure.dll
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.DirectoryServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
ProSight.Portfolios.BusinessLogic.TS
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/ProSight.Portfolios.BusinessLogic.TS/8.0.8456.0__7dab73bf302c45be/ProSight.Portfolios.BusinessLogic.TS.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3618 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
ProSight.Portfolios.Application.psUpgradeDB
Assembly Version: 8.0.8456.0
Win32 Version: 8.0.8456.0
CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/ProSight.Portfolios.Application.psUpgradeDB/8.0.8456.0__e860200f99df215c/ProSight.Portfolios.Application.psUpgrad

eDB.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are unable to make cloned database the 'Current Database' in the PPM Console.

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