IssueTracker

Please provide the following additional information:

Please mention the steps to be followed for reproducing the issue with the given sample apk.

Android bug report capturing

After reproducing the issue, press the volume up, volume down, and power button simultaneously. This will capture a bug report on your device in the “bug reports” directory.

Alternate method

Navigate to “Developer options”, ensure “USB debugging” is enabled, then enable “Bug report shortcut”. Capture bug report by holding the power button and selecting the “Take bug report” option.

Screen record of the issue, for clarity
Please capture screen record or video of the issue using following steps:
adb shell screenrecord /sdcard/video.mp4
Subsequently use following command to pull the recorded file:
adb pull /sdcard/video.mp4

Note: Please upload the files to google drive and share the folder to android-bugreport@google.com, then share the link here.

The problem is not with some specific code. The problem is that when an App published on the Marketplace creates triggers – they get removed randomly.
There's no specific code that can be provided to reproduce this.

Hi, we were able to reproduce this with a new very simple project (see code below).
One important thing to note: THIS CAN ONLY BE REPRODUCED IF THE PROJECT IS PUBLISHED AS A SHEETS ADD-ON.

Here are the steps we used to reproduce the problem:
1. Create 3 blank G-Sheets documents and create hourly trigger in each document via “Create Trigger” menu (see create-trigger-menu.png)
2. Make sure all triggers run, in our case they ran 5 times during 5 hours (see triggers-list.png)
3. Go to “Edit trigger” window and just press “Save” button. We did it for the first two triggers (see modify-trigger.png)
4. This caused the 2 triggers to stop and never fire again. The trigger ids are 6CFa7J1dRkeWfK4PbHAHHA and WHAd1CcdSbqeGSlO74qwxg.
The 3rd trigger is still running, id =c1et5snyQPCZJCGmCYYfKQ. See triggers-stopped.png

Please see the test add-on code below.
 

Code.gs:

 

function createTrigger ()

{

  var triggerId = ScriptApp.newTrigger("runTrigger").timeBased().everyHours(1).create().getUniqueId();

  SpreadsheetApp.getUi().alert('Trigger created Id=' + triggerId);

}

 

function removeTriggers ()

{

  removeUserTriggers();

  removeProjectTriggers();

}

 

function removeUserTriggers ()

{

  ScriptApp.getUserTriggers(SpreadsheetApp.getActiveSpreadsheet()).forEach(function (trigger) {

    if (trigger)

    {

      var id = trigger.getUniqueId();

      ScriptApp.deleteTrigger(trigger);

      SpreadsheetApp.getUi().alert('Removed User Trigge id=' + id);      

    }

  });

}

 

function removeProjectTriggers() {

  ScriptApp.getProjectTriggers().forEach(function (trigger) {

    if (trigger)

    {

      var id = trigger.getUniqueId();    

      ScriptApp.deleteTrigger(trigger);

      SpreadsheetApp.getUi().alert('Removed Project Trigger id=' + id);      

    }

  });

};

 

function runTrigger ()

{

  Logger.log ("trigger executed");

  var range = SpreadsheetApp.getActiveSpreadsheet().getRange("A1");

  var d = new Date();

  var currentTime = d.toLocaleTimeString();

  range.setValue(currentTime);  

}

 

function onOpen(e) {

  SpreadsheetApp.getUi()

      .createAddonMenu()

      .addItem('Create Trigger', 'createTrigger')

      .addItem('Remove All Triggers', 'removeTriggers')    

      .addToUi();
}