APROX_MERGE_JOIN Error

Hi Everyone

This is my first post on this forum so please bear with me.

I have created quite a large graph that reads several CSV files and the uses APROX_MERGE_JOIN to filter out data records using an identifier key.

See section of the graph below:

When it runs I some times get the following error message, when I say some times I mean that it will run the first time but if I edit the graph else where I get the error message below, but if I edit the APROX_MERGE_JOIN but don’t actual change anything and save it to recompile the error goes away. But this error also happens some times when I haven’t edited the graph.

Node APROX_MERGE_JOIN11 error details:
org.jetel.exception.TransformException: Record number: 0, field number: 0. Message: Error in extern transformation class TransformTransformAPROX_MERGE_JOIN11: 6 at TransformTransformAPROX_MERGE_JOIN11.transform(TransformTransformAPROX_MERGE_JOIN11.java:72)
at org.jetel.component.AproxMergeJoin.flushCombinations(AproxMergeJoin.java:416)
at org.jetel.component.AproxMergeJoin.execute(AproxMergeJoin.java:532)
at org.jetel.graph.Node.run(Node.java:371)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)

Any one got any ideas what this error message could point to, not sure why it only happens ocasionaly, the test data that I’m using is always the same.

Thanks

Stuart

Hi,
is that the complete error log? Also, I can see a “try” statement in you transformation, withouth its own { and } brackets, maybe you should fill them in.

jaro

I have removed the try statment missed that from what i posted, i removed it as it made no difference to the outcome. error log below

Sucessfully started all nodes in phase!
15:57:30,039 ERROR [WatchDog] - !!! Fatal Error !!! - graph execution is aborting
15:57:30,039 ERROR [WatchDog] - Node APROX_MERGE_JOIN11 finished with status: Error occurred in nested transformation: ERROR caused by: Record number: 0, field number: 0. Message: Error in extern transformation class TransformTransformAPROX_MERGE_JOIN11: 6
15:57:30,179 DEBUG [WatchDog] - Node APROX_MERGE_JOIN11 error details:
org.jetel.exception.TransformException: Record number: 0, field number: 0. Message: Error in extern transformation class TransformTransformAPROX_MERGE_JOIN11: 6
at TransformTransformAPROX_MERGE_JOIN11.transform(TransformTransformAPROX_MERGE_JOIN11.java:72)
at org.jetel.component.AproxMergeJoin.flushCombinations(AproxMergeJoin.java:416)
at org.jetel.component.AproxMergeJoin.execute(AproxMergeJoin.java:532)
at org.jetel.graph.Node.run(Node.java:371)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
15:57:30,257 WARN [WatchDog] - Interrupted node: APROX_MERGE_JOIN11