Dataset fails to be found, has no Access option to enable us to check the permissions.

Kevin Robertson

Hiya, hopefully someone can explain this. We have just stood up the FDI environment in production but we cant access one of our spreadsheet data sets.

Errors

[nQSError: 17010] SQL statement preparation failed.

[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does

not exist at OCI call OCIStmtExecute.

[nQSError: 46217] Query to the replica failed. Retrying the query without the replica.

On further inspection of the the Dataset we noticed the access option is missing so we cant inspect/change the permissions. In the Dev environment its actually the same but we can access the dataset without any issue.

Ive included the Performance Download in the hope someone might be able to explain this.

Thank you for taking the time to read this.

PerformanceToolsDownload Pay element categories.txt

RVohra

Can you try to re-upload or re-publish the Spreadsheet Dataset in Prod? You might need to delete the broken dataset in Prod.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27561/dataset-fails-to-be-found-has-no-access-option-to-enable-us-to-check-the-permissions

Hi @Kevin Robertson,

Welcome to the Oracle Analytics Community!

There's a chance, it might be due to either a permissions issue with your user role or that the dataset owner has not granted you sufficient access.

Can you please check the following doc & the post which might be useful.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/add-or-update-datasets-permissions.html

Datasets visibility — Oracle

Hope this help.

Thank you.

Kevin Robertson

Thank you to everyone who took time out of their own day to read and respond to my question. I'm pleased to say that we have resolved the issue and it did appear to be a permissions problem when the file was created as a .dva

We think the original file was setup with only the permissions of the person who created the import file and unfortunately that person is not available to us at the moment.

I recreated the dva file, this time without permissions being set, imported the file and then set they required permissions in our Production environment.

All would appear to be working fine.

Thank you, very much appreciated.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/72651#Comment_72651

Hi @Kevin Robertson,

That's great news.

Thank your sharing the details.