mhamedbenjmaa opened a new issue, #7731: URL: https://github.com/apache/hop/issues/7731
### Apache Hop version? 2.18.1 ### Java version? openjdk version "21.0.12" 2026-07-21 LTS ### Operating system Linux ### What happened? Bug confirmed on SQL Server 2022 and postgres latest version you create simple table <img width="396" height="179" alt="Image" src="https://github.com/user-attachments/assets/a7d69edc-6a3f-4827-aa51-97b842e0bf9e"; /> you create simple pipe using SID and activate UUID <img width="587" height="229" alt="Image" src="https://github.com/user-attachments/assets/c49f6a26-5a60-4f89-9e86-728aa958f4c1"; /> here the pipe code ``` <?xml version="1.0" encoding="UTF-8"?> <pipeline> <info> <capture_transform_performance>N</capture_transform_performance> <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> <transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit> <pipeline_type>Normal</pipeline_type> <pipeline_status>-1</pipeline_status> <parameters/> <name>New pipeline</name> <name_sync_with_filename>Y</name_sync_with_filename> <created_user>-</created_user> <modified_user>-</modified_user> <created_date>2026/07/31 13:07:52.697</created_date> <modified_date>2026/07/31 13:07:52.697</modified_date> </info> <transform> <type>TableInput</type> <name>Table input</name> <sql>SELECT * FROM "public"."source" </sql> <limit>0</limit> <execute_each_row>N</execute_each_row> <variables_active>N</variables_active> <connection>postgres ods</connection> <lookup/> <sql_from_file/> <distribute>Y</distribute> <copies>1</copies> <GUI> <xloc>192</xloc> <yloc>288</yloc> </GUI> <partitioning> <method>none</method> <schema_name/> </partitioning> <attributes/> </transform> <transform> <type>DimensionLookup</type> <name>Dimension lookup/update</name> <schema/> <table>td_source</table> <connection>postgres ods</connection> <update>Y</update> <fields> <key> <name>code</name> <lookup>code</lookup> </key> <date> <name/> <from>date_from</from> <to>date_to</to> </date> <field> <name>lib1</name> <lookup>lib1</lookup> <update>Update</update> </field> <field> <name>lib2</name> <lookup>lib2</lookup> <update>Insert</update> </field> <return> <name>sid_code</name> <rename/> <creation_method>uuid</creation_method> <version>version</version> </return> </fields> <sequence/> <tkSourceField/> <commit>100</commit> <useBatch>N</useBatch> <min_year>1900</min_year> <max_year>2199</max_year> <cache_size>5000</cache_size> <use_start_date_alternative>N</use_start_date_alternative> <start_date_field_name/> <preload_cache>N</preload_cache> <unknown_row_check_disabled>N</unknown_row_check_disabled> <distribute>Y</distribute> <copies>1</copies> <GUI> <xloc>560</xloc> <yloc>320</yloc> </GUI> <partitioning> <method>none</method> <schema_name/> </partitioning> <attributes/> </transform> <order> <hop> <from>Table input</from> <to>Dimension lookup/update</to> <enabled>Y</enabled> </hop> </order> <notepads/> <attributes/> <transform_error_handling/> </pipeline> ``` you do your first run ==>OK you change lib1 to totox instead of toto you run you get this ``` 2026/07/31 13:16:56 [Basic] Hop - Pipeline opened. 2026/07/31 13:16:56 [Basic] Hop - Launching pipeline [sss]... 2026/07/31 13:16:56 [Basic] Hop - Started executing pipeline 'sss'. 2026/07/31 13:16:56 [Basic] sss - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2026/07/31 13:16:56 [Basic] sss - Execution started for pipeline [sss] 2026/07/31 13:16:56 [Basic] Table input.0 - Finished reading query, closing connection. 2026/07/31 13:16:56 [Basic] Table input.0 - Finished processing (I=2, O=0, R=0, W=2, U=0, E=0) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Because of an error this transform can't continue: 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - offending row : [lib1 String(40)], [lib2 String(40)], [sid_source Integer] 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Error setting value #3 [Integer] on prepared statement 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Unexpected conversion error while converting value [sid_source Integer] to an Integer 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap') 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - offending row : [lib1 String(40)], [lib2 String(40)], [sid_source Integer] 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Error setting value #3 [Integer] on prepared statement 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Unexpected conversion error while converting value [sid_source Integer] to an Integer 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap') 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValues(Database.java:986) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.dimUpdate(DimensionLookup.java:1519) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:778) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:224) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at java.base/java.lang.Thread.run(Thread.java:1583) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Error setting value #3 [Integer] on prepared statement 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Unexpected conversion error while converting value [sid_source Integer] to an Integer 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap') 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5902) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValue(Database.java:969) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValues(Database.java:984) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - ... 5 more 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Caused by: org.apache.hop.core.exception.HopValueException: 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Unexpected conversion error while converting value [sid_source Integer] to an Integer 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap') 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2542) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5751) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - ... 7 more 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - Caused by: java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap') 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2456) 2026/07/31 13:16:56 [Error] Dimension lookup/update.0 - ... 8 more 2026/07/31 13:16:56 [Basic] Hop - Stopped processing pipeline 'sss'. 2026/07/31 13:16:56 [Basic] Dimension lookup/update.0 - Finished processing (I=2, O=0, R=2, W=1, U=0, E=1) 2026/07/31 13:16:56 [Basic] sss - Pipeline duration : 0.054 seconds [ 0.054" ] 2026/07/31 13:16:56 [Basic] Hop - Pipeline 'sss' completed. 2026/07/31 13:16:56 [Basic] sss - Execution finished on a local pipeline engine with run configuration 'local' 2026/07/31 13:16:56 [Minimal] sss - Pipeline detected one or more transforms with errors. 2026/07/31 13:16:56 [Minimal] sss - Pipeline is killing the other transforms! ``` ### 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]
