topic Re: Talend Profiling Report failed to run in Data Quality

Talend Profiling Report failed to run

felipito — Wed, 22 Apr 2026 07:43:20 GMT

When I am trying to write my Talend profiling analysis to my existing TDQ model via report, I get the following error message: org.hibernate.DataException: could not execute statement.

My analysis worked well I got the expected results. Only when I run the report I got the org.hibernate.DataException error.

Re: Talend Profiling Report failed to run

Mohammed_Messaoudi — Wed, 22 Apr 2026 09:29:52 GMT

Hello,

TDQ uses Hibernate to store analysis results in its internal database (H2 by default, PostgreSQL/Oracle in production). The DataException usually occurs when:

Text values exceed column length limits (e.g., VAL_STRING in TDQ_VALUES table),

Analysis metadata (column names, indicator descriptions, patterns) is too long for the schema.

Please check the full stack trace in TDQ logs for the nested SQL error:
ERROR: value too long for type character varying or value too large for column....

Re: Talend Profiling Report failed to run

felipito — Wed, 22 Apr 2026 12:07:22 GMT

You are right. An error was detected based on the metadata log entries. A WHERE clause that was too long (> 1000 characters) could not be added into the designated TDQ field TDQ_ANALYSIS.AN_DATA_FILTER (varchar(1000)). Thanks.