Share
Report
4Hi All,
Would really appreciate any help with this.
Everyday (same time of day) we have problems with attaching files to emails, sending emails and incoming emails (into CRM) do not pull through attachments.
In our D365 backend server I see warning events each time this happens:
Query execution time of 30.0 seconds exceeded the threshold of 10 seconds. Thread: 12; Database: D365Live_MSCRM; Server:SQL19\D365; Query: insert into [Attachment]([Body], [FileName], [MimeType], [FileSize], [AttachmentId]) values (@Body0, @FileName0, @MimeType0, @FileSize0, @AttachmentId0).
I have checked the following:
- Restricted file types for attachments in CRM (nothing unusual)
- File size limit
- Recurring system jobs (none at the time of day this issue occurs)
- CPU and RAM on D365 front end and backend servers, as well as our SQL server. These have all been increased which hasn't made a difference
- Number of system jobs completed in D365 at the time of day this occurs, compared with the rest of the day
This is the error we get in CRM:
We're using version 9.1 on-premises. We upgraded from version 8.2 recently, and this problem has occurred ever since.
Any help or advice would be greatly appreciated.
All responses (
Answers (
