I have managed to test it. Everything is working well up to the point where I compute a KPI and execute a query against an external database (MySQL). I got this error message:
Server Traceback (most recent call last):
File "/home/max/openerp/web/7.0/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/home/max/openerp/server/7.0/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/home/max/openerp/server/7.0/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/home/max/openerp/server/7.0/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/home/max/openerp/server/7.0/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/max/openerp/server/7.0/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/max/openerp/server/7.0/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/max/openerp/mgmtsystem/7.0/mgmtsystem_kpi/mgmtsystem_kpi.py", line 294, in compute_kpi_value
res = dbsrc_obj.execute(obj.kpi_code)
File "/home/max/openerp/server/7.0/openerp/osv/orm.py", line 374, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/home/max/openerp/local/base_external_dbsource/base_external_dbsource.py", line 140, in execute
cur = conn.execute(sqlquery, sqlparams)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
statement, parameters
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 159, in execute
query = query % db.literal(args)
TypeError: not all arguments converted during string formatting
@Daniel
I have managed to test it. Everything is working well up to the point where I compute a KPI and execute a query against an external database (MySQL). I got this error message:
Server Traceback (most recent call last): max/openerp/ web/7.0/ addons/ web/session. py", line 89, in send netsvc. dispatch_ rpc(service_ name, method, args) max/openerp/ server/ 7.0/openerp/ netsvc. py", line 292, in dispatch_rpc getService( service_ name).dispatch( method, params) max/openerp/ server/ 7.0/openerp/ service/ web_services. py", line 626, in dispatch max/openerp/ server/ 7.0/openerp/ osv/osv. py", line 188, in execute_kw max/openerp/ server/ 7.0/openerp/ osv/osv. py", line 131, in wrapper max/openerp/ server/ 7.0/openerp/ osv/osv. py", line 197, in execute max/openerp/ server/ 7.0/openerp/ osv/osv. py", line 185, in execute_cr max/openerp/ mgmtsystem/ 7.0/mgmtsystem_ kpi/mgmtsystem_ kpi.py" , line 294, in compute_kpi_value execute( obj.kpi_ code) max/openerp/ server/ 7.0/openerp/ osv/orm. py", line 374, in function_proxy max/openerp/ local/base_ external_ dbsource/ base_external_ dbsource. py", line 140, in execute sqlquery, sqlparams) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1449, in execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1628, in _execute_text python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1691, in _execute_context python2. 7/dist- packages/ sqlalchemy/ engine/ default. py", line 331, in do_execute execute( statement, parameters) python2. 7/dist- packages/ MySQLdb/ cursors. py", line 159, in execute
File "/home/
return openerp.
File "/home/
result = ExportService.
File "/home/
res = fn(db, uid, *params)
File "/home/
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/
res = dbsrc_obj.
File "/home/
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/home/
cur = conn.execute(
File "/usr/lib/
params)
File "/usr/lib/
statement, parameters
File "/usr/lib/
context)
File "/usr/lib/
cursor.
File "/usr/lib/
query = query % db.literal(args)
TypeError: not all arguments converted during string formatting
I will do further debugging tomorrow.