kleysonr opened a new issue, #2978: URL: https://github.com/apache/hop/issues/2978
### Apache Hop version? 2.4.0 (2023-03-27 07.51.24) ### Java version? openjdk 11.0.19 2023-04-18 LTS ### Operating system Windows ### What happened? I'm using the default cache configuration in the Dimension lookup/update transform. When I have cache enabled, I'm getting the following error: ``` 2023/05/29 11:38:29 - Hop - Pipeline opened. 2023/05/29 11:38:29 - Hop - Launching pipeline [d_localidade]... 2023/05/29 11:38:29 - Hop - Started the pipeline execution. 2023/05/29 11:38:30 - d_localidade - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2023/05/29 11:38:30 - d_localidade - Execution started for pipeline [d_localidade] 2023/05/29 11:38:30 - mei: load municipios.0 - Finished processing (I=5570, O=0, R=0, W=5570, U=0, E=0) 2023/05/29 11:38:30 - so: upper nomes.0 - Finished processing (I=0, O=0, R=5570, W=5570, U=0, E=0) 2023/05/29 11:38:30 - dlu: d_localidade.0 - ERROR: Unexpected error 2023/05/29 11:38:30 - dlu: d_localidade.0 - ERROR: java.lang.NullPointerException 2023/05/29 11:38:30 - dlu: d_localidade.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.getFromCache(DimensionLookup.java:1680) 2023/05/29 11:38:30 - dlu: d_localidade.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:430) 2023/05/29 11:38:30 - dlu: d_localidade.0 - at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:204) 2023/05/29 11:38:30 - dlu: d_localidade.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) 2023/05/29 11:38:30 - dlu: d_localidade.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2023/05/29 11:38:30 - input.0 - Finished processing (I=0, O=0, R=29924, W=29924, U=0, E=0) 2023/05/29 11:38:30 - sl: lookup cidades.0 - Finished processing (I=0, O=0, R=25593, W=20023, U=0, E=0) 2023/05/29 11:38:30 - De-serialize from file.0 - Finished processing (I=39825, O=0, R=0, W=39825, U=0, E=0) 2023/05/29 11:38:30 - dlu: d_localidade.0 - Finished processing (I=15, O=12, R=16, W=15, U=0, E=1) 2023/05/29 11:38:30 - d_localidade - Pipeline detected one or more transforms with errors. 2023/05/29 11:38:30 - d_localidade - Pipeline is killing the other transforms! 2023/05/29 11:38:31 - output.0 - Finished processing (I=0, O=0, R=15, W=15, U=0, E=0) 2023/05/29 11:38:31 - O QUE FAZER COM ERROS ?.0 - Finished processing (I=0, O=0, R=34, W=34, U=0, E=0) 2023/05/29 11:38:31 - fr: check erros.0 - Finished processing (I=0, O=0, R=10051, W=10051, U=0, E=0) 2023/05/29 11:38:31 - d_localidade - Pipeline duration : 1.042 seconds [ 1.042" ] 2023/05/29 11:38:31 - d_localidade - Execution finished on a local pipeline engine with run configuration 'local' ``` The following images are showing the transform configuration and sample data.   But when I disable the option 'Enable the cache?' or even set 'Cache size in rows' to '-1', my pipeline runs without any errors. ``` 2023/05/29 14:26:10 - Hop - Pipeline opened. 2023/05/29 14:26:10 - Hop - Launching pipeline [d_localidade]... 2023/05/29 14:26:10 - Hop - Started the pipeline execution. 2023/05/29 14:26:10 - d_localidade - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2023/05/29 14:26:10 - d_localidade - Execution started for pipeline [d_localidade] 2023/05/29 14:26:10 - mei: load municipios.0 - Finished processing (I=5570, O=0, R=0, W=5570, U=0, E=0) 2023/05/29 14:26:10 - so: upper nomes.0 - Finished processing (I=0, O=0, R=5570, W=5570, U=0, E=0) 2023/05/29 14:26:50 - De-serialize from file.0 - Finished processing (I=79207, O=0, R=0, W=79207, U=0, E=0) 2023/05/29 14:26:59 - input.0 - Finished processing (I=0, O=0, R=79207, W=79207, U=0, E=0) 2023/05/29 14:27:09 - sl: lookup cidades.0 - Finished processing (I=0, O=0, R=84777, W=79207, U=0, E=0) 2023/05/29 14:27:18 - fr: check erros.0 - Finished processing (I=0, O=0, R=79207, W=79207, U=0, E=0) 2023/05/29 14:27:18 - O QUE FAZER COM ERROS ?.0 - Finished processing (I=0, O=0, R=140, W=140, U=0, E=0) 2023/05/29 14:27:28 - dlu: d_localidade.0 - Finished processing (I=79067, O=244, R=79067, W=79067, U=0, E=0) 2023/05/29 14:27:28 - output.0 - Finished processing (I=0, O=0, R=79067, W=79067, U=0, E=0) 2023/05/29 14:27:28 - d_localidade - Pipeline duration : 77.944 seconds [ 1' 17.944" ] 2023/05/29 14:27:28 - d_localidade - Execution finished on a local pipeline engine with run configuration 'local' ``` ### Issue Priority Priority: 1 ### Issue Component Component: Actions, Component: Database, 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-unsubscr...@hop.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
