KBoersch opened a new issue, #5846: URL: https://github.com/apache/hop/issues/5846
### Apache Hop version? 2.15.0 ### Java version? jdk-21.0.5+11 ### Operating system Windows ### What happened? When using metadata injection in combination with a synchronize after merge transform after merge rows diff, I run into the following error. It only occurs, when the resulting pipeline ist run directly. Using the injected pipeline copy works just fine. I was able to recreate the case in a simple test pipeline I attached. `2025/10/16 12:09:53 - Table input reference.0 - Finished reading query, closing connection. 2025/10/16 12:09:53 - Sort rows reference.0 - Finished processing (I=0, O=0, R=3, W=3, U=0, E=0) 2025/10/16 12:09:53 - Table input reference.0 - Finished processing (I=3, O=0, R=0, W=3, U=0, E=0) 2025/10/16 12:09:53 - Synchronize after merge.0 - ERROR: Because of an error, this transform can't continue: 2025/10/16 12:09:53 - Synchronize after merge.0 - ERROR: org.apache.hop.core.exception.HopException: 2025/10/16 12:09:53 - Synchronize after merge.0 - Error inserting row into table [testtabelle_hop] with values: [1], [2], [1], [1], [1], [changed] 2025/10/16 12:09:53 - Synchronize after merge.0 - 2025/10/16 12:09:53 - Synchronize after merge.0 - Error inserting/updating row 2025/10/16 12:09:53 - Synchronize after merge.0 - ORA-00920: invalid relational operator 2025/10/16 12:09:53 - Synchronize after merge.0 - https://docs.oracle.com/error-help/db/ora-00920/ 2025/10/16 12:09:53 - Synchronize after merge.0 - 2025/10/16 12:09:53 - Synchronize after merge.0 - 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.pipeline.transforms.synchronizeaftermerge.SynchronizeAfterMerge.lookupValues(SynchronizeAfterMerge.java:491) 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.pipeline.transforms.synchronizeaftermerge.SynchronizeAfterMerge.processRow(SynchronizeAfterMerge.java:904) 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54) 2025/10/16 12:09:53 - Synchronize after merge.0 - at java.base/java.lang.Thread.run(Thread.java:1583) 2025/10/16 12:09:53 - Synchronize after merge.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2025/10/16 12:09:53 - Synchronize after merge.0 - Error inserting/updating row 2025/10/16 12:09:53 - Synchronize after merge.0 - ORA-00920: invalid relational operator 2025/10/16 12:09:53 - Synchronize after merge.0 - https://docs.oracle.com/error-help/db/ora-00920/ 2025/10/16 12:09:53 - Synchronize after merge.0 - 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.core.database.Database.insertRow(Database.java:1194) 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.core.database.Database.insertRow(Database.java:1112) 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.pipeline.transforms.synchronizeaftermerge.SynchronizeAfterMerge.lookupValues(SynchronizeAfterMerge.java:301) 2025/10/16 12:09:53 - Synchronize after merge.0 - ... 3 more 2025/10/16 12:09:53 - Synchronize after merge.0 - Caused by: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator 2025/10/16 12:09:53 - Synchronize after merge.0 - https://docs.oracle.com/error-help/db/ora-00920/ 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:715) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:615) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1372) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:972) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:524) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:298) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1510) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:2020) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1633) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3973) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OraclePreparedStatement.doExecuteLargeUpdate(OraclePreparedStatement.java:4339) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4316) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4291) 2025/10/16 12:09:53 - Synchronize after merge.0 - at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1007) 2025/10/16 12:09:53 - Synchronize after merge.0 - at org.apache.hop.core.database.Database.insertRow(Database.java:1159) 2025/10/16 12:09:53 - Synchronize after merge.0 - ... 5 more 2025/10/16 12:09:53 - Synchronize after merge.0 - Caused by: Error : 920, Position : 87, SQL = UPDATE val.testtabelle_hop 2025/10/16 12:09:53 - Synchronize after merge.0 - SET value1 = :1 , value2 = :2 , value3 = :3 WHERE key1 null :4 AND key2 null :5 , Original SQL = UPDATE val.testtabelle_hop 2025/10/16 12:09:53 - Synchronize after merge.0 - SET value1 = ? 2025/10/16 12:09:53 - Synchronize after merge.0 - , value2 = ? 2025/10/16 12:09:53 - Synchronize after merge.0 - , value3 = ? 2025/10/16 12:09:53 - Synchronize after merge.0 - WHERE key1 null ? AND key2 null ? , Error Message = ORA-00920: invalid relational operator` [test_template.zip](https://github.com/user-attachments/files/22946367/test_template.zip) ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- 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]
