TIBCO Spotfire installed client or Spotfire Web Player crash while loading Reports and Tables from Salesforce data connector with error "sObject type 'XXXX' is not supported"

TIBCO Spotfire installed client or Spotfire Web Player crash while loading Reports and Tables from Salesforce data connector with error "sObject type 'XXXX' is not supported"

book

Article ID: KB0081227

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

After connecting to Salesforce using the TIBCO Spotfire Connector for Salesforce via Add Data Tables > Salesforce.com and entering the credentials in the TIBCO Spotfire Installed Client or after entering credentials in the TIBCO Spotfire Web Player in an already published report, the Salesforce driver might crash which in turn causes Spotfire client to crash while loading Reports and Tables with a "TIBCO Spotfire has stopped working" popup as seen in the attached picture (Salesforce Spotfire error.png), without logging any error or exception in the client and with the following error in the ODBC debug logs:
[TIBCO][Salesforce] (148) sObject type 'XXXX' is not supported.

This may occur when the user has no minimum permissions in Salesforce (i.e 'Read' and 'View All') to access those objects which are either Reports or Tables.

The ODBC debug logs mentioned can be enabled per the instructions in the Reference section.

Issue/Introduction

The TIBCO Spotfire installed client crashes while loading Reports and Tables from a Salesforce data connection due to insufficient privileges on reports or tables

Resolution

Enable at least 'Read' and 'View All' permissions as shown in the screenshot attached (Permissions.png), on all the Reports and Tables in order to access those in the TIBCO Spotfire client.

Additional Information

External: Enabling ODBC debug logging (Windows)

Attachments

TIBCO Spotfire installed client or Spotfire Web Player crash while loading Reports and Tables from Salesforce data connector with error "sObject type 'XXXX' is not supported" get_app
TIBCO Spotfire installed client or Spotfire Web Player crash while loading Reports and Tables from Salesforce data connector with error "sObject type 'XXXX' is not supported" get_app