Infrastructure Solutions

 View Only

Error adding table to mysql database 

03-26-2022 06:10

Hai guys, how to fix it? how to fix it? why can't i add table to database?


2022/03/26 16:55:13 - dosen db.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Because of an error, this step can't continue:
2022/03/26 16:55:13 - dosen db.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2022/03/26 16:55:13 - dosen db.0 - Unexpected conversion error while converting value [nidn String] to an Integer
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - nidn String : couldn't convert String to Integer
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - nidn String : couldn't convert String to number : non-numeric character found at position 1 for value [-]
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2131)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3868)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertBinaryStringToNativeType(ValueMetaBase.java:1621)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:1845)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:329)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:864)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:384)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/03/26 16:55:13 - dosen db.0 - at java.lang.Thread.run(Unknown Source)
2022/03/26 16:55:13 - dosen db.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2022/03/26 16:55:13 - dosen db.0 - nidn String : couldn't convert String to Integer
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - nidn String : couldn't convert String to number : non-numeric character found at position 1 for value [-]
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1355)
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2069)
2022/03/26 16:55:13 - dosen db.0 - ... 9 more
2022/03/26 16:55:13 - dosen db.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2022/03/26 16:55:13 - dosen db.0 - nidn String : couldn't convert String to number : non-numeric character found at position 1 for value [-]
2022/03/26 16:55:13 - dosen db.0 -
2022/03/26 16:55:13 - dosen db.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1349)
2022/03/26 16:55:13 - dosen db.0 - ... 10 more
2022/03/26 16:55:13 - dosen db.0 - Finished processing (I=0, O=50, R=51, W=0, U=0, E=1)
2022/03/26 16:55:13 - dosen db - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Errors detected!
2022/03/26 16:55:13 - Spoon - The transformation has finished!!
2022/03/26 16:55:13 - dosen db - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Errors detected!
2022/03/26 16:55:13 - dosen db - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Errors detected!
2022/03/26 16:55:13 - dosen db - Transformation detected one or more steps with errors.
2022/03/26 16:55:13 - dosen db - Transformation is killing the other steps!

Statistics
0 Favorited
1 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
png file
error.png   129 KB   1 version
Uploaded - 03-26-2022

Related Entries and Links

No Related Resource entered.