Item valuation reposting in progress. Stuck in queued for 12 months

[eaj]

hi. i am using erpnext v15. i have 74,614 items queued for repost item valuation and 26 in progress repost item valuation, how do i make this queueing faster or submit them all at once? since the latest that’s queued is still 12 months ago and i am not getting the correct item valuation. thanks/

[centaur]

is your scheduler active or inactive ?

What’s the output of the command

bench doctor

[eaj]

scheduler is active

[Suresh_Thakor]

Go to Stock >> Stock and Account Value Comparison and repost stock valuation.

Thanks

[eaj]

Hi. I’ve also done this. But the queue is still the same. Is there a way for us to submit all of this at once? Since for 8 hours, the completed transactions are only 8.

[eaj]

Scheduler is active. Queue is now 75189. Is there a way for us to push this transaction in a day or two or even a week? Thanks.

[centaur]

Hi eaj

stock reposting happens hourly.

could you post the screenshot of “Scheduled Job Log“

[eaj]

[centaur]

and the screenshot of “RQ Job“

[eaj]

@centaur

t of “Scheduled Job Log

Upon checking it now, it shows failed. But before, it is not.

[centaur]

Since you have said its more than 12 months.. are you reposting for a closed financial year ??

[eaj]

The backlogs are from July 2024 to present. We opened the financial year for now since some of the backlogs are from 2024.

[centaur]

Could you also check the ‘error log‘ list to see what’s causing this.

If nothing shows up there… the other location you can check would be under frappe-bench/logs directory …look at the worker.log or scheduler.error.log or frappe.log

[eaj]

Usual error is:

rq.timeouts.JobTimeoutException: Task exceeded maximum timeout value (1500 seconds)

[centaur]

@eaj

rq.timeouts.JobTimeoutException: Task exceeded maximum timeout value (1500 seconds)

What version of erpnext are you using ??

What’s your sever configuration ?

[eaj]

@centaur

Could you also check the ‘error log‘ list to see what’s causing this.

If nothing shows up there… the other location you can check would be under frappe-bench/logs directory …look at the worker.log or scheduler.error.log or frappe.log

ERPNext: v15.83.0 (version-15)

For the server config, what specific server config? Thanks.

[centaur]

I meant how much cpu, memory etc

[eaj]

16 CPU Cores - 32 GB RAM

[centaur]

well here are something you have to decide..

firstly it is not recommended to repost for a closed financial year.

So to avoid recalculating the entire history, set a “Stock Frozen Up To” date in Stock Settings. This prevents reposting transactions before the frozen date. You can then manually trigger a reposting for only the most recent transactions.

then to clear a stuck queue, you can use the command

bench purge-jobs

but be aware that this will clear all pending jobs.

Then go to Stock and Account Value Comparison and do a reposting

since the rQ jobs are timing out try the below

bench config http_timeout 600 (default is 300.. i think)

bench setup supervisor

bench setup nginx

once done do run the below with sudo

supervisorctl reload

service nginx reload

[eaj]

@centaur

well here are something you have to decide..

firstly it is not recommended to repost for a closed financial year.

So to avoid recalculating the entire history, set a “Stock Frozen Up To” date in Stock Settings. This prevents reposting transactions before the frozen date. You can then manually trigger a reposting for only the most recent transactions.

then to clear a stuck queue, you can use the command bench purge-jobs but be aware that this will clear all pending jobs.

Then go to Stock and Account Value Comparison and do a reposting

since the rQ jobs are timing out try the below

bench config http_timeout 600 (default is 300.. i think)

bench setup supervisor

bench setup nginx

once done do run the below with sudo

supervisorctl reload

service nginx reload