IBM Support

Client session expired due to more than 30000s of inactivity

Troubleshooting


Problem

Intermittent error while running the report pulling data from Cloudera Impala 2.5 :
"
XQE-DAT-0001 Data source adapter error: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:Client session expired due to more than 30000s of inactivity
"

Environment

IBM Cognos Analytics 11.0.12
Cloudera Impala 2.5

Resolving The Problem

Consult the Cloudera Impala Administrator to adjust the idle session timeout setting

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"IBM Cognos Analytics 11.0.12","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 June 2019

UID

ibm10957705