KNOWLEDGE BASE

After Connecting To Denodo, Error Code "FAB9A2C5" And Query Error "QUERY [SALESFORCE ROUTE] [CONNECTION_ERROR]" Are Displayed When Creating A View


Published: 21 Jan 2022
Last Modified Date: 26 Jan 2022

Issue

After connecting to Denodo, the following error codes are displayed when creating a view: 
"FAB9A2C5" and query error "QUERY [SALESFORCE ROUTE] [CONNECTION_ERROR]"

Denodo is expected to be routed to Salesforce.
 
Error examples:
 
Tableau Server
User-added image

ERROR: Error executing query. Total time 0.172 seconds.
    QUERY [VIRTUAL] [ERROR] 
    QUERY [SALESFORCE WRAPPER] [ERROR] 
    QUERY [SALESFORCE ROUTE] [CONNECTION_ERROR]  Received exception with message 'Error retri;
    Error while executing the query
 
Tableau Desktop
User-added image

Environment

  • Tableau Server
  • Tableau Desktop
  • Denodo
  • Salesforce

Resolution

Please make sure that the query can be executed on the Denodo side. If it fails, please contact Denodo or Salesforce for further investigation.

Cause

There is a third-party data route issue between Denodo and Salesforce.
Did this article resolve the issue?