Job queue and 3 tier environment

Business Central/NAV Technical Forum
1

Hi,

I have setup a job queue that is started by NAS and it runs a report that selects records from a custom table, then populates general journals and posts. Now, the problem is that the report only posts successfully on the first run after I start NAS. The job queue runs successfully as per its schedule and when I check the custom table there are entries that are ready to be posted but nothing is being posted.

If I restart NAS the records get posted but the cycle then begins.

I suspect it could be a 3 tier configuration issue since this was working perfectly before I upgrade to NAV 2013 R2.

2

Hi Tirus,

Sounds like the report doesn’t exit correctly. What if you run it manually? Do you then get any errors?

3

Hi Erik,

If I run the report manually it runs successfully without giving any errors.

4

Which version did it run before?

Please be aware of the changes from NAV 2009 to NAV 2013.

5

I had version 6.0 Classic with SQLServer which I upgraded to NAV 2013 R2.