Database Management
DPA Tuning tab returns HTTP 500 "Invalid column name 'table_id'" in DPA 2025.4 for SQL Server repository
In DPA 2025.4, opening the Tuning tab for affected monitored databases on a SQL Server repository can fail with HTTP 500 due to an "Invalid column name 'table_id'" error against table CON_IA_TABLE_SUMMARY_{dbid}. The issue was fixed in DPA 2026.2, and upgrading to 2026.2 or later resolves the problem.
First published date
Last published date
Overview
When a user clicks the Tuning tab for certain databases in DPA 2025.4, the UI displays "Internal server error Http failure response for /iwc/rest/databases/{id}/dates/tuning: 500 OK" and no tuning advice is shown. In idc.log, the backend query joining CON_FQ_OBJECT_{dbid} and CON_IA_TABLE_SUMMARY_{dbid} fails with SQLServerException "Invalid column name 'table_id'", which is wrapped in a DpaException and returns as HTTP 500 on the Tuning endpoint.
Product section
Cause
DPA 2025.4 expects the CON_IA_TABLE_SUMMARY_{dbid} table to expose a TABLE_ID column (foreign key to CON_FQ_OBJECT_{dbid}.ID) for Index Analysis and Tuning metadata. In environments using a case-sensitive SQL Server collation, the engine does not correctly recognize the column name referenced as table_id in the query, which causes the "Invalid column name 'table_id'" error and prevents the Tuning tab from loading.
The 2026.2 release notes reference a Turkish_CI_AS case, but this issue is caused by column-name casing in the Tuning/Index Analysis query and is not limited to Turkish_CI_AS; it can also affect SQL Server instances using other collations that distinguish column-name casing.
Resolution
This issue is fixed in DPA 2026.2 so that the Tuning tab correctly reads Index Analysis data from CON_IA_TABLE_SUMMARY_{dbid} without raising the "Invalid column name 'table_id'" error.
To resolve the issue, upgrade the affected DPA 2025.4 instance to DPA 2026.2 or later. After the upgrade, the Tuning tab loads normally and displays tuning recommendations using the existing repository data.