# APROX\_MERGE\_JOIN Error

**URL:** <https://forum.cloverdx.com/t/aprox-merge-join-error/354>\
**Category:** CloverDX Platform\
**Created:** [July 15, 2008, 12:00am UTC](https://forum.cloverdx.com/t/aprox-merge-join-error/354 "2008-07-15T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![smcdonald](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@smcdonald](https://forum.cloverdx.com/u/smcdonald)\
**Post date:** [July 15, 2008, 12:00am UTC](https://forum.cloverdx.com/t/aprox-merge-join-error/354/1 "2008-07-15T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [July 15, 2008, 4:05pm UTC](https://forum.cloverdx.com/t/aprox-merge-join-error/354/2 "2008-07-15T16:05:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![smcdonald](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@smcdonald](https://forum.cloverdx.com/u/smcdonald)\
**Post date:** [July 15, 2008, 4:13pm UTC](https://forum.cloverdx.com/t/aprox-merge-join-error/354/3 "2008-07-15T16:13:58Z")

</div>

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