I am using a Business Central version 14.5.
I am running a report in the job queue. The report is a processing only report, i.e. no RDLC layout.
When running in the job queue, the report fails with an error: "The date is not valid".
Tragically, turning the debugger on does not reveal where the error happens. The arrow just points at the line in codeunit 449:
It is strange that when running the report manually, it does not generate an error.
Does anybody out there perhaps have an idea regarding this? Thanks in advance for any hints.
The report iterated through a table with a field of the type "datetime" in SQL but the type "date" in BC. Due to some integration, the field in the SQL table had a date value BUT ALSO a time value. This latter (the time value) caused BC to refuse to iterate past the record with a time in the field. This gave the error message "The date is invalid" and the debugger refused to point it out.
Is it possible that the standard feature U31/12/2022 is used in a table that was not prepared for this?