luisc9
05-05-2009, 03:42 PM
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
05-05-2009, 04:40 PM
You managed to mix data types somehow.
Playing with JavaScript perhaps? Something like that?
luisc9
05-06-2009, 09:10 AM
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
05-06-2009, 09:53 AM
Try to run in Safe mode, see what that gives you.
luisc9
05-06-2009, 02:06 PM
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
05-06-2009, 02:10 PM
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
05-07-2009, 10:15 AM
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