2017-05-01 13:06:50,281 ERROR [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue6115) Connector worker process failed for atomic-request=aIZp7iNA7Bwn.0.1.2519: org.teiid.translator.google.api.SpreadsheetOperationException: Error when getting batch 401:Unauthorized
  at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:249)
  at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDataProtocolAPI.java:155)
  at org.teiid.translator.google.api.result.RowsResult$BatchingRowIterator.hasNext(RowsResult.java:83)
  at org.teiid.translator.google.SpreadsheetQueryExecution.next(SpreadsheetQueryExecution.java:79)
  at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
  at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
  at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
  at com.sun.proxy.$Proxy28.more(Unknown Source)
  at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
  at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
  at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
  at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
  at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
  at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at java.lang.Thread.run(Thread.java:748)

2017-05-01 13:06:50,283 WARN  [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue6116) TEIID30020 Processing exception for request aIZp7iNA7Bwn.0 'TEIID30504 Source: Error when getting batch 401:Unauthorized'. Originally TeiidProcessingException GoogleDataProtocolAPI.java:249. Enable more detailed logging to see the entire stacktrace.