enricomariam42 opened a new issue, #2054: URL: https://github.com/apache/hop/issues/2054
### Apache Hop version? SNAPSHOT-20221210 ### Java version? openjdk version "11.0.9.1" 2020-11-04 OpenJDK Runtime Environment (build 11.0.9.1+1-post-Uos-1deb10u2) OpenJDK 64-Bit Server VM (build 11.0.9.1+1-post-Uos-1deb10u2, mixed mode, sharing) ### Operating system Linux ### What happened? Select value transform altering metadata integer to string cause exception saving Execution Information to Neo4j. The bug can be reproduced with the attached pipeline, a simplified and modified version of select-values-basic.hpl from the "samples" project. Step to reproduce: 1. Create a test project 2. Define a Execution data profile "last_100" with sampler "last output rows" and size "100" 3. Define a Execution information location "neo4j" as neo4j location 4. Define a Pipeline run configuration "local" choosing up the previous Execution information location "neo4j" and Execution data profile "last_100" 5. Unzip and add the attached pipeline "select-values-int_to_str.hpl" to the project 6. Run the pipeline with the "local" run configuration [select-values-int_to_str.zip](https://github.com/apache/hop/files/10209486/select-values-int_to_str.zip) log: ``` 2022/12/12 16:20:11 - Hop - Pipeline opened. 2022/12/12 16:20:11 - Hop - Launching pipeline [select-values-int_to_str]... 2022/12/12 16:20:11 - Hop - Started the pipeline execution. 2022/12/12 16:20:11 - select-values-int_to_str - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2022/12/12 16:20:11 - select-values-int_to_str - Execution started for pipeline [select-values-int_to_str] 2022/12/12 16:20:11 - [select-values-int_to_str].Test Data.0 - Finished processing (I=0, O=0, R=0, W=2, U=0, E=0) 2022/12/12 16:20:11 - [select-values-int_to_str].Cast data types.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0) 2022/12/12 16:20:11 - select-values-int_to_str - Pipeline duration : 0.316 seconds [ 0.316" ] 2022/12/12 16:20:13 - select-values-int_to_str - ERROR: Error handling writing final pipeline state to location (non-fatal) 2022/12/12 16:20:13 - select-values-int_to_str - ERROR: org.apache.hop.core.exception.HopException: 2022/12/12 16:20:13 - select-values-int_to_str - Error getting execution from Neo4j 2022/12/12 16:20:13 - select-values-int_to_str - org.apache.hop.core.exception.HopValueException: 2022/12/12 16:20:13 - select-values-int_to_str - Unexpected conversion error while converting value [id Integer] to an Integer 2022/12/12 16:20:13 - select-values-int_to_str - 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') 2022/12/12 16:20:13 - select-values-int_to_str - 2022/12/12 16:20:13 - select-values-int_to_str - 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.registerData(NeoExecutionInfoLocation.java:877) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.engines.local.LocalPipelineEngine.stopTransformExecutionInfoTimer(LocalPipelineEngine.java:486) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.engines.local.LocalPipelineEngine.pipelineCompleted(LocalPipelineEngine.java:465) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.Pipeline.firePipelineExecutionFinishedListeners(Pipeline.java:1343) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.Pipeline.lambda$startThreads$0(Pipeline.java:1142) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.transform.BaseTransform.fireTransformFinishedListeners(BaseTransform.java:2779) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.transform.BaseTransform.markStop(BaseTransform.java:2768) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:142) 2022/12/12 16:20:13 - select-values-int_to_str - at java.base/java.lang.Thread.run(Thread.java:834) 2022/12/12 16:20:13 - select-values-int_to_str - Caused by: java.lang.RuntimeException: org.apache.hop.core.exception.HopValueException: 2022/12/12 16:20:13 - select-values-int_to_str - Unexpected conversion error while converting value [id Integer] to an Integer 2022/12/12 16:20:13 - select-values-int_to_str - 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') 2022/12/12 16:20:13 - select-values-int_to_str - 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.saveNeo4jRowsAndMeta(NeoExecutionInfoLocation.java:1115) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.registerNeo4jData(NeoExecutionInfoLocation.java:944) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.lambda$registerData$11(NeoExecutionInfoLocation.java:875) 2022/12/12 16:20:13 - select-values-int_to_str - at org.neo4j.driver.internal.InternalSession.lambda$transaction$4(InternalSession.java:150) 2022/12/12 16:20:13 - select-values-int_to_str - at org.neo4j.driver.internal.retry.ExponentialBackoffRetryLogic.retry(ExponentialBackoffRetryLogic.java:103) 2022/12/12 16:20:13 - select-values-int_to_str - at org.neo4j.driver.internal.InternalSession.transaction(InternalSession.java:146) 2022/12/12 16:20:13 - select-values-int_to_str - at org.neo4j.driver.internal.InternalSession.writeTransaction(InternalSession.java:124) 2022/12/12 16:20:13 - select-values-int_to_str - at org.neo4j.driver.internal.InternalSession.writeTransaction(InternalSession.java:118) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.registerData(NeoExecutionInfoLocation.java:875) 2022/12/12 16:20:13 - select-values-int_to_str - ... 8 more 2022/12/12 16:20:13 - select-values-int_to_str - Caused by: org.apache.hop.core.exception.HopValueException: 2022/12/12 16:20:13 - select-values-int_to_str - Unexpected conversion error while converting value [id Integer] to an Integer 2022/12/12 16:20:13 - select-values-int_to_str - 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') 2022/12/12 16:20:13 - select-values-int_to_str - 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2368) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.core.row.value.ValueMetaInteger.getNativeDataType(ValueMetaInteger.java:40) 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.neo4j.execution.NeoExecutionInfoLocation.saveNeo4jRowsAndMeta(NeoExecutionInfoLocation.java:1081) 2022/12/12 16:20:13 - select-values-int_to_str - ... 16 more 2022/12/12 16:20:13 - select-values-int_to_str - 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') 2022/12/12 16:20:13 - select-values-int_to_str - at org.apache.hop.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2281) 2022/12/12 16:20:13 - select-values-int_to_str - ... 18 more 2022/12/12 16:20:13 - select-values-int_to_str - Execution finished on a local pipeline engine with run configuration 'local' ``` ### Issue Priority Priority: 3 ### Issue Component Component: Execution Information -- 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]
