Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Error while running information link - "Failed to create temporary result: ORA-01031: insufficient privileges"

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Error while running information link - "Failed to create temporary result: ORA-01031: insufficient privileges"


Solution:

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).

Related articles