Product: TIBCO Spotfire®
Error while running information link - "Failed to create temporary result: ORA-01031: insufficient privileges"
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) 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).