Home > database >  Kettle data conversion errors
Kettle data conversion errors

Time:09-25

2015/07/13 13:39:28 - Spoon - transformation already open.
2015/07/13 13:39:28 - Spoon - are open conversion/signed a contract to complete the project...
2015/07/13 13:39:28 - Spoon - began to perform the conversion.
2015/07/13 13:39:28 - signed a contract to complete the project - to transform to remove patch began [signed a contract to complete the project]
2015/07/13 13:39:33 - EPMS. 0 - Finished reading query, closing the connection.
2015/07/13 13:39:33 - field selected. 0 to finish processing (I=0, O=0, 10, R=W=10, U=0, E=0
2015/07/13 13:39:33 - EPMS. 0 to finish processing (I=10, O=0, R=0, W=10, U=0, E=0
2015/07/13 13:39:33 - insert/update. 0 - ERROR (version 5.3.0.0-213, build 1 from the 2015-02-02 _12-17-08 by buildguy) : Unexpected ERROR
2015/07/13 13:39:33 - insert/update. 0 - ERROR (version 5.3.0.0-213, build 1 from the 2015-02-02 _12-17-08 by buildguy) : org. Pentaho. Di. Core. Exception. KettleStepException:
2015/07/13 13:39:33 - insert/update. 0 - Error in step, have everyone to stop because of:
2015/07/13 13:39:33 - insert/update. 0
2015/07/13 13:39:33 - insert/update. 0 - Error inserting/updating the row
2015/07/13 13:39:33 - insert/update. 0 - Data truncation
2015/07/13 13:39:33 - insert/update. 0
2015/07/13 13:39:33 - insert/update. 0
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Trans. Steps. Insertupdate. Insertupdate. The processRow (insertupdate. Java: 313)
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2015/07/13 13:39:33 - insert/update. 0 - at Java. Lang. Thread. The run (619) Thread. Java:
2015/07/13 13:39:33 - insert/update. 0 - under Caused by: org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2015/07/13 13:39:33 - insert/update. 0 - Error inserting/updating the row
2015/07/13 13:39:33 - insert/update. 0 - Data truncation
2015/07/13 13:39:33 - insert/update. 0
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1245). The database Java:
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1169). The database Java:
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1157). The database Java:
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1145). The database Java:
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Trans. Steps. Insertupdate. Insertupdate. LookupValues (insertupdate. Java: 114)
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Trans. Steps. Insertupdate. Insertupdate. The processRow (insertupdate. Java: 299)
2015/07/13 13:39:33 - insert/update. 0 -... 2 more
2015/07/13 13:39:33 - insert/update. 0 - under Caused by: Java, SQL, DataTruncation: Data truncation
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. SQLDiagnostic. AddDiagnostic (SQLDiagnostic. Java: 382)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. TdsCore. TdsErrorToken (TdsCore. Java: 2820)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. TdsCore. NextToken (TdsCore. Java: 2258)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. TdsCore. GetMoreResults (TdsCore. Java: 632)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. JtdsStatement. ProcessResults (JtdsStatement. Java: 584)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. JtdsStatement. The executeSQL (JtdsStatement. Java: 546)
2015/07/13 13:39:33 - insert/update. 0 - at net. The sourceforge.. JTDS JDBC. JtdsPreparedStatement. ExecuteUpdate (JtdsPreparedStatement. Java: 504)
2015/07/13 13:39:33 - insert/update. 0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1212). The database Java:
2015/07/13 13:39:33 - insert/update. 0 -... 7 more
2015/07/13 13:39:33 - insert/update. 0 to finish processing (I=1, O=0, R=1, W=0, U=0, E=1
2015/07/13 13:39:33 - signed a contract to complete the project - ERROR (version 5.3.0.0-213, build 1 from the 2015-02-02 _12-17-08 by buildguy) : ERROR is detected!
2015/07/13 13:39:33 - Spoon - conversion completed!!!!!
2015/07/13 13:39:33 - signed a contract to complete the project - ERROR (version 5.3.0.0-213, build 1 from the 2015-02-02 _12-17-08 by buildguy) : ERROR is detected!
2015/07/13 13:39:33 - signed a contract to complete the project - ERROR (version 5.3.0.0-213, build 1 from the 2015-02-02 _12-17-08 by buildguy) : ERROR is detected!
2015/07/13 13:39:33 - signed a contract to complete the project - conversion is detected
2015/07/13 13:39:33 - signed a contract to complete the project - conversion is killing other steps!

CodePudding user response:

The configured, click run the newspaper error! First contact kettle, please everyone a great god what is this wrong, is beyond the article use the number? Or what?

CodePudding user response:

I also met the same problem, solved?

CodePudding user response:

The table is locked, I have met
  • Related