Error while running information link - "Failed to create temporary result: ORA-01031: insufficient privileges"
Article ID: KB0080950
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All supported versions |
Description
When trying to execute an Information Link that pulls data from multiple datasources based on an Oracle Database, it may throw the following error:
Could not open information link
[...]
InformationModelException at Spotfire.Dxp.Data:
Failed to create temporary result: ORA-01031: insufficient privileges
(HRESULT: 80131500)
Could not open information link
[...]
InformationModelException at Spotfire.Dxp.Data:
Failed to create temporary result: ORA-01031: insufficient privileges
(HRESULT: 80131500)
Issue/Introduction
Error while running information link - "Failed to create temporary result: ORA-01031: insufficient privileges"
Resolution
When running an Information Link that contains a join between two data sources (or that has a lot of filter values), temporary tables are used. Depending on if either of the data sources used have been set to "Allow writing in temporary tables", the temporary table is created there or otherwise on the data source set as the "Default join data source".
A DBA should verify that the user connecting to that data source has sufficient permissions to create the temporary table (e.g. on Oracle - has been granted the create table privilege).
A DBA should verify that the user connecting to that data source has sufficient permissions to create the temporary table (e.g. on Oracle - has been granted the create table privilege).
Feedback
Yes
No
Powered by
