Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Osman Hamidzada]

Hello Everyone,

We’ve encountered a rather odd issue. For our Job Queue Entries, we will have jobs that are set to run every day at a certain time, and yet every month or so we find that the job simply does not run.

For example: we have a job that runs every night at 10:05pm. It will typically take anywhere from 25-35 minutes. However, on the first of this month it started and immediately ended at 10:05 pm, with a Status of “Success”. After that, it did not run on 4/2 or 4/3, even though it was in a ready state. There were no errors associated with it. All of the logs seem to indicate everything worked (with the exception being that the start time and end time are identical). This seems to happen on the weekends, and it happens randomly as it is not every weekend or even consecutive weekends. We are running Nav 2013. Has anyone else encountered this issue?

Thanks,

Oz

——————————
Osman Hamidzada
Business Analyst
Protective Industries, Inc.
Buffalo NY
——————————

[Ian Ray]

Is this job adjust cost – item entries?

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Osman Hamidzada]

Hi Ian,

This has happened to Adjust Cost yes, but it is not the only job it has happened to.

Thanks,

-Oz

——————————
Osman Hamidzada
Business Analyst
Protective Industries, Inc.
Buffalo NY
——————————
——————————————-

[Garth Woods]

Yes, we have the same problem and our NAV partner has been unable to provide a fix. It seems to be occur whenever our NAV server is restarted, although the NAS services start up properly. If I forget to check regularly, we find that the job has not run for days or weeks. A manual restart of the job in NAV gets it running again…

——————————
Garth Woods
VP Information Technology
Marine Ingredients
Mount Bethel PA
——————————
——————————————-

[Jason Wilder]

A few thoughts:
1) What is the job that you are running?  I would guess it is a problem with the job queue entry itself and not the job queue.
2) It sounds like you are saying the job queue is running on other jobs just not this one.  If this is true then it really does point towards the job queue entry on the job queue itself. 
3) I am in the process of creating a job that “checks” to make sure all of our job queues are running (we have 3) and makes sure that each job queue entry is not “stuck” in a running state which happens to us periodically.  Send me a message if you would like the code.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Joe Shields]

Jason,

That sounds like a great job to have to monitor the job queue.

——————————
Joe Shields
Advanced Media Technologies
——————————
——————————————-

[Dave Cintron]

What version of Windows Server is your Job Queue running on? (and what version of NAV?)

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Osman Hamidzada]

Hi Jason,

For your first question, it has happened to a couple different jobs. Most recently it has happened to Adjust Cost, but in my example it happens to our Job that Auto Invoice sales orders over night. In the morning our accounting department batch prints/emails/faxes the invoices for the previous day, but if the Auto Invoicing job does not run over night, then they can’t send out the invoices in the morning.

It could be that there is something wrong with these two Jobs and not the entire Job Queue system itself, but the strange thing is that the day before it stops running, it will run “successfully”, and it won’t provide us with any error code.

Thank you for your help!

-Oz

——————————
Osman Hamidzada
Business Analyst
Protective Industries, Inc.
Buffalo NY
——————————
——————————————-

[Geovanny Fuentes]

Osman, several things:
Windows server version?
Navision version?
Type of job queue Object Id/Name?

Have you tried running it manually to see what error pops up?
Most likely its the cause of it.
Have you logged in with the user id/password (Expired password)?

Good luck and keep us posted.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-

[Osman Hamidzada]

Hi Geovanny,

The server it runs on is Windows Server 2012 (Standard).

The version of Nav is Nav 2013, 7.0.47058.0

It has happened on two separate jobs, the object type of one is a Report and the other a Codeunit.

When we run it manually, no errors pop up, it runs successfully. When the particular Job(s) stop running, the day before it Job says it ran “successfully” but does not give us any error and indicates that as soon as it started it stopped immediately (for instance, the Report will start and end at exactly 10:05pm, normally it is a 25-30 minute process).

Thanks,

Oz

——————————
Osman Hamidzada
Business Analyst
Protective Industries, Inc.
Buffalo NY
——————————
——————————————-

[Anthony Darden]

To Geovanny:

We are running Windows Server 2012 and keep it updated on a monthly basis.  NAV version is 2013, with the latest patches current through the end of 2016.  Oz can answer the job details as he has been replying this morning as well.

——————————
Anthony Darden
Director of IT
Protective Industries, Inc.
Buffalo NY
——————————
——————————————-

[Anthony Darden]

To the entire group:

We are planning an upgrade to NAV 2017 next year and I’d like to hear if anyone has experienced or heard of the same types of issues with it?  The scary part, as Oz has mentioned, is the status is giving us a false positive when it is truly hung up and needs restarted.  We tools in place to monitor status and alert us of issues, but it’s a waste because the job reports as everything is fine, when in fact it’s not.

——————————
Anthony Darden
Director of IT
Protective Industries, Inc.
Buffalo NY
——————————
——————————————-

[Geovanny Fuentes]

A quick suggestion, is try having that report run first or last.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-

[Geovanny Fuentes]

Suggestion, 
please log under the user id the job queue uses.
Log in NAV 2013 and execute the object from Report Designer.
Pay close attention to any filters or parameters (check box) that come up.
Remember if the object got changed, it would have cleared any filters normally set by a user.
You may need to go into the Job queue Entry and Manually activate any filters.

Next to try:

Create a new Job Entry Card with the Report, execute it right away to see if the time is different, i have had issues with bad Job queue entry cards.

Next to try:
If you have a developer or can put a marking on a record during different stages, you can see it went to a certain part of the report:
Example:

Say on the report On Open:

Customer.GET(‘10000’);
Customer.”Address 2″ := ‘1’;
Customer.Modify

A few more lines later on repeat the above
Customer.GET(‘10000’);
Customer.”Address 2″ := Customer.”Address 2″+’2′;  //This part you appending 12 etc.
Customer.Modify

After it runs you can see if the address 2 field has 12345…
If it doesn’t, you know it did not execute that part and you can zoom in on why it’s skipping and finishing fast.

I only suggest this as you can’t really DEBUG a job queue entry.

Ps. Make sure you have a backup of the object ID to restore and the customer “Address 2” to put back.
Keep us posted.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-