KNOWLEDGE BASE

Essbase 'An error occurred while communicating with data source'


Published: 05 Sep 2018
Last Modified Date: 10 Sep 2018

Issue

After connecting to Essbase, when tables are dragged into a view, the following error is thrown:
 
DataSourceException (type=Unknown): Essbase database error 1042006: Network error [10061]: Failed to connect to [<database_name>:1423]\n"}

Environment

  • Tableau Desktop
  • Essbase database versions after 11.1.2.4.010 and before 11.1.2.4.025

Resolution

Option 1

Roll back to an earlier version of Essbase.

Option 2

Upgrade Essbase to Patch Set Update 11.1.2.4.025 

Cause

This behavior originates in an Oracle defect related to creating and dropping sets.
Did this article resolve the issue?