Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dataset fails to be found, has no Access option to enable us to check the permissions.
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.
Answers
-
Can you try to re-upload or re-publish the Spreadsheet Dataset in Prod? You might need to delete the broken dataset in Prod.
0 -
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.
Hope this help.
Thank you.
0
