agrihold / sagi

Sistema de Mantenimiento y Seguimiento de Documentos.
1 stars 0 forks source link

Error al crear casi cualquier cosa que tenga wf #208

Closed jjscarafia closed 11 years ago

jjscarafia commented 11 years ago

El error ocurre sobre la base de datos "_sagi" (lo tengo local y en openerp.agrihold) Lo probé intentando crear officail letters, informations y solicitud de muestra. En una base de datos nueva no pasa este error. Intenté actualizar desde base pero no arregla el error.

DETALLE DEL EROR

Client Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/http.py", line 203, in dispatch response["result"] = method(self, *_self.params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1129, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw return getattr(req.session.model(model), method)(_args, *kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/netsvc.py", line 293, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/service/web_services.py", line 620, in dispatch res = fn(db, uid, _params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, args, _kw or {}) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/mail/mail_thread.py", line 242, in create thread_id = super(mail_thread, self).create(cr, uid, values, context=context) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/orm.py", line 4488, in create self._workflow_trigger(cr, user, [id_new], 'trg_create', context=context) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/orm.py", line 3919, in _workflow_trigger getattr(wf_service, trigger)(uid, self._name, res_id, cr) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/workflow/wkf_service.py", line 103, in trg_create instance.create(cr, ident, wkf_id) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/workflow/instance.py", line 25, in create cr.execute('insert into wkf_instance (res_type,res_id,uid,wkf_id) values (%s,%s,%s,%s) RETURNING id', (res_type,res_id,uid,wkf_id)) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 161, in wrapper return f(self, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: ERRO: coluna "uid" da relação "wkf_instance" não existe LINHA 1: insert into wkf_instance (res_type,res_id,uid,wkf_id) values...

csrocha commented 11 years ago

Este issue lo resuelvo yo. Conozco el problema. El may 29, 2013 4:07 PM, "Juan José Scarafía" notifications@github.com escribió:

El error ocurre sobre la base de datos "_sagi" (lo tengo local y en openerp.agrihold) Lo probé intentando crear officail letters, informations y solicitud de muestra. En una base de datos nueva no pasa este error. Intenté actualizar desde base pero no arregla el error.

DETALLE DEL EROR

Client Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/http.py", line 203, in dispatch response["result"] = method(self, *_self.params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1129, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw return getattr(req.session.model(model), method)(_args, *kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/netsvc.py", line 293, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/service/web_services.py", line 620, in dispatch res = fn(db, uid, _params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, args, _kw or {}) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/mail/mail_thread.py", line 242, in create thread_id = super(mail_thread, self).create(cr, uid, values, context=context) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/orm.py", line 4488, in create self._workflow_trigger(cr, user, [id_new], 'trg_create', context=context) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/orm.py", line 3919, in _workflow_trigger getattr(wf_service, trigger)(uid, self._name, res_id, cr) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/workflow/wkf_service.py", line 103, in trg_create instance.create(cr, ident, wkf_id) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/workflow/instance.py", line 25, in create cr.execute('insert into wkf_instance (res_type,res_id,uid,wkf_id) values (%s,%s,%s,%s) RETURNING id', (res_type,res_id,uid,wkf_id)) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 161, in wrapper return f(self, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: ERRO: coluna "uid" da relação "wkf_instance" não existe LINHA 1: insert into wkf_instance (res_type,res_id,uid,wkf_id) values...

— Reply to this email directly or view it on GitHubhttps://github.com/agrihold/sagi/issues/208 .

csrocha commented 11 years ago

es una tontería Estuve limpiando de columnas inútiles a la base de datos _sagi y una de las columnas que eliminé fue uid de wkf_instance Prometo recuperar eso en un par de horas.

jjscarafia commented 11 years ago

Se probaron todos, parece andar todo bien. Se podría cerrar

csrocha commented 11 years ago

Excelente. Voy cerrando.