Error In Step Asking Everyone To Stop Because Of
View Site Leaders Advanced Search Forum Pentaho Users Pentaho Data Integration [Kettle] Insert/Update Step error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: Insert/Update Step error Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-29-2008,02:58 AM #1 andrea.mirandola View Profile View Forum Posts Private Message Junior Member Join Date Jan 2008 Posts 1 Insert/Update Step error Hi I have a strange problem with the new version of Pentaho data Integration. I created a simple transformation trhat extract data from a table and Insert/Update this data in a different one. It works fine for some records but, after a few, it giìves an error that is: 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : java.lang.ClassCastException: java.lang.Long cannot be cast to java.math.BigDecimal 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.getBigNumber(ValueMeta.java:1461) 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2843) 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:127) 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:272) 2008/01/29 08:53:16 - DIM_CUSTOMER_NEW.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.run(InsertUpdate.java:490) The strange thing is that in the old version it works fine! I checked the definiton of the table and the data in the tables but all seems to be right... and some records really works! Any Idea? many thanks Andrea Reply With Quote 01-29-2008,03:02 AM #2 sboden View Profile View Forum Posts Private Message Senior Member Join Date May 2006 Posts 4,882 I would suggest to try one of the nightly builds... the problem looks familiar, that one is probably fixed. Regards, Sven Reply With Quote 0
TABLE OUTPUT and INSERT/UPDATE step Agile Board ExportXMLWordPrintable Details Type: Bug Status: Closed Severity: High Resolution: Incomplete Affects Version/s: 5.0.4 GA Fix Version/s: None Component/s: Database, Step, Transformation Labels: None PDI Sub-component: InsertUpdate TableOutput Notice: When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in. Operating System/s: Windows 7 Description Hi Team, I am a new user of pentaho kettle. I am trying to use TABLE OUTPUT and INSERT/UPDATE step in my transformation. The data http://forums.pentaho.com/showthread.php?59453-Insert-Update-Step-error base is Oracle. I am not able to insert or update record to database. Please help with possible reasons and solutions for such issues. I am getting below error: 2014/03/31 13:18:36 - General - Logging plugin type found with ID: CheckpointLogTable 2014/03/31 13:18:43 - General - Starting agile-bi 2014/03/31 13:18:43 - Spoon - Asking for repository 2014/03/31 13:18:47 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2014/03/31 http://jira.pentaho.com/browse/PDI-11894?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab 13:22:40 - Spoon - Transformation opened. 2014/03/31 13:22:40 - Spoon - Launching transformation [insert update]... 2014/03/31 13:22:40 - Spoon - Started the transformation execution. 2014/03/31 13:22:41 - insert update - Dispatching started for transformation [insert update] 2014/03/31 13:22:48 - Table input.0 - Finished reading query, closing connection. 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Unexpected error 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2014/03/31 13:22:48 - Insert / Update.0 - Error in step, asking everyone to stop because of: 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:318) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/03/31 13:22:48 - Insert / Update.0 - at java.lang.Thread.run(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 20
help others org.pentaho.di.core.exception.KettleStepException: Error in step, asking everyone to stop because of: offending row : [Folio_Number String(17)], [#Beds Integer(15)], error in [#FBaths Integer(15)], [#HBaths Integer(15)], [#HBaths_1 Integer(15)], [Address String(25)], [Approx._Sqft_Total_Area Integer(15)], [Approximate_Lot_Size String(10)], [Area String(15)], [City___Original String(35)], [City_Name String(35)], [Closing_Date String(19)], [Compass_Point String(2)], [Compass_Point_1 String(9)], [Construction_Type String(67)], [County String(17)], [Dade_Assessed_$/SOH_Value Integer(15)], [Dade_Market_$/Assessed_$ Integer(15)], error in step [Days_on_Market Integer(15)], [Design String(8)], [Design_Description String(37)], [Development_Name String(20)], [Elementary_School String(13)], [Geographic_Area String(51)], [I# Integer(15)], [IDX String(3)], [Last_Transaction_Date String(19)], [List_Price Integer(15)], [Listing_Type String(23)], [Lot_Description String(64)], [Map_Coordinates Integer(15)], [Map_Coordinates_1 String], [ML# String(9)], [Model_Name String(18)], [Municipal_Code Integer(15)], [Occupancy_Information String(18)], [Parcel_Number Integer(15)], [Property_SqFt Integer(15)], [Property_Type String(13)], [Remarks String(510)], [Sale_Price Integer(15)], [Sale_Terms String(12)], [Section Integer(15)], [Serial_Number String], [Special_Information String(71)], [SqFt_L.A._of_Guest_House Integer(15)], [SqFt_Liv_Area Integer(15)], [State String(7)], [Status String(16)], [Street_Name String(20)], [Street_Number Integer(15)], [Street_Suffix String], [Subdivision_Information String(61)], [Subdivision_Name String(25)], [Subdivision_Number Integer(15)], [Tax_Amount Integer(15)], [Tax_Information String(78)], [Tax_Year Integer(15)], [Township/Range Integer(15)], [Unit_Number String], [Type_of_Property String(6)], [Type_of_Contingencies String], [Waterfront_Property_(Y/N) String(3)], [Water_Access String(60)], [Year_Built Inte
von GoogleAnmeldenAusgeblendete FelderBooksbooks.google.de - Describes 3 studies investigating the accuracy of subjects' self-report about cigarette smoking: (1) examines the way in which smokers answer questions about the number of cigarettes they smoke; (2) addresses the issue of social desirability effects; (3) interviews participants from a 1981-82 study of...https://books.google.de/books/about/Cognitive_Research_on_Response_Error_in.html?hl=de&id=OlOPS7_iaVQC&utm_source=gb-gplus-shareCognitive Research on Response Error in Survey Questions on SmokingMeine BücherHilfeErweiterte BuchsucheDruckversionKein E-Book verfügbarDIANE PublishingAmazon.deBuch.deBuchkatalog.deLibri.deWeltbild.deIn Bücherei suchenAlle Händler»Stöbere bei Google Play nach Büchern.Stöbere im größten eBookstore der Welt und lies noch heute im Web, auf deinem Tablet, Telefon oder E-Reader.Weiter zu Google Play »Cognitive Research on Response Error in Survey Questions on SmokingDIANE Publishing, 01.08.1992 - 97 Seiten 0 Rezensionenhttps://books.google.de/books/about/Cognitive_Research_on_Response_Error_in.html?hl=de&id=OlOPS7_iaVQCDescribes 3 studies investigating the accuracy of subjects' self-report about cigarette smoking: (1) examines the way in which smokers answer questions about the number of cigarettes they smoke; (2) addresses the issue of social desirability effects; (3) interviews participants from a 1981-82 study of people who complete a stop-smoking program about their smoking histories. Voransicht des Buches » Was andere dazu sagen-Rezension schreibenEs wurden keine Rezensionen gefunden.Ausgewählte SeitenSeite 63Seite 20Seite 65TitelseiteInhaltsverzeichnisInhaltIntroduction1 Review2 Estimating frequency of cigarette smoking7 Social desirability and reports of smoking17 Longterm recall of smoking activity22 References33 Appendixes35 Study 1 Recruiting and screening36 Study 1 Initial interview protocol38 Study 1 Second interview protocols by condition48 Study 3 Respondents locating and recruitment procedures80 Study 3 Interview protocols by