Error setting value / Unexepected conversion error

[luisc9]

Hello there!

I use Keetle - Spoon version 3.2.0-RC1. I have a job with a several jobs and transformations, and one of them makes an update on a MS SQL 2005 table.

I got the error:

2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected error :
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleStepException:
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error in step, asking everyone to stop because of:
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : offending row : [IdDailyNews Integer(9)]
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error setting value #1 [IdDailyNews Integer(9)] on prepared statement (Integer)
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/05 12:28:18 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long

Could you please help me on this?.

Regards,
Luis

[MattCasters]

You managed to mix data types somehow.
Playing with JavaScript perhaps? Something like that?

[luisc9]

Matt:

First: thanks for the quick answer... this is urgent...

Yes, I guess so: there's somewhere a type mistmatch... but I don't see where... maybe you or someone else can help me... I attach the transformation and a screenshot...

The only Javascript I use is to define a variable, and to detect an error...

Thanks again,
Luis

[MattCasters]

Try to run in Safe mode, see what that gives you.

[luisc9]

Hello again Matt!

I run the job in Safe Mode... but unfortunately, I got the same errors:

2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected error :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleStepException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error in step, asking everyone to stop because of:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : offending row : [IdDailyNews Integer(9)]
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error setting value #1 [IdDailyNews Integer(9)] on prepared statement (Integer)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:291)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2862)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.run(InsertUpdate.java:487)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : offending row : [IdDailyNews Integer(9)]
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error setting value #1 [IdDailyNews Integer(9)] on prepared statement (Integer)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.database.Database.setValues(Database.java:1058)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:75)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:274)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : ... 2 more
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Error setting value #1 [IdDailyNews Integer(9)] on prepared statement (Integer)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.database.Database.setValue(Database.java:1035)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.database.Database.setValues(Database.java:1054)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : ... 4 more
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Caused by: org.pentaho.di.core.exception.KettleValueException:
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Unexpected conversion error while converting value [IdDailyNews Integer(9)] to an Integer
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) :
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1499)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.database.Database.setValue(Database.java:880)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : ... 5 more
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Caused by: java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Long
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1444)
2009/05/06 11:02:41 - Insert / Update.0 - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : ... 6 more
2009/05/06 11:02:41 - C29ANTC1UpdateCardChange - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Errors detected!
2009/05/06 11:02:41 - C29ANTC1UpdateCardChange - ERROR (version 3.2.0-RC1, build 10482 from 2009-03-30 11.47.00 by tomcat) : Errors detected!

[MattCasters]

OK then, mouse over the 3 steps feeding the "Insert/Update" step. Hit space 3 times and verify that the row layout is 3 times exactly the same.

[luisc9]

Dear Matt:

Thank you very much!

Indeed, the Update step received different rows from the 3 previous steps. So I duplicated a Selected Values Step, and voilá! :-)

Thanks again for your help.

Luis