gmitter-ef opened a new issue, #5792: URL: https://github.com/apache/hop/issues/5792
### Apache Hop version? 2.15.0 ### Java version? OpenJDK 17 ### Operating system Windows ### What happened? Table input transform reads a "date" from a Postgres database, update transform tries to update a corresponding "Date" in an Oracle database. Unless "Skip lookup" is checked, the update fails with: ``` 2025/10/08 07:50:20 - Update.0 - ERROR: Error in transform, asking everyone to stop because of: 2025/10/08 07:50:20 - Update.0 - ERROR: org.apache.hop.core.exception.HopDatabaseException: 2025/10/08 07:50:20 - Update.0 - Couldn't get row from result set 2025/10/08 07:50:20 - Update.0 - 2025/10/08 07:50:20 - Update.0 - Unable to get value 'None' from database resultset, index 0 2025/10/08 07:50:20 - Update.0 - No data read ``` In the case of unchecking "Skip lookup", checking/unchecking "Ignore lookup failures" and providing a field for the Y/N values if the key was found makes no difference. Using a "Select values" transform to convert the Date stream field into a String or Timestamp changes nothing in the behavior. See the attached pipeline. ### Issue Priority Priority: 3 ### 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]
