mhamedbenjmaa opened a new issue, #7730: URL: https://github.com/apache/hop/issues/7730
### 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/782704e5-f025-4f84-a2a6-a87fba684891"; /> you create simple pipe using SID and activate use auto increment key <img width="587" height="229" alt="Image" src="https://github.com/user-attachments/assets/f3e89fe4-77b9-4faf-aded-cbc2d3df2230"; /> 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 12:19:43.878</created_date> <modified_date>2026/07/31 12:19:43.878</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>224</xloc> <yloc>416</yloc> </GUI> <partitioning> <method>none</method> <schema_name/> </partitioning> <attributes/> </transform> <transform> <type>DimensionLookup</type> <name>Dimension lookup/update</name> <schema/> <table>dim_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_source</name> <rename/> <creation_method>autoinc</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>544</xloc> <yloc>416</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 run the pipe you will have this error ``` 2026/07/31 12:40:56 [Basic] Hop - Pipeline opened. 2026/07/31 12:40:56 [Basic] Hop - Launching pipeline [filename]... 2026/07/31 12:40:56 [Basic] Hop - Started executing pipeline 'filename'. 2026/07/31 12:40:56 [Basic] filename - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2026/07/31 12:40:56 [Basic] filename - Execution started for pipeline [filename] 2026/07/31 12:40:56 [Basic] Table input.0 - Finished reading query, closing connection. 2026/07/31 12:40:56 [Basic] Table input.0 - Finished processing (I=2, O=0, R=0, W=2, U=0, E=0) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Unexpected error 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Error inserting 'unknown' row in dimension [dim_source] : insert into dim_source(sid_source, version) values (0, 1) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Unexpected error executing SQL: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - offending row : [sid_source Integer(9)] 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Error setting value #1 [Integer(9)] on prepared statement 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - The column index is out of range: 1, number of columns: 0. 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1895) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:209) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at java.base/java.lang.Thread.run(Thread.java:1583) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Unexpected error executing SQL: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - offending row : [sid_source Integer(9)] 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Error setting value #1 [Integer(9)] on prepared statement 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - The column index is out of range: 1, number of columns: 0. 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.execStatement(Database.java:1449) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1893) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - ... 3 more 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - offending row : [sid_source Integer(9)] 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Error setting value #1 [Integer(9)] on prepared statement 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - The column index is out of range: 1, number of columns: 0. 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValues(Database.java:986) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.execStatement(Database.java:1412) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - ... 4 more 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Error setting value #1 [Integer(9)] on prepared statement 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - The column index is out of range: 1, number of columns: 0. 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5902) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValue(Database.java:969) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.database.Database.setValues(Database.java:984) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - ... 5 more 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0. 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:71) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:145) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1143) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:346) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5751) 2026/07/31 12:40:56 [Error] Dimension lookup/update.0 - ... 7 more 2026/07/31 12:40:56 [Basic] Hop - Stopped processing pipeline 'filename'. 2026/07/31 12:40:56 [Basic] Dimension lookup/update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2026/07/31 12:40:56 [Basic] filename - Pipeline duration : 0.049 seconds [ 0.049" ] 2026/07/31 12:40:56 [Basic] Hop - Pipeline 'filename' completed. 2026/07/31 12:40:56 [Basic] filename - Execution finished on a local pipeline engine with run configuration 'local' 2026/07/31 12:40:56 [Minimal] filename - Pipeline detected one or more transforms with errors. 2026/07/31 12:40:56 [Minimal] filename - Pipeline is killing the other transforms! ``` when you use create a new UUID instead of auto increment you have 0 issues (on te first run, second run fail, i'm going to open another issue for UUID) ### 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]
