ERPnext SetupWizard Error

Hello everyone,

this time I did try to setup a ERPnext Installation on an Ubunut16.04 System.
The installation script did work fine but during (or better after the Web-UI input of desk#setup-wizard/10) the Setup-Wizard I got some errors:

The following error seems to be present multiple times:
07:25:28 worker_default.1 | 07:25:28 default: frappe.utils.background_jobs.execute_job(async=True, event=None, job_name=u’frappe.utils.global_search.update_global_search’, kwargs={‘doc’: <erpnext.accounts.doctype.purchase_taxes_and_charges_template.purchase_taxes_and_charges_template.PurchaseTaxesandChargesTemplate object at 0x7f621f8e0310>}, method=u’frappe.utils.global_search.update_global_search’, site=‘erpnext.in.pi-lar.test’, user=u’Administrator’) (8c24be04-c833-4d8a-a197-086d3e07a435)
07:25:28 worker_default.1 | Traceback (most recent call last):
07:25:28 worker_default.1 | File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
07:25:28 worker_default.1 | “main”, fname, loader, pkg_name)
07:25:28 worker_default.1 | File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
07:25:28 worker_default.1 | exec code in run_globals
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
07:25:28 worker_default.1 | main()
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
07:25:28 worker_default.1 | click.Group(commands=commands)(prog_name=‘bench’)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
07:25:28 worker_default.1 | return self.main(*args, **kwargs)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
07:25:28 worker_default.1 | rv = self.invoke(ctx)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
07:25:28 worker_default.1 | return _process_result(sub_ctx.command.invoke(sub_ctx))
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
07:25:28 worker_default.1 | return _process_result(sub_ctx.command.invoke(sub_ctx))
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
07:25:28 worker_default.1 | return ctx.invoke(self.callback, **ctx.params)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
07:25:28 worker_default.1 | return callback(*args, **kwargs)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 157, in start_worker
07:25:28 worker_default.1 | start_worker(queue)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 106, in start_worker
07:25:28 worker_default.1 | Worker(queues, name=get_worker_name(queue)).work()
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 460, in work
07:25:28 worker_default.1 | self.execute_job(job, queue)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 575, in execute_job
07:25:28 worker_default.1 | self.fork_work_horse(job, queue)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 521, in fork_work_horse
07:25:28 worker_default.1 | self.main_work_horse(job, queue)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 590, in main_work_horse
07:25:28 worker_default.1 | success = self.perform_job(job, queue)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 692, in perform_job
07:25:28 worker_default.1 | self.prepare_job_execution(job)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 624, in prepare_job_execution
07:25:28 worker_default.1 | self.procline(msg.format(job.func_name, job.origin, time.time()))
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/job.py”, line 241, in func_name
07:25:28 worker_default.1 | self._unpickle_data()
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/job.py”, line 209, in _unpickle_data
07:25:28 worker_default.1 | self._func_name, self._instance, self._args, self._kwargs = unpickle(self.data)
07:25:28 worker_default.1 | File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/job.py”, line 53, in unpickle
07:25:28 worker_default.1 | raise UnpickleError(‘Could not unpickle’, pickled_string, e)
07:25:28 worker_default.1 | rq.exceptions.UnpickleError: (u’Could not unpickle’, AttributeError(‘lang’,))

Can somebody please help me figure out the problem?

After the interrupted setup the system allows me to redo the setup but runs into the same errors.

Can you share the error log from the web UI? This probably seems unrelated.

Also can you specify your language selection?

The web UI error log was something along the lines of “Es sind Fehler aufgetreten” <=> “Your setup did have errors”
No further output which would define the error.

My language selection is German, and I did specify for a Service oriented Company.

I am facing the same issue as well. This is also for a service company and language is English (India).
In error log, I see many instances of frappe.utils.global_search.update_global_search throwing “could not unpickle” error.

This fix worked for me.

Thank you

yes it seems like the installation is possible this way.

But sadly I can not re-set the language to anything else as “English (United States)” for my users
and if I click on “Help” -> “Documentation” I get greeted with error informations and tracelogs ->
ProgrammingError: (1146, “Table ‘36a2299f06bc4569.help’ doesn’t exist”)
and so on.

I’m having the same issue with the development branch.
Unfortunately @vkcr fix didn’t work for me :neutral_face:

Hi ,
I am facing same problem from last two days,it is very frustrating :worried:.

Yeah this didn’t work for me also, when I tried on a new installation. Not sure how it worked once after trying multiple times.

It worked for me after several retries, so I think if you drop site and then create a new site it works (you may have to do this several times).

Still the root cause is a mystery for me.

it seems we ‘only’ need to reinstall the whole site… may shorten the installation process a bit for this workaround.

Does anyone know why my installation misses some help tables?
Or the better question: Can you confirm this issue? Or is this a issue only on my installation.

Hi @skpilar

Sorry for the inconvenience, we are able to identify the issue and we are working on it. I’ll update you soon on this issue

1 Like

I also found that I had missing help tables on a test site I set up and I found the answer here: