Microsoft Dynamics 365 event series


Digital transformation at work

Attend premier in-person and online events and discover how Dynamics 365 can help grow your business. Join leading Microsoft partners and see digital transformation at work with Dynamics 365 and intelligent business applications across CRM and ERP.

Space is limited. Reserve your free seat today!
16 Cities | 100+ events | Infinite transformation

Source: Dynamics 365

Advertisements

Cumulative Update 05 for Microsoft Dynamics NAV 2017 (Build 16177)


Where to find Cumulative Update 05

You can download the cumulative update from KB 4018437  – Cumulative Update 5 for Microsoft Dynamics NAV 2017.

You can press one of the countries in list above for a direct download or you can download the cumulative update from the Microsoft Download Center.

To learn more about other Cumulative Updates already released for Microsoft Dynamics NAV 2017 please see KB  3210255.

Source: Cumulative Update 05 for Microsoft Dynamics NAV 2017 (Build 16177)

and https://blogs.msdn.microsoft.com/nav/2017/04/10/cumulative-update-05-for-microsoft-dynamics-nav-2017-has-been-released/

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2017 Cumulative Update.

“Ideas” for Microsoft Dynamics 365 for Financials


“Help us to improve Microsoft Dynamics 365 and its family of products and solutions by discussing ideas, providing suggestions, and giving feedback. Use the forums listed below for the respective areas.”: This is Dynamics 365 Ideas !

Home site Dynamics 365 Ideas
https://ideas.dynamics.com/

ideas 1.png

A new section of this forum is available: “Ideas for Microsoft Dynamics 365 for Financials”  https://ideas.dynamics.com/ideas/dynamics-financials

ideas2.png

ideas 3

others useful sections

Posting Guidelines
https://ideas.dynamics.com/posting-guidelines/

FAQ-Frequently Asked Questions
https://ideas.dynamics.com/faq/

…ideas and suggestions are welcome !

How to restart a job in “Error” or “Frozen Completed” status


Sometimes can happen that some recursively scheduled jobs can go wrong or get stuck, you can re-enable them automatically and after consult the log to see errors; it is not a perfect solution but sometimes the error can be a simple error ex: “another user has modified..” etc. This function could be useful for NAV versions up to 2016, NAV 2017 has an improved management and a robust task scheduling system.

Samples of Jobs in “Error” or “Frozen Completed State”

Before Execution

After Execution

The Simple Solution

The solution is based on a codeunit that takes care of reactivating the jobs in the state “error” or “completed”, it can be changed according to the needs.

It can be scheduled:

  • Directly into the NAS (in the same or other NAS instances)
  • On Windows Task Scheduler with codeunit invoked by Powershell

 

Fields Added on Table “Job Queue Entry”

 

Codeunit 50000 “ChangeJobsStatus”

CODE

OnRun()

ChangeJobStatus;

ChangeJobStatus()

Documentation()

“Restart Job” IF in errorin processfinished state

OnRun()

IF ChangeJobStatus() = TRUE THEN

MESSAGE(‘Jobs Status Changed!’)

ELSE

MESSAGE(‘Nothing Changed!’)

LOCAL ChangeJobStatus() JobStatusChanged : Boolean

//”Restart Job” IF in errorin processfinished state

JobStatusChanged := FALSE;

recJobQEntry.RESET;

IF recJobQEntry.FINDSET THEN

REPEAT

CASE recJobQEntry.Status OF

//*** STATE: IN PROCESS

recJobQEntry.Status::”In Process”:

BEGIN

recJobQLogEntry.RESET;

recJobQLogEntry.SETRANGE(“Object Type to Run”,recJobQEntry.”Object Type to Run”); //Check Run.Time

recJobQLogEntry.SETRANGE(“Object ID to Run”,recJobQEntry.”Object ID to Run”);

//Check Duration Process Max

IF recJobQEntry.”Duration Process Max” > 0 THEN

IF recJobQLogEntry.FINDLAST THEN

IF CURRENTDATETIME – recJobQLogEntry.”Start Date/Time” > recJobQEntry.”Duration Process Max” THEN BEGIN //CHECK MAX DURATION TIME

recJobQEntry.Status := recJobQEntry.Status::Ready; // –> SET STATUS TO READY

recJobQEntry.MODIFY(FALSE);

JobStatusChanged := TRUE;

END

END;

//*** STATE: ERROR OR FINISHED

recJobQEntry.Status::Error, recJobQEntry.Status::Finished: //IF “ERROR” OR “FINISHED”

BEGIN

recJobQEntry.Status := recJobQEntry.Status::Ready; // –> SET STATUS TO READY

recJobQEntry.MODIFY(FALSE);

JobStatusChanged := TRUE;

END;

END; //END CASE

COMMIT;

UNTIL recJobQEntry.NEXT = 0;

EXIT(JobStatusChanged);

Download from MSDN https://gallery.technet.microsoft.com/How-to-restart-a-job-in-8aca5516

 

About Scheduling

1) With NAV Codeunit scheduled by NAS

After Execution

2) With NAV Codeunit invoked by Powershell and scheduled by Windows Task Scheduler

Import-Module ‘C:Program FilesMicrosoft Dynamics NAV100ServiceMicrosoft.Dynamics.Nav.Management.dll’

Invoke-NAVCodeunit dynamicsnav100 -CodeunitId 50000 -CompanyName ‘CRONUS Italia S.p.A.’

To Schedule Powershell Script by Windows Task Scheduler

An easy way to schedule a PowerShell script is, to use Windows Task Scheduler, look at this post:

Coffee Break: Proactive Monitoring with Task Scheduler

https://blogs.msdn.microsoft.com/nav/2016/01/19/coffee-break-proactive-monitoring-with-task-scheduler/

My Old Post about NAV 2017 Task Scheduler

https://robertostefanettinavblog.com/2016/11/04/nav-2017-task-scheduler/