Cannot Save Data or Create Objects - Error: Failed to Load OracleFactory (Doc ID 1367479.1)

Last updated on APRIL 29, 2016

Applies to:

Primavera Portfolio Management - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.
Checked for relevance on 05-Nov-2013

Symptoms

On : PPM 9.0 version, when attempting to save objects (alerts, portfolios...), the object is not created and errors appear in the Prosight.log(s).

Example 1:

ERROR
-----------------------
Version: 9.0.9139
File name: /prosight/portfolio/pfpropsSave.aspx
Stack trace: at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.handleException(Exception iEx, String iAddionalMsg)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTSIPortfolio.wizardSaveNew(Int32 iUserID, Int32 iSecurityContainerType, Int32 iSecurityContainerID, psResultContainer iParam, psResultContainer oResults)
at ASP.portfolio_pfpropssave_aspx.main()
Error code: -1
Error Reason: Object reference not set to an instance of an object.

Example 2:

ERROR
-----------------------
From Prosight.log(s) on Front and Backend PPM Servers:

<Trace Type="Error" Time="9/21/2011 10:52:41.682" Class="psOracleFactory" Method=".cctor" Process="psConsole.exe (3812)" Client="">
failed to load oracleFactory:
<Exception>
System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342'
at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef)
at ProSight.Portfolios.Infrastructure.Database.psOracleFactory.init()
at ProSight.Portfolios.Infrastructure.Database.psOracleFactory..cctor()
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</Exception>
</Trace>


STEPS
-----------------------
The issue can be reproduced at will by attempting to create a PPM object (alert, portfolio...).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are not able to create objects that are part of normal business processes.

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