Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

openerp server error when generating invoice through contracts(DataError:invalid input syntax for integer:"[26]")

By
sneha antony
on 2/15/14, 2:45 AM 1,229 views

hi,I encountered a little error when I tried to create an invoice in sales/Contacts.The error is

Client Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, *self.params) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1129, in call_button action = self._call_kw(req, model, method, args, {}) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1117, in _call_kw return getattr(req.session.model(model), method)(args, **kwargs) File "/opt/openerp/server/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/opt/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/openerp/server/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/opt/openerp/server/openerp/osv/osv.py", line 190, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/opt/openerp/server/openerp/osv/osv.py", line 132, in wrapper return f(self, dbname, args, *kwargs) File "/opt/openerp/server/openerp/osv/osv.py", line 199, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/opt/openerp/server/openerp/osv/osv.py", line 187, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/opt/openerp/server/openerp/addons/stock/wizard/stock_invoice_onshipping.py", line 106, in open_invoice res = self.create_invoice(cr, uid, ids, context=context) File "/opt/openerp/server/openerp/addons/stock/wizard/stock_invoice_onshipping.py", line 146, in create_invoice context=context) File "/opt/openerp/server/openerp/addons/stock/stock.py", line 1159, in action_invoice_create invoice_line_id = invoice_line_obj.create(cr, uid, vals, context=context) File "/opt/openerp/server/openerp/addons/account_analytic_plans/account_analytic_plans.py", line 304, in create return super(account_invoice_line, self).create(cr, uid, vals, context=context) File "/opt/openerp/server/openerp/osv/orm.py", line 4457, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) DataError: invalid input syntax for integer: "[26]" LINE 1: ...PATCH PANEL-AMP',10,77,'100.00','0.00',59,'1.000','[26]',16,...

Here the 24-patch panel-AMP is the product which I choose in while generating Sales Order,but the entry "[26]" confuses me.Not able to trace the root of that entry.Can any one please help?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 2/15/14, 2:45 AM
Seen: 1229 times
Last updated: 3/16/15, 8:10 AM