Kombajn

KS2: 6454U-2024 Hafnia Amessi - Suntech Ship Management Pvt. Ltd, po kliknięciu upload mc wyświetla się, że nie ma żadnych błędów ale na skypie przychodzi wiadomośc:

There was an error while uploading measurement card for report no. 16797

Traceback (most recent call last):
File "/queue/tasks.py", line 1079, in upload_measurement_card
importData.read_file_data(kwargs['shipid'])
File "/queue/modules/MeasurementCardModules/measurementCardNew.py", line 446, in read_file_data
owner = session.query(Ship.owner_id_fkey).filter(Ship.ship_id_pkey == shipid).first()[0]
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2762, in first
return self.limit(1)._iter().first()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1688, in execute
conn = self._connection_for_bind(bind)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1529, in _connection_for_bind
return self._transaction._connection_for_bind(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 721, in _connection_for_bind
self._assert_active()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 601, in _assert_active
raise sa_exc.PendingRollbackError(
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type integer: ""
LINE 1: ...ibution.', NULL, NULL, NULL, NULL, NULL, NULL, 1, '', NULL, ...
^

[SQL: INSERT INTO kombajn.thermo_report_pages (remark, im_comments, image_thermo_fkey, image_base_fkey, line_coordinates_list_str, rectangle_coordinates_list_str, chart_data, page_no, harmo_fkey, page_discriminator, photo_base_config, show_in_report, severity_fkey, measurement_date, date_removed) VALUES (%(remark)s, %(im_comments)s, %(image_thermo_fkey)s, %(image_base_fkey)s, %(line_coordinates_list_str)s, %(rectangle_coordinates_list_str)s, %(chart_data)s, %(page_no)s, %(harmo_fkey)s, %(page_discriminator)s, %(photo_base_config)s, %(show_in_report)s, %(severity_fkey)s, %(measurement_date)s, %(date_removed)s) RETURNING kombajn.thermo_report_pages.id]
[parameters: {'remark': 'Proper temperature distribution.', 'im_comments': None, 'image_thermo_fkey': None, 'image_base_fkey': None, 'line_coordinates_list_str': None, 'rectangle_coordinates_list_str': None, 'chart_data': None, 'page_no': 1, 'harmo_fkey': '', 'page_discriminator': None, 'photo_base_config': '{"contrast": "1", "saturate": "1", "brightness": "1"}', 'show_in_report': False, 'severity_fkey': 1, 'measurement_date': '2024-08-12', 'date_removed': None}]
(Background on this error at: https://sqlalche.me/e/14/9h9h) (Background on this error at: https://sqlalche.me/e/14/7s2a)

There was an error while uploading measurement card for report no. 16797

Traceback (most recent call last):
File "/queue/tasks.py", line 1079, in upload_measurement_card
importData.read_file_data(kwargs['shipid'])
File "/queue/modules/MeasurementCardModules/measurementCardNew.py", line 446, in read_file_data
owner = session.query(Ship.owner_id_fkey).filter(Ship.ship_id_pkey == shipid).first()[0]
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2762, in first
return self.limit(1)._iter().first()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1688, in execute
conn = self._connection_for_bind(bind)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1529, in _connection_for_bind
return self._transaction._connection_for_bind(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 721, in _connection_for_bind
self._assert_active()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 601, in _assert_active
raise sa_exc.PendingRollbackError(
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type integer: ""
LINE 1: ...ibution.', NULL, NULL, NULL, NULL, NULL, NULL, 1, '', NULL, ...
^

[SQL: INSERT INTO kombajn.thermo_report_pages (remark, im_comments, image_thermo_fkey, image_base_fkey, line_coordinates_list_str, rectangle_coordinates_list_str, chart_data, page_no, harmo_fkey, page_discriminator, photo_base_config, show_in_report, severity_fkey, measurement_date, date_removed) VALUES (%(remark)s, %(im_comments)s, %(image_thermo_fkey)s, %(image_base_fkey)s, %(line_coordinates_list_str)s, %(rectangle_coordinates_list_str)s, %(chart_data)s, %(page_no)s, %(harmo_fkey)s, %(page_discriminator)s, %(photo_base_config)s, %(show_in_report)s, %(severity_fkey)s, %(measurement_date)s, %(date_removed)s) RETURNING kombajn.thermo_report_pages.id]
[parameters: {'remark': 'Proper temperature distribution.', 'im_comments': None, 'image_thermo_fkey': None, 'image_base_fkey': None, 'line_coordinates_list_str': None, 'rectangle_coordinates_list_str': None, 'chart_data': None, 'page_no': 1, 'harmo_fkey': '', 'page_discriminator': None, 'photo_base_config': '{"contrast": "1", "saturate": "1", "brightness": "1"}', 'show_in_report': False, 'severity_fkey': 1, 'measurement_date': '2024-08-12', 'date_removed': None}]
(Background on this error at: https://sqlalche.me/e/14/9h9h) (Background on this error at: https://sqlalche.me/e/14/7s2a)

There was an error while uploading measurement card for report no. 16797

Traceback (most recent call last):
File "/queue/tasks.py", line 1079, in upload_measurement_card
importData.read_file_data(kwargs['shipid'])
File "/queue/modules/MeasurementCardModules/measurementCardNew.py", line 446, in read_file_data
owner = session.query(Ship.owner_id_fkey).filter(Ship.ship_id_pkey == shipid).first()[0]
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2762, in first
return self.limit(1)._iter().first()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1688, in execute
conn = self._connection_for_bind(bind)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1529, in _connection_for_bind
return self._transaction._connection_for_bind(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 721, in _connection_for_bind
self._assert_active()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 601, in _assert_active
raise sa_exc.PendingRollbackError(
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type integer: ""
LINE 1: ...ibution.', NULL, NULL, NULL, NULL, NULL, NULL, 1, '', NULL, ...
^

[SQL: INSERT INTO kombajn.thermo_report_pages (remark, im_comments, image_thermo_fkey, image_base_fkey, line_coordinates_list_str, rectangle_coordinates_list_str, chart_data, page_no, harmo_fkey, page_discriminator, photo_base_config, show_in_report, severity_fkey, measurement_date, date_removed) VALUES (%(remark)s, %(im_comments)s, %(image_thermo_fkey)s, %(image_base_fkey)s, %(line_coordinates_list_str)s, %(rectangle_coordinates_list_str)s, %(chart_data)s, %(page_no)s, %(harmo_fkey)s, %(page_discriminator)s, %(photo_base_config)s, %(show_in_report)s, %(severity_fkey)s, %(measurement_date)s, %(date_removed)s) RETURNING kombajn.thermo_report_pages.id]
[parameters: {'remark': 'Proper temperature distribution.', 'im_comments': None, 'image_thermo_fkey': None, 'image_base_fkey': None, 'line_coordinates_list_str': None, 'rectangle_coordinates_list_str': None, 'chart_data': None, 'page_no': 1, 'harmo_fkey': '', 'page_discriminator': None, 'photo_base_config': '{"contrast": "1", "saturate": "1", "brightness": "1"}', 'show_in_report': False, 'severity_fkey': 1, 'measurement_date': '2024-08-12', 'date_removed': None}]
(Background on this error at: https://sqlalche.me/e/14/9h9h) (Background on this error at: https://sqlalche.me/e/14/7s2a)