Loading

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

Date de publication: Feb 21, 2025
Description

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"

Résolution
As a possible workaround, increase the "STMTHEAP" parameter in the IBM DB2 database to at least 8000. For more information on configuring this variable, please see IBM's documentation below:

SQL0101N The statement is too long or too complex
https://www.ibm.com/support/pages/sql0101n-statement-too-long-or-too-complex

stmtheap - Statement heap size configuration parameter
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0000277.html

Ressources supplémentaires

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\
 

Numéro d’article de la base de connaissances

001534185

 
Chargement
Salesforce Help | Article