AnsweredAssumed Answered

Help understanding error pentaho google sheets output

Question asked by Dario de Jong on Nov 17, 2017
Latest reply on Nov 29, 2017 by Dario de Jong

Can anyone explain to me what the error message below says? I'm running a transformation which outputs to three google sheets. One of those runs well once, but every second time it gives the following error:

 

ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error
ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException:
java.io.IOException: Error writing to server
Error writing to server

  at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.processRow(GoogleSpreadsheetOutput.java:140)
  at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
  at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: Error writing to server
  at sun.reflect.GeneratedConstructorAccessor447.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  at java.lang.reflect.Constructor.newInstance(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.net.www.protocol.http.HttpURLConnection.getChainedException(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
  at java.net.HttpURLConnection.getResponseCode(Unknown Source)
  at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
  at com.google.gdata.client.http.HttpGDataRequest.isOAuthProxyErrorResponse(HttpGDataRequest.java:569)
  at com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:557)
  at com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:538)
  at com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:536)
  at com.google.gdata.client.Service.batch(Service.java:1454)
  at com.google.gdata.client.GoogleService.batch(GoogleService.java:770)
  at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.batchRequest(GoogleSpreadsheetOutput.java:169)
  at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.processRow(GoogleSpreadsheetOutput.java:129)
  ... 2 more
Caused by: java.io.IOException: Error writing to server
  at sun.net.www.protocol.http.HttpURLConnection.writeRequests(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.writeRequests(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
  at sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source)
  at sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown Source)
  at com.google.gdata.client.http.HttpGDataRequest.isOAuthProxyErrorResponse(HttpGDataRequest.java:566)

Outcomes