Skip to main content
Solved

Create order proposal - background job runs forever

  • September 4, 2020
  • 7 replies
  • 558 views

MarieSkoldenborg
Sidekick (Customer)
Forum|alt.badge.img+9

IFS10, UPD8 O&G Extension

 

We are planning to start use the automatic ordering of spare parts based on demands on Work Tasks. To achieve this we have set the planning method to B on all inventory parts, parameters as per below. 

 

Now, we have scheduled the job Create Order Proposal for one site to run each night. 

The problem is that it runs forever:

 

The job started yesterday morning at 01:00 is still running… 

Parameters in the scheduled task are set as per below. We want to create an order proposal for all demands on all parts on work tasks, which is the reason for entering % in the parameters. 

 

Questions: 

Why is the background job never finished?

Is there a limit of how many parts the order proposal creation can handle? 

Any other limitation when it comes to demands, like planning horizon or similar?

Best answer by william.klotz

Hi @MarieSkoldenborg ,

 

Glad you figured it out.  I would recommend you run the database tasks “Gather Statistics” weekly and Rebuild Indexes monthly.  We run gather statistics every Sunday morning and rebuild indexes on the 1st of the month.

 

Regards,

William Klotz

View original
Did this topic help you find an answer to your question?

7 replies

MarieSkoldenborg
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 47 replies
  • September 11, 2020

Is anyone using this job at all? 

It would be great to hear about some examples where it works fine. 


william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • Superhero (Customer)
  • 479 replies
  • September 11, 2020

Hi @MarieSkoldenborg ,

 

We use the create order proposal database task it runs each morning at 6:00 am.  We are currently running IFS Application 10 Update 8.  Below are screenshots of the schedule task and completed background jobs.  The background jobs usually last about 1 or 2 minutes in duration.  We are using a combination of planning method B and G on our raw materials.

 

 

 

Regards,

William Klotz


MarieSkoldenborg
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 47 replies
  • September 14, 2020

Thanks @william.klotz  for your reply. I see we have entered the parameters a bit differently, which might be a clue. 

Could you please let me know, appx how many inventory parts you have on your site with planning method B and G respectively?

Best regards,

Marie


william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • Superhero (Customer)
  • 479 replies
  • September 14, 2020

Hi @MarieSkoldenborg ,

 

We currently have approximately 3200 to 3300 parts configured using planning method B and G but most parts are configured to use planning method G in our environment.

 

Thank you,

William Klotz


MarieSkoldenborg
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 47 replies
  • September 17, 2020

Now our job runs in a couple of minutes… The problem was that we have migrated a lot of data and not rebuilt the indexes after that. Having rebuilt the indexes on some tables and also run the background job “Gather Statistics” solved the problem. 


william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • Superhero (Customer)
  • 479 replies
  • Answer
  • September 17, 2020

Hi @MarieSkoldenborg ,

 

Glad you figured it out.  I would recommend you run the database tasks “Gather Statistics” weekly and Rebuild Indexes monthly.  We run gather statistics every Sunday morning and rebuild indexes on the 1st of the month.

 

Regards,

William Klotz


MarieSkoldenborg
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 47 replies
  • September 17, 2020

Thanks for the tip @william.klotz !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings