2021-02-23 15:09:06.646  INFO 6 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-1, groupId=universal-google-sheets-adapter-app-sandbox] (Re-)joining group
2021-02-23 15:09:13.708  INFO 6 --- [   scheduling-1] t.i.a.adapter.task.GoogleSheetsLoadTask  : 1 tasks are loaded; duplicates 0, campaignId 5f7ec41f78cf77dfed8b3278
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
POST https://sheets.googleapis.com/v4/spreadsheets/1sOIROZpj_URWLsu4nj-Lr9OrnNADM8XhoEB55-W2-EE:batchUpdate
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Invalid requests[0].deleteDimension: No grid with id: 0",
    "reason" : "badRequest"
  } ],
  "message" : "Invalid requests[0].deleteDimension: No grid with id: 0",
  "status" : "INVALID_ARGUMENT"
}
    at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:150)
    at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
    at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:417)
    at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
    at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.deleteRows(GoogleSheetsServiceImpl.java:44)
    at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.removeTop(DatabaseListServiceImpl.java:57)
    at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:39)
    at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
2021-02-23 15:09:14.434  WARN 6 --- [   scheduling-1] t.i.a.adapter.task.GoogleSheetsLoadTask  : databaseListService.removeTop error; cannot continue; campaignId 5f7ec41f78cf77dfed8b3278
2021-02-23 15:09:30.345  INFO 6 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-1, groupId=universal-google-sheets-adapter-app-sandbox] Successfully joined group with generation 15
2021-02-23 15:09:30.349  INFO 6 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-1, groupId=universal-google-sheets-adapter-app-sandbox] Setting newly assigned partitions: app-vis_ct_state_changed-0
2021-02-23 15:09:30.361  INFO 6 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-1, groupId=universal-google-sheets-adapter-app-sandbox] Setting offset for partition app-vis_ct_state_changed-0 to the committed offset FetchPosition{offset=315390, offsetEpoch=Optional.empty, currentLeader=LeaderAndEpoch{leader=kafka:9092 (id: 1001 rack: null), epoch=-1}}
2021-02-23 15:09:30.368  INFO 6 --- [ntainer#0-0-C-1] o.s.k.l.KafkaMessageListenerContainer    : universal-google-sheets-adapter-app-sandbox: partitions assigned: [app-vis_ct_state_changed-0]
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
POST https://sheets.googleapis.com/v4/spreadsheets/1sOIROZpj_URWLsu4nj-Lr9OrnNADM8XhoEB55-W2-EE:batchUpdate
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Invalid requests[0].deleteDimension: No grid with id: 0",
    "reason" : "badRequest"
  } ],
  "message" : "Invalid requests[0].deleteDimension: No grid with id: 0",
  "status" : "INVALID_ARGUMENT"
}
    at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:150)
    at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
    at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:417)
    at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
    at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.deleteRows(GoogleSheetsServiceImpl.java:44)
    at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.removeTop(DatabaseListServiceImpl.java:57)
    at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:39)
    at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2021-02-23 15:09:44.905  WARN 6 --- [   scheduling-1] t.i.a.adapter.task.GoogleSheetsLoadTask  : databaseListService.removeTop error; cannot continue; campaignId 5f7ec41f78cf77dfed8b3278
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
POST https://sheets.googleapis.com/v4/spreadsheets/1sOIROZpj_URWLsu4nj-Lr9OrnNADM8XhoEB55-W2-EE:batchUpdate