Odoo Help

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,414 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?

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

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