You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "gmitter-ef (via GitHub)" <gi...@apache.org> on 2025/10/08 06:00:12 UTC
[I] [Bug]: Updating an Oracle Date column with a Date read from Postgres fails (unless "Skip lookup" is checked) (hop)
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: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Updating an Oracle Date column with a Date read from Postgres fails (unless "Skip lookup" is checked) (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #5792: [Bug]: Updating an Oracle Date column with a Date read from Postgres fails (unless "Skip lookup" is checked)
URL: https://github.com/apache/hop/issues/5792
--
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]: Updating an Oracle Date column with a Date read from Postgres fails (unless "Skip lookup" is checked) (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5792:
URL: https://github.com/apache/hop/issues/5792#issuecomment-5750637705
The "Supports the Timestamp data type" option is probably turned of on this connection.
The issue has been solved/hardened in the upcoming release
--
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