InstallCognos.ps1 fails to install jdbc driver "Could not load file or assemply 'file:///...\Support\Ionic.Zip.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)"

[#1]

Summary

InstallCognos.ps1 fails to installing jdbc driver with the error message "Could not load file or assemply 'file:///\Support\Ionic.Zip.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)"

Symptoms

Environment:

• FlexNet Manager Suite 2017 R3 or later
• Flexera Analytics (Cognos Analytics)

Silently installing Cognos Analytics via InstallCognos.ps1 fails with the following error:

PS C:\ProductMedia\FlexNet Manager Suite Installer\Support> .\InstallCognos.ps1
Generating answer files required for installation
Launching Cognos installation
Invoking Cognos installer (.\media\ca_srv_win64_11.0.6.17031315.exe) with generated answer file (C:\ProductMedia\FlexNet Manager Suite Installer 2017 R3\Support\Generated\installer.properties)
Installation completed successfully
Cognos installation completed successfully.
Installing FNMS authentication components and web content.
Copying prerequisites for Cognos configuration
Installing jdbc driver...
Expand-IonicArchive : Exception calling "LoadFrom" with "1" argument(s): "Could not load file or assembly 'file:///C:\ProductMedia\FlexNet Manager Suite Installer\Support\Ionic.Zip.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)"
At C:\ProductMedia\FlexNet Manager Suite Installer\Support\modules\ConfigureCognos.psm1:55 char:2
+ Expand-IonicArchive $driverArchivePath $MediaBasePath
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Expand-IonicArchive], MethodInvocationException
+ FullyQualifiedErrorId : FileLoadException,Expand-IonicArchive

Cause

Loading Ionic.Zip.dll from 'file:///C:\ProductMedia\FlexNet Manager Suite Installer\Support\Ionic.Zip.dll' is blocked because the URL is treated as a 'remote' location that is not fully trusted.

Workaround

1. Copy Support\Ionic.Zip.dll file to a temporary folder.
2. Compress Ionic.Zip.dll in the temporary folder to Ionic.Zip.dll.zip.
3. Delete Support\Ionic.Zip.dll file, you may need to close the PowerShell window.
4. Uncompress Ionic.Zip.dll.zip and copy uncompressed Ionic.Zip.dll to Support folder.
5. Run the InstallCognos.ps1 again.

Additional Information

https://answers.microsoft.com/en-us/windows/forum/windows_7-security/clicking-on-unblock-for-a-files...

[austinraun]

For a quick and easy solution, we've had consistent success with the following: https://community.flexera.com/t5/FlexNet-Manager-Forum/Invoke-Expression-Exception-calling-quot-Load...

[stefange]

Hi,

Other solution would be to run the unblock-file command in Powershell for the ionic.zip.dll

Stefan