You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "KBoersch (via GitHub)" <gi...@apache.org> on 2025/10/16 10:16:20 UTC

[I] [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920 (hop)

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: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920 (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5846:
URL: https://github.com/apache/hop/issues/5846#issuecomment-5069112033

   this should be fixed


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920 (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5846:
URL: https://github.com/apache/hop/issues/5846#issuecomment-3773652298

   The root cause is that this transform still uses the "old way" of injecting things making constant values not work.
   If you specify the condition in a field the template is generated correctly.


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920 (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5846:
URL: https://github.com/apache/hop/issues/5846#issuecomment-3410479480

   the conditions are injected incorrectly, `WHERE key1 null ? AND   key2 null ? , Error Message = ORA-00920: invalid relational operator` 


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920 (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #5846: [Bug]: Metadata Injection Run directly + Synchronize after Merge transform leads to ORA-00920
URL: https://github.com/apache/hop/issues/5846


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org