Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Batch job is executing slower in the batch mode than in the manual mode

Posted on by 15

We have the custom batch job that runs slower in the batch mode than not in the batch mode. Also somehow the process (only in batch mode) hangs in different find\exists methods (each run - different method) for a few minutes, and then continues with execution.

From the screenshots you can see that it was 13889 calls of the InventTable::find method, and just one of the call took all the time. Thank you for your help in advance!Screenshot-2021_2D00_01_2D00_28-at-20.38.13.png

Screenshot-2021_2D00_01_2D00_28-at-20.38.34.png

  • Bohdan Bilous Profile Picture
    Bohdan Bilous 15 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Also want to add that there is no issues or locks in the database. For me it looks like the system trying to get the record from the cache (in the find\exists method) but it hangs somehow. But then the question is why it's not happening not in the batch mode.

  • Bohdan Bilous Profile Picture
    Bohdan Bilous 15 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Just 1 AOS

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    How many AOS servers do you have in place?

  • Bohdan Bilous Profile Picture
    Bohdan Bilous 15 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Yes, we do this every night

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Hi Bohdan,

    Did you delete the contents of the XPPIL folder and do a full CIL?

  • Bohdan Bilous Profile Picture
    Bohdan Bilous 15 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Hi Gunjan! Thank you for your response! Unfortunately Full CIL didn't help.

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Batch job is executing slower in the batch mode than in the manual mode

    Hi Bohdan,

    We had the same issue with one of our clients recently. The issue turned out to be with CIL. You can try to force a CIL re-generation following the steps provided in this post.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans