Open Forum

Expand all | Collapse all

Background Posting

  • 1.  Background Posting

    GOLD CONTRIBUTOR
    Posted Dec 19, 2019 11:23 AM

    We've turned on background posting, NAV2018, for sales and purchases, only for "post" and not "post and print".

    When a job queue entry fails, it's generally because of table locks.  For those jobs that fail when it's due to table locks, is there any setup in NAV that will set that job queue entry back to Ready vs. having someone again clicking the Post button on the document that failed?




    ------------------------------
    John Bellinger
    ERP Manager
    Activar, Inc.
    Bloomington MN
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Background Posting

    SILVER CONTRIBUTOR
    Posted Dec 20, 2019 01:11 AM
    Edited by DEEPAK KUMAR Dec 20, 2019 01:20 AM
    Hi John,

    Workaround to reset the job queue to ready stage is create another job queue that will be responsible to failed job queue entry back to Ready.

    ------------------------------
    DEEPAK KUMAR
    BC/NAV Consultant
    AlleTechnologies Inc.
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Background Posting

    TOP CONTRIBUTOR
    Posted Dec 23, 2019 11:45 AM
    Out of the box I believe the answer is No.  As Deepak mentioned you could easily have a developer create a job that sets any errored jobs to ready.  Also just mentioning that whoever the last person was to "Set Status To Ready" on the job becomes the owner of the job.  When that user logs into NAV any jobs that they own that have errored will attempt to re-run again. It may (can't totally remember) automatically reset the Status to Ready after successfully running the second time.

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

    Conference-BCNAVUG_200x200


  • 4.  RE: Background Posting

    TOP CONTRIBUTOR
    Posted 30 days ago

    John, I created my own report and assigned it to the Job queue, runs every 10 minutes and loops through all the Job Queue Entries.

    1. Checks for job queue entry status = In Process
    2. Checks for job queue entry status = Error
    3. I will see the last job = Success, to see how long that took.
    4. If the current entry has exceed it more than 15 minutes. then Set it back to READY mode with the current time + 1 minute.
    5. I do have a counter if it error 3x don't keep resetting it, let someone manually see what happened and set it back to READY mode and reset the counter = 0.

    Good luck.



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

    Conference-BCNAVUG_200x200


  • 5.  RE: Background Posting

    Posted 26 days ago
    We are running NAV 2017.  By default when a recurring job fails the Status remains at Error - but we wanted it to go back to Ready instead.  I accomplished this by adding this code to the SetStatusValue function in Table 472.  Something along these lines might help you?!

    IF ("Recurring Job") AND (Status = Status::Error) THEN
    Status := Status::Ready;

    ------------------------------
    Doug Shepard
    Sr. Director of Information Technology
    1517 Media
    Minneapolis
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role