Content extraction using the Web Client does not work for .zvf and .mdb2 files - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

Problem

An error occurs when you use web client to extract content from documents to which 3D models .zvf and .mdb2 files are attached. The software displays the following error:

Unable to connect Access database with provided OleDB Provider

at SPF.Common.SPFException..ctor(Int32 pintClientNumber, Int32 pintServerNumber, String[] pstrParameters, Exception& pobjInnerException) in F:\A1\5\s\SPF\Common Projects\Common\SPF\Common\SPFException.vb:line 31

at SPF.Common.SPFException..ctor(Int32 pintClientNumber, Int32 pintServerNumber) in F:\A1\5\s\SPF\Common Projects\Common\SPF\Common\SPFException.vb:line 15

at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.ReadCategoryFromMDB(String pstrMDBFilePath, String pstrConnectionString) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 406

at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.ReadDataFromMDB(String pstrMDBFilePath, String pstrConnectionString) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 216

at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.GenerateXmlContentFile(String pstrFilePath) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 130

Content files generation failed

Solution

The error occurs because Microsoft.ACE.OLEDB.Provider.12.0 provider fails to connect to the Microsoft Access database engine installed on the SmartPlant Foundation application server. In order to avoid this error, we recommend you to:

  • Install Microsoft Access database engine 2010 (64-bit) instead of (32-bit) version on the SmartPlant Foundation application server.