NAV 2016 Job Queue report does not work but error log shows "processed"

Doomhammer

Hi, I encountered interesting issue:

I have processing only report scheduled - it does simple update of two tables based on information in third table. This report is scheduled to run every 1 minute. But this report is not working. When I look on this job's log, I see "succesfully processed" message, but tables are not updated.
When I run this report manually, it works correctly and tables are updated.

I tried to schedule report 1 to print in PDF in order to check NAS functionality and printing of this report worked normally (I found some PDF's in report inbox and none errors for this test task).
But my processing only report is not working. Please can you tell me, what can be wrong?

Setup: NAV 2016, no multitenancy, NAV server service used for Job queue is executed as domain account, which has SUPER permissions in NAV.

Thanks in advance. Martin.

RockWithNAV

Hey Doom,

Actually I too felt the same scenario while working on a Project where NAV Job Queue log was displaying it as successfully executed where as actually it was doing nothing, but when i use to run it manually then it gives the perfect solution. What I did is I converted my logic into a SQL Stored procedure and then make a SQl job and till now its running perfectly fine.

I will recommend to run the Job queue with NAS and then restart the service. Give some manual error in the code and check either the job is reflecting the selective error and then recheck.

vaprog

I am not sure what's going on, but try

SELECTLATESTVERSION;

at the beginning of your job.

Doomhammer

thank you mates, I will try "selectlastversion" and let you know...

Doomhammer

SELECTLATESTVERSION seems to be working but if anyone has another solution, please share it - due of performance degradation while using this command

Doomhammer

Hi, I ran in other problem with my JQ report - sometimes, it starts and does not finish... please see attachement
<img src="https://us.v-cdn.net/5022383/uploads/FileUpload/92/9b2168586899efebfef8646c4206ca.jpg&quot; />
Is any way how to see, why report does not finish?
When ran manually, report works fine.

Thank you.