Want to share a problem I had as it might be useful to others:

I have a transformation using a Scripting/Modified Java Script Value step. When I was executing it from XML files, it was working correctly but from a MySQL database repository I got this error:

Code:
2009/07/20 16:27:09 - init.0 - No tran_Status found. Transformation status checking not available.
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Javascript error: 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Javascript error: 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.mozilla.javascript.NativeString cannot be cast to java.lang.Number
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:436)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Javascript error: 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.mozilla.javascript.NativeString cannot be cast to java.lang.Number
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.getValueFromJScript(ScriptValuesMod.java:620)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:382)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     ... 3 more
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.ClassCastException: org.mozilla.javascript.NativeString cannot be cast to java.lang.Number
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.getValueFromJScript(ScriptValuesMod.java:466)
2009/07/20 16:27:09 - init.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     ... 4 more
2009/07/20 16:27:09 - extract_get_range - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
2009/07/20 16:27:09 - init.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
Cause for this error was an output field which had a datatype of Number(16,2) as a result of using the "Get variables" button. As I said, it was working from XML files but not with an MySQL repository. After changing the datatype to Integer the error was gone.