Solved

Process to remove old historical cost sets

  • 10 November 2022
  • 1 reply
  • 79 views
A
Rank
Userlevel 5
Badge +9

Hi,

We have some old historical cost sets,  saved by copy cost set,  that we like to remove.

I do not find any way to schedule this process, currently when we remove cost sets  it runs in the client and while running system removes  all indexes on the costing table and this slow up our system so we cannot do this during business hours. 

Can this job be run in the background so we can schedule it?

We are on IFS apps 10 upd 14

icon

Best answer by majose 12 November 2022, 22:37

View original

1 reply

M
Rank
Userlevel 6
Badge +12

Hejsan Anna,

I get your point here Anna.

This could be an improvement suggestion.

The thing here is that when we drop an entire cost set and if there are more records in the Part_Cost_Bucket_tab, for the site and cost set, compared to what is entered in the PCB_INDEX_REBUILD_LIMIT parameter, defined in basic data for Costing - Cost Parameters, then index are droppped. (and recreated in the end of this “Delete Job”

Eeeeeh possible work arounds:

  1. During work hours
  1. Temporary increase the PCB_INDEX_REBUILD_LIMIT to let say 4 000 000 (4 million)
  1. Delete the cost set
  2. Then consider to reset it to default value which is 200 000. I personally feel that this is a bit low and could be set to let say 500 000
  1. If possible, try to do it very late in the afternoon/evening

Best Regards,

Mats

Reply


Terms & ConditionsCookie settings