Other users unable to open dxp, Oracle access error

[Mason Taylor]

Error message: Unable to read the file XXXXXXXXXXXX.dxp.

TargetInvocationException at Spotfire.Dxp.Framework:

Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:

at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)

at Spotfire.Dxp.Forms.Application.FormsApplicationThread.ExecutePromptingOperation(String title, String description, PromptingApplicationInvocation promptingApplicationInvocation)

at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings)

at Spotfire.Dxp.Main.Program.c__DisplayClass14.b__13(LoadCallbackParameters parameters)

at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters, Form owningForm)

 

SerializationException at Spotfire.Dxp.Data:

Failed to load the data access plan. (HRESULT: 8013150C)

Stack Trace:

at Spotfire.Dxp.Data.Access.Loader.DataArchiveReaderWriter.Read(ServiceRegistry serviceRegistry, ZipReader zipReader, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

at Spotfire.Dxp.Application.AnalysisApplication.DataAccessFileContributor.OnReadFromDxp(ZipReader zipReader, DocumentNode document, LibraryEntryRedirector libraryEntryRedirector)

at Spotfire.Dxp.Framework.Persistence.DxpFileContributorRegistry.OnReadFromDxp(ZipReader zipReader, DocumentNode document, LibraryEntryRedirector libraryEntryRedirector)

at Spotfire.Dxp.Framework.Persistence.DxpDocumentFileReader.LoadDocument(Stream docStream, List`1 trustedScriptHashes, PersistenceManager persistenceManager, IServiceProvider serviceProvider, Int32 supportedVersionIndex)

at Spotfire.Dxp.Framework.Persistence.DxpDocumentFileReader.DxpDocumentFile.GetDocument(IServiceProvider serviceProvider)

at Spotfire.Dxp.Application.AnalysisApplication.d__f.MoveNext()

at Spotfire.Dxp.Forms.Application.FormsApplicationThread.c__DisplayClass1.b__0()

at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

 

FileNotFoundException at Spotfire.Dxp.Data.Adapters.Oracle:

Could not load file or assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=XXXXXXXXXXXXX' or one of its dependencies. The system cannot find the file specified. (HRESULT: 80070002)

Stack Trace:

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterSchemaInfo..ctor(XmlElement element)

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterFactory.DeserializeCustomAdapterInfo(XmlElement adapterElement)

at Spotfire.Dxp.Data.Access.AdapterDataSchema..ctor(XmlElement element, DataAdapterFactory factory)

at Spotfire.Dxp.Data.Access.Modeling.DataConnectionModelling..ctor(XmlElement element, DataAdapterFactory factory, DataAdapterTypeIdentifier typeIdentifier, Boolean supportsIterativeSchemaLoading)

at Spotfire.Dxp.Data.Access.Modeling.DataConnectionLink..ctor(XmlElement element, GlobalDataAdapterRegistry globalDataAdapterRegistry, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

at Spotfire.Dxp.Data.Access.Modeling.DataConnection..ctor(XmlElement element, GlobalDataAdapterRegistry globalDataAdapterRegistry, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

at Spotfire.Dxp.Data.Access.Modeling.DataAccessPlan..ctor(XmlElement element, GlobalDataAdapterRegistry globalDataAdapterRegistry, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

at Spotfire.Dxp.Data.Access.Modeling.DataAccessPlan.Load(Stream stream, GlobalDataAdapterRegistry globalDataAdapterRegistry, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

at Spotfire.Dxp.Data.Access.Loader.DataArchiveReaderWriter.Read(ServiceRegistry serviceRegistry, ZipReader zipReader, LibraryEntryRedirector libraryEntryRedirector, DataAccessClient dataAccessClient)

[Harshith Reddy Musku]

Hello,

This seems to be a driver compatibility issue. What version of ODAC is installed on respective users machines Compare with version on the machine where you can open this dxp. Uninstall and install that version of ODAC if different https://www.oracle.com/technetwork/database/windows/downloads/index-0901.... Also here are some web links on this that mighthelp.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/de7a8d25-095f-459...

https://stackoverflow.com/questions/15293975/could-not-load-file-or-asse...