1
resposta

Erro no step Insert/Update

Estou tentando fazer um insert do oracle para o bigquery, porém me deparo com este erro no step:

2019/09/25 17:34:43 - Insert / update.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Error in step, asking everyone to stop because of:

2019/09/25 17:34:43 - Insert / update.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:

2019/09/25 17:34:43 - Insert / update.0 - Error inserting/updating row

2019/09/25 17:34:43 - Insert / update.0 - [Simba]JDBC Null pointer exception.

2019/09/25 17:34:43 - Insert / update.0 -

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1324)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1248)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1236)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1224)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2019/09/25 17:34:43 - Insert / update.0 - at java.lang.Thread.run(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - Caused by: java.sql.SQLException: [Simba]JDBC Null pointer exception.

2019/09/25 17:34:43 - Insert / update.0 - at com.simba.googlebigquery.googlebigquery.utils.BQCoreUtils.getParamValueAsText(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - at com.simba.googlebigquery.googlebigquery.dataengine.BQSQLExecutor.execute(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - at com.simba.googlebigquery.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - at com.simba.googlebigquery.jdbc.common.SPreparedStatement.executeAnyUpdate(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - at com.simba.googlebigquery.jdbc.common.SPreparedStatement.executeUpdate(Unknown Source)

2019/09/25 17:34:43 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1291)

2019/09/25 17:34:43 - Insert / update.0 - ... 7 more

2019/09/25 17:34:43 - Insert / update.0 - Caused by: java.lang.NullPointerException

1 resposta

Oi Mariana, tudo bem?

Peço imensas desculpas pela demora no retorno de sua resposta, vamos lá.

A mensagem do erro não deixa claro qual o problema que ocorreu, mas olhando parece ser algo com a query. Se puder compartilhar a query usada no insert para darmos uma olhada, seria uma boa :)