Scheduled export is empty

Awaiting your reply

Ticket #4192 · Reports and exports · Normal priority

YouMon 09:12

The Monday revenue export landed with headers but no rows. It ran at 06:00 as usual and the run log says it succeeded.

export-log-1104.txt
Sofia AlvarezSupportMon 09:31

Thanks for the log. The job completed against a filter that excluded every row, which is why it reported success. Was the saved view edited on Sunday?

YouMon 10:04

Yes, someone narrowed the date range to a single day while testing and left it that way.

Sofia AlvarezSupportMon 10:22

That explains it. I have added a warning on scheduled runs that return zero rows, shipping this week. In the meantime the schedule will email you instead of writing an empty file.

YouMon 11:15

Restored the range and re-ran it, 14,208 rows this time. Is there a way to lock a saved view so a schedule cannot be changed underneath it?

Sofia AlvarezSupportMon 11:40

Yes. Open the view, choose Lock for schedules, and edits then require an admin. I have attached the steps for your workspace.

lock-a-saved-view.pdf