You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by GitBox <gi...@apache.org> on 2022/12/12 15:38:40 UTC
[GitHub] [hop] enricomariam42 opened a new issue, #2054: [Bug]: Select value cast int to str causes exception saving Execution Information
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: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org