A Jet Reports error has occured

I have created management reports that are generated by using a batch schedule. Per design, each report should be updated and emailed based on the options.

I receive the following error. I'm thinking auto pilot is moving on before the report has completed its update. No email is getting generated and the reports stop with the first generated report. Help! Thanks in advance!!

018-10-04 06.53.49.695 EmailReport: A Jet Reports error has occurred:
The message could not be sent.
The operation has timed out.
Jet.Shared.JetMailException
at aa.e()
at o.a(String A_0, String A_1, String A_2, String A_3)

   The operation has timed out.
System.Net.Mail.SmtpException
   at System.Net.Mail.SmtpClient.Send(MailMessage message)
   at aa.e()

2018-10-04 06.53.50.006 AutoPilotProgram.WriteStatus: Command: '/M "Update" /I "S:\Financial\Reports\Fund Report\Reports_In\FundReport.xlsx" /O "S:\Financial\Reports\Fund Report\Reports_Out\FundReport.xlsx" /L "S:\Financial\Reports\Fund Report\Reports_Out\debug.txt" /E "jessica.mueller@nursefamilypartnership.org" /S /B "Please see attached file" /U "Fund Report" /R /P "Fund" "D0267|G0278|G0279"', StatusType: 'a'
2018-10-04 06.53.50.451 EmailReport: A Jet Reports error has occurred:
The message could not be sent.
Jet.Shared.JetMailException
at aa.e()
at o.a(String A_0, String A_1, String A_2, String A_3)

   A recipient must be specified.
System.InvalidOperationException
   at System.Net.Mail.SmtpClient.Send(MailMessage message)
   at aa.e()

2018-10-04 06.54.03.661 HandleError: A Jet Reports error has occurred:
File '\\rem-dc3\Data\Financial\Reports\Fund Report\Input\~$Batch Schedule Report.Fund.xlsx' could not be opened. The following error was reported:

Microsoft Excel cannot access the file '\\rem-dc3\Data\Financial\Reports\Fund Report\Input\~$Batch Schedule Report.Fund.xlsx'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
Jet.Shared.JetReportsException

Harry Lewis October 10, 2018 14:31

Hello.

The fact that there is a "The operation has timed out" error indicates (to me, anyway) that there is some sort of issue in connecting to the SMTP server.

If you are normally able to access SMTP (e.g., have other reports that *do* send via SMTP), I would submit this to Jet Technical Support to see if they have a better idea of what's going on.

A Jet Reports error has occured

1 comment