将值[ BigNumber ]转换为BigNumber时出现意外转换错误

Question

我正在从查找中获取字段X，并尝试使用Insert/Update将其加载到表中。但是我收到一个错误，说“将值BigNumber转换为BigNumber时出现意外的转换错误”，我甚至使用了select值，并给出了大数字类型，但仍然不起作用。有什么建议吗？

Insert / update.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error in step, asking everyone to stop because of:
2019/04/13 18:48:37 - Insert / update.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2019/04/13 18:48:37 - Insert / update.0 - offending row : [visitGroupRefnum BigNumber], [visitRefnum BigNumber], [questionRefnum BigNumber], [answerid Integer(9)]
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - Error setting value #3 [BigNumber] on prepared statement
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - Unexpected conversion error while converting value [questionRefnum BigNumber] to a BigNumber
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.database.Database.setValues(Database.java:1076)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:83)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2019/04/13 18:48:37 - Insert / update.0 -   at java.lang.Thread.run(Thread.java:748)
2019/04/13 18:48:37 - Insert / update.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
2019/04/13 18:48:37 - Insert / update.0 - Error setting value #3 [BigNumber] on prepared statement
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - Unexpected conversion error while converting value [questionRefnum BigNumber] to a BigNumber
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5473)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.database.Database.setValue(Database.java:1058)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.database.Database.setValues(Database.java:1074)
2019/04/13 18:48:37 - Insert / update.0 -   ... 4 more
2019/04/13 18:48:37 - Insert / update.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 
2019/04/13 18:48:37 - Insert / update.0 - Unexpected conversion error while converting value [questionRefnum BigNumber] to a BigNumber
2019/04/13 18:48:37 - Insert / update.0 - 
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.row.value.ValueMetaBase.getBigNumber(ValueMetaBase.java:2205)
2019/04/13 18:48:37 - Insert / update.0 -   at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5455)
2019/04/13 18:48:37 - Insert / update.0 -   ... 6 more
2019/04/13 18:48:37 - Insert / update.0 - Caused by: java.lang.ClassCastException

Answer 1

您的PDI转换正在解析标题行。它试图将文字字符串"questionRefnum“转换为数字。如果您正在从文件读取，请确保您设置了正确的标题行数。