This question has been flagged
1 Reply
4229 Views

I had a new PoS session from a colleague, money not jet counted, session not quitted and opened. My colleague went into weekend with the session still open.

As the administrator I cheked the session in the view "All sessions" and pressed the delete button cause nothing was really done in this session.

However - it was not really deleted - still shown in "All sessions".
If I now try to open a new session I get the error that there is still one open:
ValidateError
Error occurred while validating the field(s) config_id: You cannot create two active sessions related to the same point of sale!

If I click at the line in the view "All sessions" I get the following error:
OpenERP Server Error
Client Traceback (most recent call last): File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/web/controllers/main.py", line 1128, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/web/controllers/main.py", line 1114, in _call_kw records = req.session.model(model).read(*args, **kwargs) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/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/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/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/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, *args, **kwargs) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 3612, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 3732, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/fields.py", line 1140, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/fields.py", line 1206, in _fnct_read value = value[field] or False File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 401, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 3612, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 3732, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/fields.py", line 1140, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/addons/account/account_cash_statement.py", line 126, in _compute_difference result[obj.id] = obj.balance_end_real - obj.balance_end File "/opt/bitnami/apps/openerp/lib/openerp-7.0_20131013_231025-py2.7.egg/openerp/osv/orm.py", line 488, in __getattr__ raise AttributeError(e) AttributeError: 'Field balance_end_real not found in browse_record(account.bank.statement, 192)'

Seems that the system still expects that I finish the session in the normal way which means to count the money, save and quit.

How can I revise / adjust this mistake?
I urgently need your help - it's my live database.
Maybe I can establish / create a second PoS as an interim solution?

Avatar
Discard
Best Answer

You cannot get 2 sessions for the user.

So close the first one , even with no transaction;

Then create a brand new fresh one

Avatar
Discard
Author

I was not able to close it - so I deleted the session. Now is has 2 status: "deleted" (proven when I tried to export the session, repair and import again) and "not closed" (message I get, when trying to open a new one)