ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True

markwb

Hello,

I recently upgraded to Xormon-NG 1.6.10

My prediction graphs are generated, but no longer contain any predictions, just the historical data. I found the following contained in the analyzer-error.log:

2024-11-20 10:50:38: Exception occurred during processing of request from ('127.0.0.1', 48142)

2024-11-20 10:50:38: Traceback (most recent call last):

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/socketserver.py", line 316, in _handle_request_noblock

2024-11-20 10:50:38:   self.process_request(request, client_address)

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/socketserver.py", line 347, in process_request

2024-11-20 10:50:38:   self.finish_request(request, client_address)

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/socketserver.py", line 360, in finish_request

2024-11-20 10:50:38:   self.RequestHandlerClass(request, client_address, self)

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/socketserver.py", line 747, in __init__

2024-11-20 10:50:38:   self.handle()

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/http/server.py", line 433, in handle

2024-11-20 10:50:38:   self.handle_one_request()

2024-11-20 10:50:38:  File "/usr/lib64/python3.9/http/server.py", line 421, in handle_one_request

2024-11-20 10:50:38:   method()

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/microservices/analyzer/analyzer-service.py", line 182, in do_POST

2024-11-20 10:50:38:   response = action_tree[action]["function"](post_data)

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/microservices/analyzer/controller.py", line 203, in process_one_request

2024-11-20 10:50:38:   processed_df = importer.processing_of_import(time_series, frequency, label=table)

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/microservices/analyzer/importer/importer.py", line 73, in processing_of_import

2024-11-20 10:50:38:   df['Date'] = pd.to_datetime(df['Date'])

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/venv/lib64/python3.9/site-packages/pandas/core/tools/datetimes.py", line 1067, in to_datetime

2024-11-20 10:50:38:   values = convert_listlike(arg._values, format)

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/venv/lib64/python3.9/site-packages/pandas/core/tools/datetimes.py", line 435, in _convert_listlike_datetimes

2024-11-20 10:50:38:   result, tz_parsed = objects_to_datetime64(

2024-11-20 10:50:38:  File "/u01/xormon/xormon-ng/server-nest/venv/lib64/python3.9/site-packages/pandas/core/arrays/datetimes.py", line 2398, in objects_to_datetime64

2024-11-20 10:50:38:   result, tz_parsed = tslib.array_to_datetime(

2024-11-20 10:50:38:  File "tslib.pyx", line 414, in pandas._libs.tslib.array_to_datetime

2024-11-20 10:50:38:  File "tslib.pyx", line 596, in pandas._libs.tslib.array_to_datetime

2024-11-20 10:50:38:  File "tslib.pyx", line 504, in pandas._libs.tslib.array_to_datetime

2024-11-20 10:50:38:  File "strptime.pyx", line 285, in pandas._libs.tslibs.strptime.DatetimeParseState.process_datetime

2024-11-20 10:50:38: ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True, at position 242

2024-11-20 10:50:38: ----------------------------------------

Has anyone else seen this? : ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True, at position 242

Pavel

there was a bug which is already fixed.

It will be release in a few weeks as XorMon NG 1.7 https://xormon.com/note170.php