KNOWLEDGE BASE

"Bad connection: Tableau could not connect to the data source Error code: FAB9A2C5"


Published: 16 Feb 2021
Last Modified Date: 26 Aug 2021

Issue

When trying to load a workbook with DB2 data source in Tableau Server the following error is seen:

"Bad connection: Tableau could not connect to the data source Error code: FAB9A2C5"

Environment

  • Tableau Desktop
  • Tableau Server
  • IBM DB2

Additional Information

The current size of the "STMTHEAP" can be determined in Tableau Desktop using a custom SQL query.

1. Open Tableau Desktop

2. Connect to the IBM DB2 data source

3. Select a Schema

4. Drag "New Custom SQL" into the data connection window

5. Enter the following SQL query, and click OK

SELECT NAME, VALUE, VALUE_FLAGS, MEMBER

FROM SYSIBMADM.DBCFG

WHERE NAME = 'stmtheap'


You will also see the following error in the Tableau Server logs

##Vizqlserver##
{"ts":"2021-02-11T18:05:58.142","pid":36408,"tid":"c5a0","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"msg","e":{"excp-error-code":"0xFAB9A2C5","excp-source":"NeedsClassification","excp-status-code":"UNKNOWN"},"v":"dsClass: db2, sql state: 54001, native error: -101, error description: [IBM][CLI Driver][DB2/AIX64] SQL0101N  The statement is too long or too complex.  SQLSTATE=54001\
 

Did this article resolve the issue?