Tableau Server で DB2 データ ソースを使用してワークブックをロードしようとすると、次のエラーが表示されます。
"Bad connection: Tableau could not connect to the data source Error code: FAB9A2C5" (無効な接続: Tableau はデータ ソースに接続できませんでした。エラー コード: FAB9A2C5)
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
"STMTHEAP" の現在のサイズは、Tableau Desktop でカスタム SQL クエリを使用して確認できます。
1. Tableau Desktop を開きます。
2. IBM DB2 データ ソースに接続します。
3. スキーマを選択します。
4. "新しいカスタム SQL" をデータ接続ウィンドウにドラッグします。
5. 次の SQL クエリを入力して [OK] をクリックします。
SELECT NAME, VALUE, VALUE_FLAGS, MEMBER
FROM SYSIBMADM.DBCFG
WHERE NAME = 'stmtheap'
さらに、次のエラーが Tableau Server のログに記録されます。
##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\
001534185

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.