Scheduler for prepared report not working

Hi have scheduled Stock Balance Report, but still in Queue since long time.
I did:

bench --site all enable-scheduler

And it’s enabled in all sites

I have restarted supervisord:
sudo supervisorctl restart all

bench doctor:

-----Checking scheduler status-----
Workers online: 3
-----None Jobs-----

What else I have to check?

1 Like

Do you have new error at Error Log right after scheduled Stock Balance Report?
Maybe we have the same issue

The error that i get is this:

{'method_name': 'run_background', 'log': <function log at 0x7ff20c0f2378>, 'retry': 0, 'is_async': True, 'user': 'Administrator', 'kwargs': {'prepared_report': 'REP00003'}, 'job_name': '<function run_background at 0x7f5efed09400>', 'event': None, 'method': <function run_background at 0x7ff20c178d08>, 'site': 'nerp-dev.zh.mtm-t.com.cn'}
Traceback (most recent call last):
  File "/home/erp/nerp/apps/frappe/frappe/utils/background_jobs.py", line 103, in execute_job
    method(**kwargs)
  File "/home/erp/nerp/apps/frappe/frappe/core/doctype/prepared_report/prepared_report.py", line 36, in run_background
    instance = frappe.get_doc("Prepared Report", prepared_report)
  File "/home/erp/nerp/apps/frappe/frappe/__init__.py", line 725, in get_doc
    doc = frappe.model.document.get_doc(*args, **kwargs)
  File "/home/erp/nerp/apps/frappe/frappe/model/document.py", line 69, in get_doc
    return controller(*args, **kwargs)
  File "/home/erp/nerp/apps/frappe/frappe/model/document.py", line 104, in __init__
    self.load_from_db()
  File "/home/erp/nerp/apps/frappe/frappe/model/document.py", line 141, in load_from_db
    frappe.throw(_("{0} {1} not found").format(_(self.doctype), self.name), frappe.DoesNotExistError)
  File "/home/erp/nerp/apps/frappe/frappe/__init__.py", line 352, in throw
    msgprint(msg, raise_exception=exc, title=title, indicator='red')
  File "/home/erp/nerp/apps/frappe/frappe/__init__.py", line 338, in msgprint
    _raise_exception()
  File "/home/erp/nerp/apps/frappe/frappe/__init__.py", line 311, in _raise_exception
    raise raise_exception(msg)
frappe.exceptions.DoesNotExistError: Prepared Report REP00003 not found

But it exists:

Did you find any solution? We still have this error :frowning:

not yet…

Any update on this issue ?

I have same issue!

Any solution will be appreciated

any update on this issue? I have same issue