Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
16
Views
2
Comments

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.

image.png

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