{"action":"created","issue":{"url":"https://api.github.com/repos/OCA/mis-builder/issues/129","repository_url":"https://api.github.com/repos/OCA/mis-builder","labels_url":"https://api.github.com/repos/OCA/mis-builder/issues/129/labels{/name}","comments_url":"https://api.github.com/repos/OCA/mis-builder/issues/129/comments","events_url":"https://api.github.com/repos/OCA/mis-builder/issues/129/events","html_url":"https://github.com/OCA/mis-builder/issues/129","id":365494362,"node_id":"MDU6SXNzdWUzNjU0OTQzNjI=","number":129,"title":"Problem with MIS Budget in version 11","user":{"login":"PrismeUser","id":43753488,"node_id":"MDQ6VXNlcjQzNzUzNDg4","avatar_url":"https://avatars0.githubusercontent.com/u/43753488?v=4","gravatar_id":"","url":"https://api.github.com/users/PrismeUser","html_url":"https://github.com/PrismeUser","followers_url":"https://api.github.com/users/PrismeUser/followers","following_url":"https://api.github.com/users/PrismeUser/following{/other_user}","gists_url":"https://api.github.com/users/PrismeUser/gists{/gist_id}","starred_url":"https://api.github.com/users/PrismeUser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrismeUser/subscriptions","organizations_url":"https://api.github.com/users/PrismeUser/orgs","repos_url":"https://api.github.com/users/PrismeUser/repos","events_url":"https://api.github.com/users/PrismeUser/events{/privacy}","received_events_url":"https://api.github.com/users/PrismeUser/received_events","type":"User","site_admin":false},"labels":[{"id":706778137,"node_id":"MDU6TGFiZWw3MDY3NzgxMzc=","url":"https://api.github.com/repos/OCA/mis-builder/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-10-01T14:41:35Z","updated_at":"2018-10-01T15:41:32Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nI encouter the following problem with MIS-Builder regarding budget : \r\n\r\nWhen I go on Invoicing then I click Reporting and then MIS-Report \r\n\r\nThen I create a new report as follow : \r\n![image](https://user-images.githubusercontent.com/43753488/46295423-4ea5f500-c598-11e8-9786-4e92151d8bb9.png)\r\n\r\nThen I Click on Colums and I click on \"add Item\"\r\n![image](https://user-images.githubusercontent.com/43753488/46295523-90cf3680-c598-11e8-9f98-f426caf3657b.png)\r\n\r\nThen when I click on save and close, I receive a Error with the following message : \r\n\r\nError:\r\nOdoo Server Error\r\n\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 944, in __get__\r\n    value = record.env.cache.get(record, self)\r\n  File \"/usr/lib/python3/dist-packages/odoo/api.py\", line 960, in get\r\n    value = self._data[field][record.id][key]\r\nKeyError: <odoo.api.Environment object at 0x3fff7d655d30>\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 646, in _handle_exception\r\n    return super(JsonRequest, self)._handle_exception(exception)\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 307, in _handle_exception\r\n    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])\r\n  File \"/usr/lib/python3/dist-packages/odoo/tools/pycompat.py\", line 87, in reraise\r\n    raise value\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 683, in dispatch\r\n    result = self._call_function(**self.params)\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 339, in _call_function\r\n    return checked_call(self.db, *args, **kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/service/model.py\", line 97, in wrapper\r\n    return f(dbname, *args, **kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 332, in checked_call\r\n    result = self.endpoint(*a, **kw)\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 927, in __call__\r\n    return self.method(*args, **kw)\r\n  File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 512, in response_wrap\r\n    response = f(*args, **kw)\r\n  File \"/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py\", line 924, in call_kw\r\n    return self._call_kw(model, method, args, kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py\", line 916, in _call_kw\r\n    return call_kw(request.env[model], method, args, kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/api.py\", line 689, in call_kw\r\n    return call_kw_multi(method, model, args, kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/api.py\", line 680, in call_kw_multi\r\n    result = method(recs, *args, **kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4960, in onchange\r\n    record = self.new(values)\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4486, in new\r\n    record._cache.update(record._convert_to_cache(values, update=True))\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4359, in _convert_to_cache\r\n    for name, value in values.items()\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4360, in <dictcomp>\r\n    if name in fields\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 2066, in convert_to_cache\r\n    comodel.browse(command[1]).update(command[2])\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4467, in update\r\n    record[name] = value\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4671, in __setitem__\r\n    return self._fields[key].__set__(self, value)\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 966, in __set__\r\n    value = self.convert_to_cache(value, record)\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 2059, in convert_to_cache\r\n    ids = OrderedSet(record[self.name].ids if record.id else ())\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 4662, in __getitem__\r\n    return self._fields[key].__get__(self, type(self))\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 948, in __get__\r\n    self.determine_value(record)\r\n  File \"/usr/lib/python3/dist-packages/odoo/fields.py\", line 1049, in determine_value\r\n    record._prefetch_field(self)\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 2565, in _prefetch_field\r\n    result = records.read([f.name for f in fs], load='_classic_write')\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 2509, in read\r\n    self._read_from_database(stored, inherited)\r\n  File \"/usr/lib/python3/dist-packages/odoo/models.py\", line 2628, in _read_from_database\r\n    cr.execute(query_str, params)\r\n  File \"/usr/lib/python3/dist-packages/odoo/sql_db.py\", line 155, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/usr/lib/python3/dist-packages/odoo/sql_db.py\", line 232, in execute\r\n    res = self._obj.execute(query, params)\r\npsycopg2.DataError: invalid input syntax for integer: \"virtual_41\"\r\nLINE 1: ...period\" WHERE \"mis_report_instance_period\".id IN ('virtual_4...\r\n                                                             ^\r\nMe and my team did not manage to find any solution for this issue...\r\nPlease let me know if you have any solutions.\r\n\r\nThank you in advance for your help.\r\n\r\nBR\r\n\r\nMaxime\r\n"},"comment":{"url":"https://api.github.com/repos/OCA/mis-builder/issues/comments/425955528","html_url":"https://github.com/OCA/mis-builder/issues/129#issuecomment-425955528","issue_url":"https://api.github.com/repos/OCA/mis-builder/issues/129","id":425955528,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNTk1NTUyOA==","user":{"login":"PrismeUser","id":43753488,"node_id":"MDQ6VXNlcjQzNzUzNDg4","avatar_url":"https://avatars0.githubusercontent.com/u/43753488?v=4","gravatar_id":"","url":"https://api.github.com/users/PrismeUser","html_url":"https://github.com/PrismeUser","followers_url":"https://api.github.com/users/PrismeUser/followers","following_url":"https://api.github.com/users/PrismeUser/following{/other_user}","gists_url":"https://api.github.com/users/PrismeUser/gists{/gist_id}","starred_url":"https://api.github.com/users/PrismeUser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrismeUser/subscriptions","organizations_url":"https://api.github.com/users/PrismeUser/orgs","repos_url":"https://api.github.com/users/PrismeUser/repos","events_url":"https://api.github.com/users/PrismeUser/events{/privacy}","received_events_url":"https://api.github.com/users/PrismeUser/received_events","type":"User","site_admin":false},"created_at":"2018-10-01T15:41:32Z","updated_at":"2018-10-01T15:41:32Z","author_association":"NONE","body":"Hello Stéphane, \n\nInfortunately not...\n\nBest regards,\n\nMaxime Provini \n\nEnvoyé depuis IBM Verse\n\n\n   Stéphane Bidoul (ACSONE) --- Re: [OCA/mis-builder] Problem with MIS Budget in version 11 (#129) --- \n    De :\"Stéphane Bidoul (ACSONE)\" <notifications@github.com>A :\"OCA/mis-builder\" <mis-builder@noreply.github.com>Cc :\"PrismeUser\" <maxime.provini@prisme.ch>, \"Author\" <author@noreply.github.com>Date :lun., 1 oct. 2018 17:37Objet :Re: [OCA/mis-builder] Problem with MIS Budget in version 11 (#129)\n  \n  Are you at the code sprint? \n —You are receiving this because you authored the thread.Reply to this email directly, view it on GitHub, or mute the thread.\n"}}
{"actor":{"display_login":"PrismeUser"}}