dmainou opened a new issue, #7037: URL: https://github.com/apache/hop/issues/7037
### Apache Hop version? 2.17 ### Java version? jre-17-openjdk ### Operating system Linux ### What happened? Table input transform will not substitute the ? with the value coming from the prior transform. I have tried all sorts of things including substituting the whole sql statement or just the dynamic value with no success. ``` 2026/04/22 09:44:14 [Error] r_SUBJECT_AREA.0 - Unexpected error 2026/04/22 09:44:14 [Error] r_SUBJECT_AREA.0 - org.apache.hop.core.exception.HopDatabaseException: 2026/04/22 09:44:14 [Error] r_SUBJECT_AREA.0 - An error occurred executing SQL: 2026/04/22 09:44:14 [Error] r_SUBJECT_AREA.0 - ? 2026/04/22 09:44:14 [Error] r_SUBJECT_AREA.0 - [SQLITE_ERROR] SQL error or missing database (near "?": syntax error) ``` ``` 026/04/22 09:51:53 [Basic] failures_collector - Execution started for pipeline [failures_collector] 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - Unexpected error 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - org.apache.hop.core.exception.HopDatabaseException: 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - An error occurred executing SQL: 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - SELECT 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - subject_area 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , action 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , failed 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , api_url 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , api_body 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , fields 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , changes 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , response_status 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , response_time 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - , response_body 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - FROM ? 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - where failed = 1 2026/04/22 09:51:53 [Error] r_SUBJECT_AREA.0 - [SQLITE_ERROR] SQL error or missing database (near "?": syntax error) ``` I believe I am correctly configuring the step (same as for the last decade lol) <img width="826" height="115" alt="Image" src="https://github.com/user-attachments/assets/67f7c7d1-0814-4eaa-ad53-f471e189fe74"; /> <img width="644" height="601" alt="Image" src="https://github.com/user-attachments/assets/5876959f-d7a1-4cb3-bcf8-bc70a08b5ca3"; /> ### Issue Priority Priority: 3 ### Issue Component Component: Hop Gui -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
