Job Queue - stopped in some companies

(0) Share

Report

Posted on by Y_NAV_1716

134

Hi all,

we have a NAV 2017 database with around 15 companies and a job queue set in each that runs the same codeunit per company (CU 1281 - to automatically update the exchange rate). Lately we have experienced an issue where the job queue has stopped in some of the companies but not in others. The same exchange rate service is used in all the companies and all job queues run using the same user ID so I don't think that it is a user issue. One thing that I have also noticed is that in the companies in which the job queues have stopped, the log entries of the job queues have somehow disappeared as well.

What other reasons could there be for the job queue to stop in certain companies but not in others?

Any feedback would be appreciated :)

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

azelaya59 2,807 on at

Like (0)

Report

Are all the Job Queues setup with the same NAS Server? If not, change the Job Queues to the same NAS server. Bear in mind that when rebooting the server, you must restart the NAS instance from the Administration Client.

Was this reply helpful? Yes No
Y_NAV_1716 134 on at

Like (0)

Report

Thanks for your input:) We're not using NAS in this case, just the task scheduler. Any other ideas?

Was this reply helpful? Yes No
Suggested answer

azelaya59 2,807 on at

Like (0)

Report

Since you are not using a NAS server, make sure the Job Queue is started. Then check to make sure all the job queues are have an "Earliest Start Date/Time" in the future and the Job Queue Entry has a status of "Ready". Check the "General Ledger Setup" to make sure the GL period is open. Then check the "User Setup" to make sure the user can Post within that period.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

I have seen the same issue a couple of times and didn't found the root cause of it. To overcome the issue what we did was create a PS script to run the codeunit and then use that PS script and create a SQL Agent Job. This worked perfectly for us.

Was this reply helpful? Yes No
Y_NAV_1716 134 on at

Like (0)

Report

Thanks ... will give the above a try! :)

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

Basically NAV job queue ends up with no specific reason, sometimes it changed to FINISHED with no specific reason and I also remember I also went up with the same SQL Job Concept.

Was this reply helpful? Yes No