I am doing a project in ODK central, the form had been created and submissions are successful. I am using ODOO with the ODK collector App to move the data from the ODK server to ODOO. Below are the key details to create the profile and the information of the ODK server was used:
**Form Name **
**ODK Base URL **
**ODK Project ID **
**ODK Form ID **
**ODK User EMail **
**ODK User Password **
Active
But when I click on "Update submission" I am having errors that I don't understand. Below are the errors I am getting:
Error:
Odoo Server Error
Traceback (most recent call last):
File "/home/ubuntu/odoo/odoo/http.py", line 656, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/ubuntu/odoo/odoo/http.py", line 314, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/home/ubuntu/odoo/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/home/ubuntu/odoo/odoo/http.py", line 698, in dispatch
result = self._call_function(**self.params)
File "/home/ubuntu/odoo/odoo/http.py", line 346, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/ubuntu/odoo/odoo/service/model.py", line 98, in wrapper
return f(dbname, *args, **kwargs)
File "/home/ubuntu/odoo/odoo/http.py", line 339, in checked_call
result = self.endpoint(*a, **kw)
File "/home/ubuntu/odoo/odoo/http.py", line 941, in call
return self.method(*args, **kw)
File "/home/ubuntu/odoo/odoo/http.py", line 519, in response_wrap
response = f(*args, **kw)
File "/home/ubuntu/odoo/addons/web/controllers/main.py", line 967, in call_button
action = self._call_kw(model, method, args, {})
File "/home/ubuntu/odoo/addons/web/controllers/main.py", line 955, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/ubuntu/odoo/odoo/api.py", line 759, in call_kw
return _call_kw_multi(method, model, args, kwargs)
File "/home/ubuntu/odoo/odoo/api.py", line 746, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_config_model.py", line 52, in odk_button_update_form_submissions
self.call_submission()
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_config_model.py", line 69, in call_submission
submissions_obj.update_submissions(self)
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_submissions_model.py", line 35, in update_submissions
updated_submissions_count = self.get_data_from_odk(odk_config)
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_submissions_model.py", line 84, in get_data_from_odk
self.save_data_into_all(submission_response["value"], odk_config)
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_submissions_model.py", line 103, in save_data_into_all
registration = self.create_registration_from_submission(value)
File "/home/ubuntu/odoo/openg2p-erp/odk-connector/models/odk_submissions_model.py", line 124, in create_registration_from_submission
registration = self.env["openg2p.registration"].create_registration_from_odk(
File "/home/ubuntu/odoo/openg2p-erp/openg2p_registration/models/openg2p_registration.py", line 259, in create_registration_from_odk
regd = self.create(
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 440, in _model_create_single
return create(self, arg)
File "/home/ubuntu/odoo/openg2p-erp/openg2p_registration/models/openg2p_registration.py", line 441, in create
res = super(Registration, self.with_context(mail_create_nolog=True)).create(
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 440, in _model_create_single
return create(self, arg)
File "/home/ubuntu/odoo/openg2p-erp/openg2p/models/openg2p_beneficiary.py", line 465, in create
self._partner_create(vals)
File "/home/ubuntu/odoo/openg2p-erp/openg2p/models/openg2p_beneficiary.py", line 445, in _partner_create
partner = self.env["res.partner"].create(partner_vals)
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 461, in _model_create_multi
return create(self, [arg])
File "/home/ubuntu/odoo/addons/partner_autocomplete/models/res_partner.py", line 168, in create
partners = super(ResPartner, self).create(vals_list)
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 462, in _model_create_multi
return create(self, arg)
File "/home/ubuntu/odoo/odoo/addons/base/models/res_partner.py", line 585, in create
partners = super(Partner, self).create(vals_list)
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 462, in _model_create_multi
return create(self, arg)
File "/home/ubuntu/odoo/addons/mail/models/mail_thread.py", line 272, in create
threads = super(MailThread, self).create(vals_list)
File "", line 2, in create
File "/home/ubuntu/odoo/odoo/api.py", line 462, in _model_create_multi
return create(self, arg)
File "/home/ubuntu/odoo/odoo/models.py", line 3603, in create
records = self._create(data_list)
File "/home/ubuntu/odoo/odoo/models.py", line 3719, in _create
records.modified(self._fields)
File "/home/ubuntu/odoo/odoo/models.py", line 5273, in modified
target0 = env[model_name].search([(path, 'in', self.ids)], order='id')
File "/home/ubuntu/odoo/odoo/models.py", line 1581, in search
res = self._search(args, offset=offset, limit=limit, order=order, count=count)
File "/home/ubuntu/odoo/odoo/models.py", line 4165, in _search
self._cr.execute(query_str, where_clause_params)
File "/home/ubuntu/odoo/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/home/ubuntu/odoo/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedTable: relation "openg2p_disbursement_main" does not exist
LINE 1: SELECT "openg2p_disbursement_main".id FROM "openg2p_disburse...
^