ajabshinde opened a new issue, #7057: URL: https://github.com/apache/hop/issues/7057
### Apache Hop version? 2.12 ### Java version? openjdk 17.0.18 ### Operating system Windows ### What happened? varchar to CLOB data corruption on Linux with hop-run.sh (works on Windows GUI) **Description:** Scenario: - Using Apache Hop 2.12 - Pipeline fetches data from MSSQL varchar columns - Inserts data into Oracle CLOB columns - Works fine with hop-gui.bat on Windows - Fails on Linux with hop-run.sh (data corruption or encoding issues) Expected Result: - Data should be correctly inserted into CLOB columns on Linux Actual Result: - Data not inserting for to the target table but when we run the same pipeline from Windows machine via Hop-gui.bat then its run fine and also inserts data into target table General Information: - Hop Version: 2.12 - Operating System: Linux VM - Java Version: openjdk 17.0.18 - MSSQL JDBC Driver: mssql-jdbc-12.10.0.jre11.jar - Oracle JDBC Driver: ojdbc11.jar - Error Message/Log: 026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - ERROR: Because of an error, this transform can't continue: 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - ERROR: org.apache.hop.core.exception.HopException: 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - Error batch inserting rows into table [TMP_COMMENTS]. 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - Errors encountered (first 10): 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - ORA-01461: can bind a LONG value only for insert into a LONG column 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - https://docs.oracle.com/error-help/db/ora-01461/ 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - Error updating batch 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - ORA-01461: can bind a LONG value only for insert into a LONG column 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - https://docs.oracle.com/error-help/db/ora-01461/ 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:339) 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.processRow(TableOutput.java:116) 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54) 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - at java.base/java.lang.Thread.run(Thread.java:840) 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - Caused by: org.apache.hop.core.exception.HopDatabaseBatchException: 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - Error updating batch 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - ORA-01461: can bind a LONG value only for insert into a LONG column 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - 2026/04/12 22:42:46 - TMP_STG_SNHUB_L1_BORIS_LOG_UNION 2.0 - https://docs.oracle.com/error-help/db/ora-01461/ ### Issue Priority Priority: 3 ### Issue Component Component: Hop Run -- 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]
