IBM Support

Report Builder reports fail with DB2 SQL Error SQLCODE=-952, SQLSTATE=57014

Troubleshooting


Problem

Jazz Reporting Service Report Builder reports are failing with the DB2 SQL error 'SQLCODE=-952, SQLSTATE=57014', indicating a timeout while fetching data from the database. This can happen both with Data Warehouse and Lifecycle Query Engine reports using the relational store.

Symptom

Reports are loading for several minutes before failing with the error message: 'CRRGW5503E An unexpected response was received from the data source: DB2 SQL Error: SQLCODE=-952, SQLSTATE=57014, SQLERRMC=null, DRIVER=4.26.14'.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Component":["Performance"],"ARM Category":[{"code":"a8m50000000CjdQAAS","label":"Performance"}],"ARM Case Number":"TS021527077","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTU9C","label":"Jazz Reporting Service"},"ARM Category":[{"code":"a8m0z000000CbLvAAK","label":"Jazz Reporting Service-\u003EReport Builder"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.6;7.0.0;7.0.1;7.0.2;7.0.3;7.1.0;7.2.0;7.3.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
26 February 2026

UID

ibm17261791