My Oracle Support Banner

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

Last updated on OCTOBER 03, 2017

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

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
References


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