Possible bug with Translate Word munge

hello,

When I try to add a translate word munge I have this error:

java.lang.RuntimeException: Error generating munge step component: ca.sqlpower.matchmaker.swingui.munge.TranslateWordMungeComponent. Possibly caused by an error thrown in the constructor.
	at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:612)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen$MungePenMungeProcessListener.mmChildrenInserted(MungePen.java:812)
	at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:219)
	at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:175)
	at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addImpl(AbstractMatchMakerObject.java:106)
	at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:280)
	at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:38)
	at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addChild(AbstractMatchMakerObject.java:77)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen.addMungeStep(MungePen.java:586)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen.drop(MungePen.java:1067)
	at java.awt.dnd.DropTarget.drop(Unknown Source)
	at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)
	at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)
	at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)
	at sun.awt.dnd.SunDropTargetEvent.dispatch(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processDropTargetEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:610)
	... 30 more
Caused by: java.lang.RuntimeException: Failed to refresh step Translate Words
	at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMungeComponent.java:255)
	at ca.sqlpower.matchmaker.swingui.munge.TranslateWordMungeComponent.<init>(TranslateWordMungeComponent.java:49)
	... 35 more
Caused by: java.lang.NumberFormatException: null
	at java.lang.Long.parseLong(Unknown Source)
	at java.lang.Long.valueOf(Unknown Source)
	at ca.sqlpower.matchmaker.munge.TranslateWordMungeStep.doOpen(TranslateWordMungeStep.java:152)
	at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:502)
	at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:480)
	at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMungeComponent.java:251)
	... 36 more

The munge component doesn't appear at the screen but it is created in my repository database. I have to remove the row manually because each time I try to open my transformation process the error appear.

Here is my config :

DQguru 0.9.5
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Windows XP 5.1 (x86)

Runtime Environment:
Java(TM) SE Runtime Environment
1.6.0_12-b04

VM info:
Java HotSpot(TM) Client VM
11.2-b01
Sun Microsystems Inc.

Memory:
337MiB allocated (1488MiB max); 39MiB free

Thanks in advance for your help.

Looks like this is a bug that's being caused by a change made to the code back in early March. This may have also broken some of the other steps.

Ok,
Do you need more info?
Could you keep me inform?

Simon

This message was edited 1 time. Last update was at 2010-01-07 02:50:35

I also bumped on this.
Any update? Any work-around?

What's the best way to isolate the problem?

This message was edited 1 time. Last update was at 2010-01-07 06:58:07

Found a work-around:
1. add the 'Translate Word' step to transformation and save it;
2. open repository table 'mm_munge_step_parameter';
3. add new line to table with:
a. 'munge_step_oid' = step 'munge_step_oid' in 'mm_munge_step'
b. 'parameter_name' = "translateGroupOid";
c. 'parameter_value' = 'translate_group_oid' in 'pl_match_translate_group';

Don't blame me if your repository gets corrupted because of this hack