I'm using Pentaho to create a report and output it to google sheets. After an X amount of runs I'm getting an error writing to server. As I'm not really good at reading logs I have no idea as to what might be wrong. Any input is more than welcome!
2017/11/17 15:10:25 - Output eventlog.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error 2017/11/17 15:10:25 - Output eventlog.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2017/11/17 15:10:25 - Output eventlog.0 - java.io.IOException: Error writing to server 2017/11/17 15:10:25 - Output eventlog.0 - Error writing to server 2017/11/17 15:10:25 - Output eventlog.0 - 2017/11/17 15:10:25 - Output eventlog.0 - at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.processRow(GoogleSpreadsheetOutput.java:140) 2017/11/17 15:10:25 - Output eventlog.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2017/11/17 15:10:25 - Output eventlog.0 - at java.lang.Thread.run(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - Caused by: java.io.IOException: Error writing to server 2017/11/17 15:10:25 - Output eventlog.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at java.lang.reflect.Constructor.newInstance(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at java.security.AccessController.doPrivileged(Native Method) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.getChainedException(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at java.net.HttpURLConnection.getResponseCode(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.http.HttpGDataRequest.isOAuthProxyErrorResponse(HttpGDataRequest.java:569) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:557) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:538) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:536) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.Service.batch(Service.java:1454) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.GoogleService.batch(GoogleService.java:770) 2017/11/17 15:10:25 - Output eventlog.0 - at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.batchRequest(GoogleSpreadsheetOutput.java:169) 2017/11/17 15:10:25 - Output eventlog.0 - at org.ccci.gto.pdi.trans.steps.googlespreadsheet.GoogleSpreadsheetOutput.processRow(GoogleSpreadsheetOutput.java:129) 2017/11/17 15:10:25 - Output eventlog.0 - ... 2 more 2017/11/17 15:10:25 - Output eventlog.0 - Caused by: java.io.IOException: Error writing to server 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.writeRequests(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.writeRequests(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown Source) 2017/11/17 15:10:25 - Output eventlog.0 - at com.google.gdata.client.http.HttpGDataRequest.isOAuthProxyErrorResponse(HttpGDataRequest.java:566) 2017/11/17 15:10:25 - Output eventlog.0 - ... 9 more -- *Logitech Europe SA* in Nijmegen is a branch of Logitech Europe SA. Seat: Takenhofplein 3, 6538 SZ Nijmegen Commercial Register: 10144574 -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
