Oracle Communities

Oracle Analytics and AI

Child Item

Errors uploading any excel spreadsheet in OAS 7.6

We are currently on OAS 7.0 and are testing the newer OAS 7.6 version in one of our test environments. We have been having issues with uploading any excel spreadsheets in OAS 7.6. Below is the query error we see whenever we upload any excel spreadsheet. Has anyone else experienced similar issues, and could anyone shed light on potential causes or solutions for this problem? Any insights would be greatly appreciated.

Find more posts tagged with

Accepted answers

Ashish-Oracle

@Dhaval Parikh Stantec Please download and apply patch 36394196.

In case you are still observing a similar error, it most probably means one of the openssl rpm packages are missing in the environment where OAS has been installed and needs to be there to make this error to go away.
As a solution,

Add package compat-openssl10.

sudo dnf install -y compat-openssl10

Refer:

Data Flows In OAS 2024 Are Failing With Error [nQSError: 36001] Unable to load the dll libParquetWrapper64.so. libssl.so.10: cannot open shared object file: No such file (Doc ID 3031199.1)

Data Flows In OAS 2024 Are Failing With Error Unable To Load Dll :libcrypto.so.10 after Patch 36394196 (Doc ID 3031219.1)

Steve F-2

@Dhaval Parikh Stantec , the patch that @Ashish-Oracle, is the same one I was referring to.

The abstract of the patch mentioned SuSE 15, you can ignore that if you have OL/RH 8.
The patch is not including the the July 2024 stack patch bundle, but will be included in the next bundle patch release (October).

All comments

Steve F-2

What is your Linux environment vendor and version?

There is a patch for this.

Ashish-Oracle

@Dhaval Parikh Stantec Please download and apply patch 36394196.

Add package compat-openssl10.

sudo dnf install -y compat-openssl10

Refer:

Data Flows In OAS 2024 Are Failing With Error [nQSError: 36001] Unable to load the dll libParquetWrapper64.so. libssl.so.10: cannot open shared object file: No such file (Doc ID 3031199.1)

Data Flows In OAS 2024 Are Failing With Error Unable To Load Dll :libcrypto.so.10 after Patch 36394196 (Doc ID 3031219.1)

Steve F-2

Dhaval Parikh Stantec

@SteveF-Oracle @Ashish-Oracle Thanks for your prompt response on this! I believe we are on Linux x86-64 version. We will try to apply the patch and see if we are able to resolve the issue

Dhaval Parikh Stantec

@SteveF-Oracle @Ashish-Oracle Just closing the loop on this that we were able to resolve the excel upload issue as well as the dataflows failing issue in OAS 7.6 version by applying the patch you folks recommended