Google表格脚本突然停止工作-错误:“找不到服务:加号v1" [英] Google Sheets Scripts suddenly stop working - Error: "Service not found: plus v1"

问题描述

我建立了一个Google Sheets文档，其中包含许多脚本和触发器.

它在过去的一年中一直完美运行，直到最近.现在，即使对于其他用户，每个功能也不起作用.甚至像这样的简单功能也不起作用:

 function clearForm() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('Manifest');
  sheet.getRange('B4:F4').clearContent();
  sheet.getRange('B7:C10').clearContent();
  sheet.getRange('D14:D28').clearContent();
  sheet.getRange('D30').clearContent();
  sheet.getRange('D36').clearContent();
   sheet.getRange('F14:F28').clearContent();
  sheet.getRange('F30').clearContent();
  sheet.getRange('F36').clearContent();
   sheet.getRange('H14:H28').clearContent();
  sheet.getRange('H30').clearContent();
  sheet.getRange('H36').clearContent();
  sheet.getRange('J14:J28').clearContent();
  sheet.getRange('J30').clearContent();
  sheet.getRange('J36').clearContent();
  sheet.getRange('E4').setValue('Select Tail #');
  sheet.getRange('B42:C42').clearContent();
} 

当我尝试运行此脚本或任何脚本时，收到以下消息:未找到服务:加v1"

有趣的是，使用许多相同编码的另一个Google工作表文件仍然可以完美运行.

我还收到一条消息:该项目正在由Chrome V8驱动的新的Apps Script运行时上运行." 我不确定是否与此有关. >

我在脚本上进行了搜索，并在名为appsscript.json的新标签上找到了此代码

{
  "timeZone": "America/Denver",
  "dependencies": {
    "enabledAdvancedServices": [{
      "userSymbol": "Plus",
      "serviceId": "plus",
      "version": "v1"
    }, {
      "userSymbol": "Drive",
      "serviceId": "drive",
      "version": "v2"
    }]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
}

我不知道这段代码是干什么的，我不记得写过什么.我可以安全地删除它吗?

解决方案

您或拥有脚本编辑权限的任何人已启用Google 加服务.此服务已弃用并关闭.您可以修改清单appsscript.json以将其删除.

{
  "timeZone": "America/Denver",
  "dependencies": {
    "enabledAdvancedServices": [{
      "userSymbol": "Drive",
      "serviceId": "drive",
      "version": "v2"
    }]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
}

I built a Google Sheets document that has lots of scripts and triggers built into it.

It worked for the last year flawlessly until recently. Now every Function does not work, even for other users. Even simple functions such as this does not work:

 function clearForm() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('Manifest');
  sheet.getRange('B4:F4').clearContent();
  sheet.getRange('B7:C10').clearContent();
  sheet.getRange('D14:D28').clearContent();
  sheet.getRange('D30').clearContent();
  sheet.getRange('D36').clearContent();
   sheet.getRange('F14:F28').clearContent();
  sheet.getRange('F30').clearContent();
  sheet.getRange('F36').clearContent();
   sheet.getRange('H14:H28').clearContent();
  sheet.getRange('H30').clearContent();
  sheet.getRange('H36').clearContent();
  sheet.getRange('J14:J28').clearContent();
  sheet.getRange('J30').clearContent();
  sheet.getRange('J36').clearContent();
  sheet.getRange('E4').setValue('Select Tail #');
  sheet.getRange('B42:C42').clearContent();
} 

When I try to run this script or any script, I get this message: "Service not found: plus v1"

What is interesting is that another google sheet file that uses much of the same coding still works perfectly.

I also get a message: "This project is running on our new Apps Script runtime powered by Chrome V8". I am not sure if that has anything to do with it or not.

EDIT:

I did a search on the Scripts and found this code on a new tab called appsscript.json

{
  "timeZone": "America/Denver",
  "dependencies": {
    "enabledAdvancedServices": [{
      "userSymbol": "Plus",
      "serviceId": "plus",
      "version": "v1"
    }, {
      "userSymbol": "Drive",
      "serviceId": "drive",
      "version": "v2"
    }]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
}

I do not know what this code is for and I dont recall writing it. Can I safely delete it?

解决方案

You or anyone with edit access to your script has enabled Google plus service. This service is deprecated and shutdown. You can modify the manifest, appsscript.json to remove it.

{
  "timeZone": "America/Denver",
  "dependencies": {
    "enabledAdvancedServices": [{
      "userSymbol": "Drive",
      "serviceId": "drive",
      "version": "v2"
    }]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
}

这篇关于Google表格脚本突然停止工作-错误:“找不到服务:加号v1"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！