saas plan cannot create template DB

[FLwalkaway]

Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 933, in call return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 882, in call_button action = self._call_kw(model, method, args, {}) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 870, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/addons/saas_portal/models/saas_portal.py", line 321, in create_template_button res = self.create_template() File "/usr/lib/python2.7/dist-packages/odoo/addons/saas_portal/models/saas_portal.py", line 343, in create_template raise Warning('Error on request: %s\nReason: %s \n Message: %s' % (req.url, res.reason, res.content)) Warning: Error on request: http://server.xxx.com:80/saas_server/new_database Reason: Not Found Message:

404 Not Found

---

nginx/1.10.0 (Ubuntu)

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[FLwalkaway]

above is odoo server error.Is there someone come with this problem? I cannot deal with it

[W360S]

This is nginx config error. make sure you have ^%h$ in db filter and nginx right config, also check with limit limit_time_cpu = 600 limit_time_real = 1200

[FLwalkaway]

thank you! I did't config nginx correctly. however,saas can not use "max user".if i log in client, i can not add other users. How can i solve this problem?

[W360S]

Check your plan, where is the user limit

[FLwalkaway]

if i want log in saas use email and password,we should provide "sign up" for users. should i install "saas portal sale"?

[FLwalkaway]

Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 933, in call return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 882, in call_button action = self._call_kw(model, method, args, {}) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 870, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/addons/base/module/module.py", line 410, in button_immediate_install return self._button_immediate_function(type(self).button_install) File "/usr/lib/python2.7/dist-packages/odoo/addons/base/module/module.py", line 484, in _button_immediate_function modules.registry.Registry.new(self._cr.dbname, update_module=True) File "/usr/lib/python2.7/dist-packages/odoo/modules/registry.py", line 78, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/usr/lib/python2.7/dist-packages/odoo/modules/loading.py", line 339, in load_modules loaded_modules, update_module) File "/usr/lib/python2.7/dist-packages/odoo/modules/loading.py", line 237, in load_marked_modules loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks) File "/usr/lib/python2.7/dist-packages/odoo/modules/loading.py", line 156, in load_module_graph _load_data(cr, module_name, idref, mode, kind='data') File "/usr/lib/python2.7/dist-packages/odoo/modules/loading.py", line 95, in _load_data tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report) File "/usr/lib/python2.7/dist-packages/odoo/tools/convert.py", line 848, in convert_file convert_xml_import(cr, module, fp, idref, mode, noupdate, report) File "/usr/lib/python2.7/dist-packages/odoo/tools/convert.py", line 918, in convert_xml_import obj.parse(doc.getroot(), mode=mode) File "/usr/lib/python2.7/dist-packages/odoo/tools/convert.py", line 799, in parse self.parse(rec, mode) File "/usr/lib/python2.7/dist-packages/odoo/tools/convert.py", line 802, in parse self._tags[rec.tag](rec, de, mode=mode) File "/usr/lib/python2.7/dist-packages/odoo/tools/convert.py", line 710, in _tag_record id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode) File "/usr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_model.py", line 1192, in _update record = record.create(values) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3811, in create record = self.browse(self._create(old_vals)) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3901, in _create cr.execute(query, tuple(u[2] for u in updates if len(u) > 2)) File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper return f(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute res = self._obj.execute(query, params) ParseError: "duplicate key value violates unique constraint "ir_config_parameter_key_uniq" DETAIL: Key (key)=(saas_portal.page_for_nonfree_subdomains) already exists. " while parsing /usr/lib/python2.7/dist-packages/odoo/addons/saas_portal_sale/data/ir_config_parameter.xml:4, near saas_portal.page_for_nonfree_subdomains /

[FLwalkaway]

if i install mudule"saas portal sale" ,above is odoo server error

[W360S]

DETAIL: Key (key)=(saas_portal.page_for_nonfree_subdomains) already exists. " while parsing /usr/lib/python2.7/dist-packages/odoo/addons/saas_portal_sale/data/ir_config_parameter.xml:4, near

saas_portal.page_for_nonfree_subdomains / Here is the error

[W360S]

it say key exists

DETAIL: Key (key)=(saas_portal.page_for_nonfree_subdomains) already exists.

[sathwiksunderreddy]

Hi I am trying to create a template db in Saas module but getting the below error pls help me

Thanks in Advance

Odoo Server Error Traceback (most recent call last): File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 544, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 581, in dispatch result = self._call_function(**self.params) File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 317, in _call_function return checked_call(self.db, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\service\model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 314, in checked_call return self.endpoint(*a, **kw) File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 810, in call return self.method(*args, **kw) File "D:\New odoo\odoo-8.0-20170403\openerp\http.py", line 410, in response_wrap response = f(*args, **kw) File "D:\New odoo\odoo-8.0-20170403\openerp\addons\web\controllers\main.py", line 948, in call_button action = self._call_kw(model, method, args, {}) File "D:\New odoo\odoo-8.0-20170403\openerp\addons\web\controllers\main.py", line 936, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\api.py", line 268, in wrapper return old_api(self, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\api.py", line 399, in old_api result = method(recs, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\addons\saas_portal\models\saas_portal.py", line 344, in create_template_button res = self.create_template() File "D:\New odoo\odoo-8.0-20170403\openerp\api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "D:\New odoo\odoo-8.0-20170403\openerp\addons\saas_portal\models\saas_portal.py", line 365, in create_template raise Warning('Error on request: %s\nReason: %s \n Message: %s' % (req.url, res.reason, res.content)) Warning: Error on request: http://localhost:8069/saas_server/new_database Reason: NOT FOUND Message:

Not Found

The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.

[W360S]

check your nginx configuration and also do not naming existing db

[sathwiksunderreddy]

I checked the nginx configuration its working fine and I am naming unique db

actually I am trying it in local odoo instance Its poping up the same error

Thanks

[oanhle]

Hi all, I'm also get the same error. But I fixed it. please run command pip uninstall Werkzeug pip install requests --upgrade Because the packages block this requests. p/s: the saas only running on Ubuntu 14.04 above

[ovnicraft]

Please check this: https://it-projects-llc.github.io/odoo-saas-tools/blog/reason-not-found

[butagreeza]

Am trying to create a TemplateDB but am having this error. Traceback (most recent call last): File "/var/repo/mautinoa/odoo/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/var/repo/mautinoa/odoo/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/var/repo/mautinoa/odoo/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/var/repo/mautinoa/odoo/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/var/repo/mautinoa/odoo/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/var/repo/mautinoa/odoo/odoo/http.py", line 933, in call return self.method(*args, **kw) File "/var/repo/mautinoa/odoo/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/var/repo/mautinoa/odoo/addons/web/controllers/main.py", line 882, in call_button action = self._call_kw(model, method, args, {}) File "/var/repo/mautinoa/odoo/addons/web/controllers/main.py", line 870, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/var/repo/mautinoa/odoo/odoo/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/var/repo/mautinoa/odoo/odoo/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/var/repo/mautinoa/odoo/custom/community/saas_portal/models/saas_portal.py", line 351, in create_template_button res = self.create_template() File "/var/repo/mautinoa/odoo/custom/community/saas_portal/models/saas_portal.py", line 374, in create_template data = simplejson.loads(res.text) File "/var/repo/env/mautinoa/local/lib/python2.7/site-packages/simplejson/init.py", line 516, in loads return _default_decoder.decode(s) File "/var/repo/env/mautinoa/local/lib/python2.7/site-packages/simplejson/decoder.py", line 370, in decode obj, end = self.raw_decode(s) File "/var/repo/env/mautinoa/local/lib/python2.7/site-packages/simplejson/decoder.py", line 400, in raw_decode return self.scan_once(s, idx=_w(s, idx).end()) JSONDecodeError: Expecting value: line 1 column 1 (char 0)

Any suggestions??

[JETSHUB]

I got this error Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/SME cloud/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 933, in call return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/SME cloud/http.py", line 504, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/SME cloud/addons/web/controllers/main.py", line 882, in call_button action = self._call_kw(model, method, args, {}) File "/usr/lib/python2.7/dist-packages/SME cloud/addons/web/controllers/main.py", line 870, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python2.7/dist-packages/SME cloud/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/usr/lib/python2.7/dist-packages/SME cloud/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/home/SME cloud/SME cloud-saas-tools/saas_portal/models/saas_portal.py", line 336, in create_template_button res = self.create_template() File "/home/SME cloud/SME cloud-saas-tools/saas_portal/models/saas_portal.py", line 358, in create_template raise Warning('Error on request: %s\nReason: %s \n Message: %s' % (req.url, res.reason, res.content)) Warning: Error on request: https://clients.xxxx.xxx:443/saas_server/new_database Reason: INTERNAL SERVER ERROR Message: "External ID not found in the system: website.assets_frontend" while parsing None:5, near

[W360S]

Warning: Error on request: https://clients.xxxx.xxx:443/saas_server/new_database Reason: INTERNAL SERVER ERROR Message: "External ID not found in the system: website.assets_frontend" while parsing None:5, near check this.

[serpentcs-dev1]

Hello @njeudy , I am facing the same issue, I checked this post https://it-projects-llc.github.io/odoo-saas-tools/blog/reason-not-found.

I am installing saas in localhost, it is showing me this while creating a new client : http://localhost:8069/saas_server/new_database

As -db-filter=^%h$ will not help in localhost. Then can you please advise what is the solution for this?

[W360S]

you need to make sure your local domain work first.

[serpentcs-dev1]

@W360S I tried manually earlier it was saying 404, I found that the saas_server module was not installed on the saas-portal-11.local database, I installed it and then tried again, it is working now manually but not from the code still while creating the client!

cc @njeudy

[serpentcs-dev1]

@oanhle Does the below solution works for you, I am still getting http://localhost:8069/saas_server/new_database in localhost while creating client.

Hi all, I'm also get the same error. But I fixed it. please run command pip uninstall Werkzeug pip install requests --upgrade Because the packages block this requests. p/s: the saas only running on Ubuntu 14.04 above

[oanhle]

@darshan-serpent I think you have got some mistakes. on the database server, you should only install module saas_server to manage database for saas. On the database client, you don't install saas_server, must be install saas_portal, saas_base ...... Between them mustbe login by saas auth by IP, account....

[bitsnaps]

I had the same issue, I fixed that by filling DB Names field (e.g. tt%i.odoo.local)