contract.contract._create_build

[killday]

I'm doing the scenario where user choose apps with try now. Database draft is created but contract creation is failing whit the following error:

Traceback (most recent call last):
File "/odoo14/odoo14-server/odoo/http.py", line 1470, in _dispatch_nodb
result = request.dispatch()
File "/odoo14/odoo14-server/odoo/http.py", line 808, in dispatch
r = self._call_function(**self.params)
File "/odoo14/odoo14-server/odoo/http.py", line 362, in _call_function
return self.endpoint(*args, **kwargs)
File "/odoo14/odoo14-server/odoo/http.py", line 914, in call
return self.method(*args, **kw)
File "/odoo14/odoo14-server/odoo/http.py", line 533, in response_wrap
response = f(*args, **kw)
File "/odoo14/custom/saas/queue_job/controllers/main.py", line 73, in runjob
self._try_perform_job(env, job)
File "/odoo14/custom/saas/queue_job/controllers/main.py", line 32, in _try_perform_job
job.perform()
File "/odoo14/custom/saas/queue_job/job.py", line 516, in perform
self.result = self.func(*tuple(self.args), **self.kwargs)
File "/odoo14/custom/saas/saas_apps_signup/models/contract_contract.py", line 163, in _create_build
build = template_operator.create_db(
File "/odoo14/custom/saas/saas/models/saas_template.py", line 232, in create_db
build.create_db(
File "/odoo14/custom/saas/saas/models/saas_db.py", line 32, in create_db
self.state = 'done'
File "/odoo14/odoo14-server/odoo/fields.py", line 1129, in set
records.write({self.name: write_value})
File "/odoo14/custom/saas/saas_limit_max_users/models/saas_db.py", line 26, in write
return super(SaasDb, self).write(vals)
File "/odoo14/custom/saas/saas_domain_names/models/saas_db.py", line 39, in write
res = super(SaasDb, self).write(vals)
File "/odoo14/custom/saas/saas_build_admin/models/saas_db.py", line 21, in write
return super(SaasDb, self).write(vals)
File "/odoo14/custom/saas/saas/models/saas_db.py", line 59, in write
self.refresh_data()
File "/odoo14/custom/saas/saas/models/saas_db.py", line 66, in refresh_data
vals = record.read_values_from_build()
File "/odoo14/custom/saas/saas_apps_signup/models/saas_db.py", line 36, in read_values_from_build
vals = super(SaasDb, self).read_values_from_build()
File "/odoo14/custom/saas/saas_limit_max_users/models/saas_db.py", line 59, in read_values_from_build
users_count=self.execute_kw(
File "/odoo14/custom/saas/saas/models/saas_db.py", line 80, in execute_kw
return self.operator_id.build_execute_kw(self, model, method, args, kwargs)
File "/odoo14/custom/saas/saas/models/saas_operator.py", line 148, in build_execute_kw
return self._build_execute_kw(build.name, model, method, args, kwargs)
File "/odoo14/custom/saas/saas_operator_remote/models/saas_operator.py", line 98, in _build_execute_kw
return super(SaasOperator, self)._build_execute_kw(
File "/odoo14/custom/saas/saas/models/saas_operator.py", line 142, in _build_execute_kw
return cluster.execute_kw(db_name, model, method, args, kwargs)
File "/odoo14/custom/saas/saas_cluster_simple/main.py", line 124, in execute_kw
return execute(db_name, SUPERUSER_ID, model, method, *args, **kwargs)
File "/odoo14/odoo14-server/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/odoo14/odoo14-server/odoo/service/model.py", line 175, in execute
res = execute_cr(cr, uid, obj, method, *args, **kw)
File "/odoo14/odoo14-server/odoo/service/model.py", line 159, in execute_cr
result = odoo.api.call_kw(recs, method, args, kw)
File "/odoo14/odoo14-server/odoo/api.py", line 395, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/odoo14/odoo14-server/odoo/api.py", line 368, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/odoo14/odoo14-server/odoo/models.py", line 1685, in search_count
res = self.search(args, count=True)
File "/odoo14/odoo14-server/odoo/models.py", line 1708, in search
res = self._search(args, offset=offset, limit=limit, order=order, count=count)
File "/odoo14/odoo14-server/odoo/addons/base/models/res_users.py", line 539, in _search
return super(Users, self)._search(args, offset=offset, limit=limit, order=order, count=count,
File "/odoo14/odoo14-server/odoo/models.py", line 4514, in _search
query = self._where_calc(args)
File "/odoo14/odoo14-server/odoo/models.py", line 4270, in _where_calc
return expression.expression(domain, self).query
File "/odoo14/odoo14-server/odoo/osv/expression.py", line 442, in init
self.parse()
File "/odoo14/odoo14-server/odoo/osv/expression.py", line 654, in parse
raise ValueError("Invalid field %s.%s in leaf %s" % (model._name, path[0], str(leaf)))
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/werkzeug/serving.py", line 306, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python3.8/dist-packages/werkzeug/serving.py", line 294, in execute
application_iter = app(environ, start_response)
File "/odoo14/odoo14-server/odoo/service/server.py", line 441, in app
return self.app(e, s)
File "/odoo14/odoo14-server/odoo/service/wsgi_server.py", line 113, in application
return application_unproxied(environ, start_response)
File "/odoo14/odoo14-server/odoo/service/wsgi_server.py", line 88, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/odoo14/odoo14-server/odoo/http.py", line 1307, in call
return self.dispatch(environ, start_response)
File "/odoo14/odoo14-server/odoo/http.py", line 1273, in call
return self.app(environ, start_wrapped)
File "/usr/local/lib/python3.8/dist-packages/werkzeug/middleware/shared_data.py", line 220, in call
return self.app(environ, start_response)
File "/odoo14/odoo14-server/odoo/http.py", line 1499, in dispatch
result = _dispatch_nodb()
File "/odoo14/odoo14-server/odoo/http.py", line 1472, in _dispatch_nodb
return request._handle_exception(e)
File "/odoo14/odoo14-server/odoo/http.py", line 746, in _handle_exception
return super(HttpRequest, self)._handle_exception(exception)
File "/odoo14/odoo14-server/odoo/http.py", line 317, in _handle_exception
raise exception.with_traceback(None) from new_cause
ValueError: Invalid field res.users.is_excluded_from_limiting in leaf ('is_excluded_from_limiting', '=', False) - - -

[killday]

The problem is this code which I don't understand what it is doing as there is now field is_excluded_from_limiting in res_users (/saas_limit_max_users/models/saas_db.py", line 58):

vals.update(
            users_count=self.execute_kw(
                "res.users",
                "search_count",
                [(("is_excluded_from_limiting", "=", False))],
            )
        ) 

[glupeksha]

I got this same error, might be from the same issue as in #117 .

Exception Information

Exception:ValueError
Traceback (most recent call last): File "/odoo/custom/queue/queue_job/controllers/main.py", line 107, in runjob self._try_perform_job(env, job) File "/odoo/custom/queue/queue_job/controllers/main.py", line 37, in _try_perform_job job.perform() File "/odoo/custom/queue/queue_job/job.py", line 520, in perform self.result = self.func(*tuple(self.args), **self.kwargs) File "/odoo/custom/saas-addons/saas/models/saas_db.py", line 32, in create_db self.state = 'done' File "/odoo/odoo-server/odoo/fields.py", line 1129, in set records.write({self.name: write_value}) File "/odoo/custom/saas-addons/saas_limit_max_users/models/saas_db.py", line 26, in write return super(SaasDb, self).write(vals) File "/odoo/custom/saas-addons/saas/models/saas_db.py", line 59, in write self.refresh_data() File "/odoo/custom/saas-addons/saas/models/saas_db.py", line 66, in refresh_data vals = record.read_values_from_build() File "/odoo/custom/saas-addons/saas_limit_max_users/models/saas_db.py", line 59, in read_values_from_build users_count=self.execute_kw( File "/odoo/custom/saas-addons/saas/models/saas_db.py", line 80, in execute_kw return self.operator_id.build_execute_kw(self, model, method, args, kwargs) File "/odoo/custom/saas-addons/saas/models/saas_operator.py", line 148, in build_execute_kw return self._build_execute_kw(build.name, model, method, args, kwargs) File "/odoo/custom/saas-addons/saas/models/saas_operator.py", line 142, in _build_execute_kw return cluster.execute_kw(db_name, model, method, args, kwargs) File "/odoo/custom/saas-addons/saas_cluster_simple/main.py", line 124, in execute_kw return execute(db_name, SUPERUSER_ID, model, method, *args, **kwargs) File "/odoo/odoo-server/odoo/service/model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "/odoo/odoo-server/odoo/service/model.py", line 175, in execute res = execute_cr(cr, uid, obj, method, *args, **kw) File "/odoo/odoo-server/odoo/service/model.py", line 159, in execute_cr result = odoo.api.call_kw(recs, method, args, kw) File "/odoo/odoo-server/odoo/api.py", line 395, in call_kw result = _call_kw_model(method, model, args, kwargs) File "/odoo/odoo-server/odoo/api.py", line 368, in _call_kw_model result = method(recs, *args, **kwargs) File "/odoo/odoo-server/odoo/models.py", line 1685, in search_count res = self.search(args, count=True) File "/odoo/odoo-server/odoo/models.py", line 1708, in search res = self._search(args, offset=offset, limit=limit, order=order, count=count) File "/odoo/odoo-server/odoo/addons/base/models/res_users.py", line 539, in _search return super(Users, self)._search(args, offset=offset, limit=limit, order=order, count=count, File "/odoo/odoo-server/odoo/models.py", line 4514, in _search query = self._where_calc(args) File "/odoo/odoo-server/odoo/models.py", line 4270, in _where_calc return expression.expression(domain, self).query File "/odoo/odoo-server/odoo/osv/expression.py", line 442, in init self.parse() File "/odoo/odoo-server/odoo/osv/expression.py", line 654, in parse raise ValueError("Invalid field %s.%s in leaf %s" % (model._name, path[0], str(leaf))) ValueError: Invalid field res.users.is_excluded_from_limiting in leaf ('is_excluded_from_limiting', '=', False)

Steps to recreate the above exception:

1. Installed fresh odoo14 instance.
2. Installed SaaS base.
3. Followed SaaS base doc instructions and everything worked.
4. Installed SaaS limit max users.
5. Tried to create a build from the template.
6. Got the above error.

Way to resolve it

1. I deleted the failed build.
2. Went to the template I created the build from.
3. Click install missing modules button in the template database.
4. Again created a build.
5. Didn't get the above exception

@killday May be this will solve your problem.

[killday]

Thank you very much for that but in my case, I don't use a template but apps. I will try your solution anyway. Thanks again

[killday]

With a clean install, first error I get is:

Traceback (most recent call last):
File "/opt/odoo14/custom/auth_signup_verify_email/controllers/main.py", line 59, in passwordless_signup
sudo_users.signup(values, qcontext.get("token"))
File "/opt/odoo14/custom/saas_apps_signup/models/res_users.py", line 31, in signup
return self.signup_to_try(values, *args, **kwargs)
File "/opt/odoo14/custom/saas_apps_signup/models/res_users.py", line 43, in signup_to_try
operator_id = int(values.pop("operator_id"))
KeyError: 'operator_id'

My workaround for that is:

/saas_apps_signup/controllers/main.py

@route("/saas_apps_signup/make_database_for_trial", auth="public", type="http", website=True)
def make_database_for_trial(self, period, max_users_limit, database_name=None, installing_modules=None, saas_template_id=None,operator_id=None, **kw):
if operator_id == None:
template = request.env.ref("saas_apps.base_template")
operator_id = template._random_ready_operator_id()
print(operator_id)
print(template)
params = {
"max_users_limit": max_users_limit,
"period": period,
"installing_modules": installing_modules or "",
"saas_template_id": saas_template_id or "",
"operator_id":operator_id or "",
}

/saas_apps_signup/controllers/auth_signup.py

class Main(SignupVerifyEmail):
def get_auth_signup_qcontext(self):
values = request.params
d = super(Main, self).get_auth_signup_qcontext()
if "max_users_limit" in values:
d["installing_modules"] = values.get("installing_modules", "").split(",")
d["saas_template_id"] = values.get("saas_template_id", "")
d["max_users_limit"] = int(values.get("max_users_limit", 1))
d["period"] = values.get("period", "")
d["operator_id"] = values.get("operator_id")
d["sale_order_id"] = values.get("sale_order_id")
else:
return d

After that when I go for try now with apps the error is the one from this post and if I go for template I get:

Traceback (most recent call last):
File "/opt/odoo14/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/opt/odoo14/odoo/odoo/http.py", line 806, in dispatch
r = self._call_function(**self.params)
File "/opt/odoo14/odoo/odoo/http.py", line 359, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/http.py", line 347, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 912, in call
return self.method(*args, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/opt/odoo14/custom/auth_signup_verify_email/controllers/main.py", line 21, in web_auth_signup
return super().web_auth_signup(*args, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/opt/odoo14/odoo/addons/auth_signup/controllers/main.py", line 30, in web_auth_signup
qcontext = self.get_auth_signup_qcontext()
File "/opt/odoo14/custom/saas_apps_signup/controllers/auth_signup.py", line 37, in get_auth_signup_qcontext
assert not (d["installing_modules"] and d["saas_template_id"])
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/odoo14/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/opt/odoo14/odoo/odoo/http.py", line 806, in dispatch
r = self._call_function(**self.params)
File "/opt/odoo14/odoo/odoo/http.py", line 359, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/http.py", line 347, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 912, in call
return self.method(*args, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/opt/odoo14/custom/auth_signup_verify_email/controllers/main.py", line 21, in web_auth_signup
return super().web_auth_signup(*args, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/opt/odoo14/odoo/addons/auth_signup/controllers/main.py", line 30, in web_auth_signup
qcontext = self.get_auth_signup_qcontext()
File "/opt/odoo14/custom/saas_apps_signup/controllers/auth_signup.py", line 37, in get_auth_signup_qcontext
assert not (d["installing_modules"] and d["saas_template_id"])
AssertionError

[killday]

Hi @glupeksha ,

Did you manage to fix the sign in process and build creation from the website frontend?

[glupeksha]

@killday Yeah, it worked. This is how I solved the problem #132 . But not sure whether it is correct or not.