pentaho error PDI using spoon with mysql

Question

pentaho error PDI using spoon with mysql

Navigation

#1 by (0 votes)

0

make a successful connection to a Mysql database but when I try to make a new transformation using a table_input when I click on preview I get the following error.

2018/06/29 15:12:10 - Carte - Installing timer to purge stale objects after 240 minutes. 2018/06/29 15:12:10 - Carte - Installing timer to Purge stale objects after 240 minutes. 2018/06/29 20:13:00 - org.pentaho.di.trans.steps.insertupdate.InsertUpdateMeta@23c736ad - ERROR (version 8.0.0.0-28-16, build 8.0.0.0-28-16 from 2018-05-17 06.25.25 by jenkins): Unable to get fields from previous steps because of an error 2018/06/30 16:54:09 - / Transformation 1 - Dispatching started for transformation [/ Transformation 1] 2018/06/30 16:54:09 - Table input.0 - ERROR (version 8.0.0.0-28-16, build 8.0.0.0-28-16 from 2018-05-17 06.25.25 by jenkins): Unexpected error 2018/06/30 16:54:09 - Table input.0 - ERROR (version 8.0.0.0-28-16, build 8.0.0.0-28-16 from 2018-05-17 06.25.25 by jenkins): org.pentaho.di.core.exception.KettleDatabaseException: 2018/06/30 16:54:09 - Table input.0 - Could not get row from result set 2018/06/30 16:54:09 - Table input.0 - 2018/06/30 16:54:09 - Table input.0 - Unable to get value 'Date' from database resultset, index 18 2018/06/30 16:54:09 - Table input.0 - Value '5731766130941153 2018/06/30 16:54:09 - Table input.0 - 1523632184 JAZMIN VARGAS 2018/06/30 16:54:09 - Table input.0 - 2018-04-1310: 10: 0710: 21: 22

pentaho-spoon

asked by devycastiblanco 30.06.2018 в 19:12

source

1 answer

Queryset with 2 fields of a table - Django Rest Framework Check stock of an inventory product with Ruby on Rails

score 0 · Answer 1

Your table input expects a date on column 18 that has the wrong format. Read it as a String and convert it on the next step with the Metadata tab of a Select field step.

The entry in your table expects a date in column 18 that has the wrong format. Read it as typo String and convert it to the next step (Step) with the% tab Metadatos step Seleccionar columnas . [Google translation]