Solved: PDF Attachments Error - Page 2

JMPeterson · 07-11-2022 10:01 PM

As of about 10 PM CST we started seeing some errors with PDF attachments from bots. The PDF is generated, and an email is sent but the attached PDF is corrupt and unreadable. The full PDF is available in the associated drive location, but the PDF that is in the email is always maxed out at 114kb. Any PDF smaller than 114kb comes through without issue.

We have not made changes in the bot or the PDF templates.

Did AppSheet make a change or perhaps a third party service?

Aleksi

We found out that the reason is coming from Google Drive API.

During email task execution, the Automation module contacts AppSheet connectors module to communicate with GDrive API (Owned by Drive). Automation module passes a list of attachment docIDs and expects GDriveHelper to respond with the contents of attachments ( Data ). Once it receives response from GDriveHelper, it passes on the body of email, along with attachments down the chain. However, the problem here is coming from GDrive APIs. The API calls for fetching contents from GDrive are failing because of the ongoing Drive issue. AppSheet connector module is not handling the error from GDrive API, and sending back partially consistent pdfs back to automation. This is why, users were not able to open some files. All these files are at 117KB because the partially consistent file into which the contents are written takes 117KB.

The current issue will be fixed once the GDrive's issue is resolved. It seems like they are rolling out a fix at the moment.

Sorry for the disruption this caused!

View solution in original post