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.
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....
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.
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....
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.
