APROX_MERGE_JOIN Error

smcdonald

• July 15, 2008 00:00

• Answered

Follow

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:

<Node enabled="enabled" guiHeight="0" guiName="Citizen Filter" guiWidth="0" guiX="3945" guiY="716" id="APROX_MERGE_JOIN11" joinKey="memidnum 10 1.0 true false false false" matchingKey="memidnum" type="APROX_MERGE_JOIN">
<attr name="transform"><![CDATA[try
${out.0.memidnum} = ${in.0.memidnum};
${out.0.SourceCode} = ${in.0.SourceCode};
${out.0.Child} = ${in.0.Child};
${out.0.sendToContactPoint} = ${in.0.sendToContactPoint};
${out.0.ShieldedRecordNotification} = ${in.0.ShieldedRecordNotification};
${out.0.LeftEnglandNotificationIntentionNotToReturn} = ${in.0.LeftEnglandNotificationIntentionNotToReturn};
${out.0.AccountableBody} = ${in.0.AccountableBody};
${out.0.AdultTransitionDate} = ${in.0.AdultTransitionDate};
${out.0.DeleteFlag} = ${in.0.DeleteFlag};
]]></attr>
<attr name="transformForSuspicious"><![CDATA[try
${out.0.memidnum} = ${in.0.memidnum};
${out.0.memrecno} = ${in.1.memrecno};
${out.0.srccode} = ${in.1.srccode};
${out.0.hold_overlay} = ${in.1.hold_overlay};
${out.0.hold_reviewid} = ${in.1.hold_reviewid};
${out.0.q_status} = ${in.1.q_status};
${out.0.q_delete} = ${in.1.q_delete};
${out.0.q_timestamp} = ${in.1.q_timestamp};
${out.0.l_timestamp} = ${in.1.l_timestamp};
${out.0.r_timestamp} = ${in.1.r_timestamp};
${out.0.validation} = ${in.1.validation};
${out.0.matching} = ${in.1.matching};
]]></attr>
</Node>


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

• 

  jurban

  • July 15, 2008 16:05

  0

  Comment actions Permalink

  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
• 

  smcdonald

  • July 15, 2008 16:13

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.