URL: <https://savannah.gnu.org/bugs/?64464>
Summary: health_genetics export po file error. Group: GNU Health Submitter: tumashu Submitted: Mon 24 Jul 2023 04:59:53 AM UTC Category: None Severity: 3 - Normal Item Group: None Status: None Privacy: Public Assigned to: None Open/Closed: Open Release: None Discussion Lock: Any Module: health_genetics Component: Hospital Management _______________________________________________________ Follow-up Comments: ------------------------------------------------------- Date: Mon 24 Jul 2023 04:59:53 AM UTC By: Feng Shu <tumashu> During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 458, in parse_xmlstream self.sax_parser.parse(source) File "/usr/lib/python3.11/xml/sax/expatreader.py", line 111, in parse xmlreader.IncrementalParser.parse(self, source) File "/usr/lib/python3.11/xml/sax/xmlreader.py", line 125, in parse self.feed(buffer) File "/usr/lib/python3.11/xml/sax/expatreader.py", line 217, in feed self._parser.Parse(data, isFinal) File "../Modules/pyexpat.c", line 468, in EndElement File "/usr/lib/python3.11/xml/sax/expatreader.py", line 336, in end_element self._cont_handler.endElement(name) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 513, in endElement self.taghandler = self.taghandler.endElement(name) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 295, in endElement self.mh.import_record( File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 689, in import_record self.create_records(model, [values], [fs_id]) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 695, in create_records records = Model.create(vlist) ^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 159, in wrapper return func(cls, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 634, in create cls.__raise_integrity_error( File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 352, in __raise_integrity_error raise RequiredValidationError( trytond.model.modelstorage.RequiredValidationError: A value is required for field "aliases" in "gnuhealth.gene". - The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/bin/trytond-admin", line 23, in <module> admin.run(options) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/admin.py", line 53, in run pool.init(update=options.update, lang=list(lang), File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/pool.py", line 164, in init restart = not load_modules( ^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 440, in load_modules _load_modules(update) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 408, in _load_modules load_module_graph(graph, pool, update, lang) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 252, in load_module_graph tryton_parser.parse_xmlstream(fp) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 460, in parse_xmlstream raise Exception("Error " + self.current_state()) from e Exception: Error In tag record model gnuhealth.gene with id health_genetics.A2BP1. ## Add Language to tryton ... Connecting to database 'po-export-db' with 'admin' ... /usr/lib/python3/dist-packages/passlib/utils/__init__.py:854: DeprecationWarning: 'crypt' is deprecated and slated for removal in Python 3.13 from crypt import crypt as _crypt ## Running trytond-admin command to update DB (3. Active language) ... Traceback (most recent call last): File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 614, in create cursor.execute(*table.insert(insert_columns, File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/backend/postgresql/database.py", line 74, in execute cursor.execute(self, sql, args) psycopg2.errors.NotNullViolation: 错误: null value in column "aliases" of relation "gnuhealth_gene" violates not-null constraint DETAIL: 失败, 行包含(1, null, 16, 2023-07-24 04:57:44.862633, 0, null, null, null, mutations , 16p13, ataxin 2-binding protein 1, A2BP1, null, null, null). During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 458, in parse_xmlstream self.sax_parser.parse(source) File "/usr/lib/python3.11/xml/sax/expatreader.py", line 111, in parse xmlreader.IncrementalParser.parse(self, source) File "/usr/lib/python3.11/xml/sax/xmlreader.py", line 125, in parse self.feed(buffer) File "/usr/lib/python3.11/xml/sax/expatreader.py", line 217, in feed self._parser.Parse(data, isFinal) File "../Modules/pyexpat.c", line 468, in EndElement File "/usr/lib/python3.11/xml/sax/expatreader.py", line 336, in end_element self._cont_handler.endElement(name) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 513, in endElement self.taghandler = self.taghandler.endElement(name) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 295, in endElement self.mh.import_record( File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 689, in import_record self.create_records(model, [values], [fs_id]) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 695, in create_records records = Model.create(vlist) ^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 159, in wrapper return func(cls, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 634, in create cls.__raise_integrity_error( File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/model/modelsql.py", line 352, in __raise_integrity_error raise RequiredValidationError( trytond.model.modelstorage.RequiredValidationError: A value is required for field "aliases" in "gnuhealth.gene". - The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/bin/trytond-admin", line 23, in <module> admin.run(options) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/admin.py", line 53, in run pool.init(update=options.update, lang=list(lang), File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/pool.py", line 164, in init restart = not load_modules( ^^^^^^^^^^^^^ File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 440, in load_modules _load_modules(update) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 408, in _load_modules load_module_graph(graph, pool, update, lang) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/modules/__init__.py", line 252, in load_module_graph tryton_parser.parse_xmlstream(fp) File "/home/feng/gnuhealth/tryton/server/trytond-6.0.33/trytond/convert.py", line 460, in parse_xmlstream raise Exception("Error " + self.current_state()) from e Exception: Error In tag record model gnuhealth.gene with id health_genetics.A2BP1. _______________________________________________________ Reply to this item at: <https://savannah.gnu.org/bugs/?64464> _______________________________________________ Message sent via Savannah https://savannah.gnu.org/