So regarding report generator. The bot is behaving very weird because sometimes it could generate and when try again it fails. But when checked with the test bot, there is no error returned. Same goes when monitor the bot, also no error and shown completed. I tried reaching out to support but it took days for them to respond, until today no respond. When checked in ELS there is no such report send by the default email too. I am out of ideas on what is causing this problem. Can anyone enlighten me with some other way I could find the issues to help me solve it?
I assume you are referring to an AppSheet automation that utilizes a template to generate a document such as a PDF document??
When you say “same goes when monitor the bot”, are you seeing entries in the monitor that indicate the automation did indeed run? The issue then is that the generated document was not produced?
It would be helpful if you showed your AppSheet automation and how it is implemented as well as show the Monitor entries indicating a successful run of the automation. Maybe there is information in there that indicates why a document was not generated without error.
Since the automation is showing as completed even when the report isn’t actually generated, I’d compare one successful run with one failed run in the Monitor and look for anything different in the input data or template values.
It may also be worth testing the same automation with a fixed/test record rather than live data. If it works consistently with the same input but fails intermittently with live records, that could help narrow down whether the issue is related to the data being passed to the report rather than the bot itself.