173 lines
12 KiB
Plaintext
173 lines
12 KiB
Plaintext
2025-12-10 17:16:02,131 - log_config.py - error_task_logger - ERROR - NGV更新数据执行时发生异常: name 'data_NGV_j' is not defined
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\update_all_NGV_data_daily.py", line 106, in main
|
|
prepared_data = self._prepare_data_for_sync(changed_data, staff_id_map)
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\update_all_NGV_data_daily.py", line 561, in _prepare_data_for_sync
|
|
prepared_df['g_month_percentage'] = (pd.to_numeric(data_NGV_j['g_month_percentage'], errors='coerce')
|
|
^^^^^^^^^^
|
|
NameError: name 'data_NGV_j' is not defined
|
|
2025-12-15 10:53:08,519 - log_config.py - error_task_logger - ERROR - 经销商新签服务单转BI任务执行失败: '业务人员'
|
|
Traceback (most recent call last):
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 3812, in get_loc
|
|
return self._engine.get_loc(casted_key)
|
|
~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
|
|
File "pandas/_libs/index.pyx", line 167, in pandas._libs.index.IndexEngine.get_loc
|
|
File "pandas/_libs/index.pyx", line 196, in pandas._libs.index.IndexEngine.get_loc
|
|
File "pandas/_libs/hashtable_class_helper.pxi", line 7088, in pandas._libs.hashtable.PyObjectHashTable.get_item
|
|
File "pandas/_libs/hashtable_class_helper.pxi", line 7096, in pandas._libs.hashtable.PyObjectHashTable.get_item
|
|
KeyError: '业务人员'
|
|
|
|
The above exception was the direct cause of the following exception:
|
|
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\new_dealer_service_order_to_bi.py", line 198, in main
|
|
df = self.data_process()
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\new_dealer_service_order_to_bi.py", line 83, in data_process
|
|
df[col] = df[col].map(lambda x: x.get("name", "") if isinstance(x, dict) else "")
|
|
~~^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\frame.py", line 4107, in __getitem__
|
|
indexer = self.columns.get_loc(key)
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 3819, in get_loc
|
|
raise KeyError(key) from err
|
|
KeyError: '业务人员'
|
|
2025-12-25 14:47:59,066 - log_config.py - error_task_logger - ERROR - 合伙人结算登记同步到BI发生错误："None of [Index(['订单支付时间'], dtype='object')] are in the [columns]"
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\partner_settlement_to_BI.py", line 297, in main
|
|
df = self.data_process()
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\partner_settlement_to_BI.py", line 165, in data_process
|
|
df[time_columns] = df[time_columns].apply(
|
|
~~^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\frame.py", line 4113, in __getitem__
|
|
indexer = self.columns._get_indexer_strict(key, "columns")[1]
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 6212, in _get_indexer_strict
|
|
self._raise_if_missing(keyarr, indexer, axis_name)
|
|
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 6261, in _raise_if_missing
|
|
raise KeyError(f"None of [{key}] are in the [{axis_name}]")
|
|
KeyError: "None of [Index(['订单支付时间'], dtype='object')] are in the [columns]"
|
|
2025-12-25 14:48:41,241 - log_config.py - error_task_logger - ERROR - 合伙人结算登记同步到BI发生错误："None of [Index(['订单登记表.订单支付时间'], dtype='object')] are in the [columns]"
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\partner_settlement_to_BI.py", line 297, in main
|
|
df = self.data_process()
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\partner_settlement_to_BI.py", line 165, in data_process
|
|
df[time_columns] = df[time_columns].apply(
|
|
~~^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\frame.py", line 4113, in __getitem__
|
|
indexer = self.columns._get_indexer_strict(key, "columns")[1]
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 6212, in _get_indexer_strict
|
|
self._raise_if_missing(keyarr, indexer, axis_name)
|
|
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\base.py", line 6261, in _raise_if_missing
|
|
raise KeyError(f"None of [{key}] are in the [{axis_name}]")
|
|
KeyError: "None of [Index(['订单登记表.订单支付时间'], dtype='object')] are in the [columns]"
|
|
2025-12-25 15:31:38,149 - log_config.py - error_task_logger - ERROR - 非标业绩提报转BI发生错误Already tz-aware, use tz_convert to convert.
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\non_standar_performance_to_BI.py", line 287, in main
|
|
df = self.data_process()
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\non_standar_performance_to_BI.py", line 148, in data_process
|
|
df[time_columns] = df[time_columns].apply(
|
|
~~~~~~~~~~~~~~~~~~~~~~^
|
|
lambda col: pd.to_datetime(col, errors='coerce')
|
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
.dt.tz_localize('Asia/Shanghai')
|
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
.dt.strftime('%Y-%m-%d %H:%M:%S')
|
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
)
|
|
^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\frame.py", line 10381, in apply
|
|
return op.apply().__finalize__(self, method="apply")
|
|
~~~~~~~~^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\apply.py", line 916, in apply
|
|
return self.apply_standard()
|
|
~~~~~~~~~~~~~~~~~~~^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\apply.py", line 1063, in apply_standard
|
|
results, res_index = self.apply_series_generator()
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\apply.py", line 1081, in apply_series_generator
|
|
results[i] = self.func(v, *self.args, **self.kwargs)
|
|
~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\non_standar_performance_to_BI.py", line 150, in <lambda>
|
|
.dt.tz_localize('Asia/Shanghai')
|
|
~~~~~~~~~~~^^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\accessor.py", line 112, in f
|
|
return self._delegate_method(name, *args, **kwargs)
|
|
~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\accessors.py", line 132, in _delegate_method
|
|
result = method(*args, **kwargs)
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\indexes\datetimes.py", line 293, in tz_localize
|
|
arr = self._data.tz_localize(tz, ambiguous, nonexistent)
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\arrays\_mixins.py", line 81, in method
|
|
return meth(self, *args, **kwargs)
|
|
File "D:\ProgramTools\anaconda3\envs\saas\Lib\site-packages\pandas\core\arrays\datetimes.py", line 1085, in tz_localize
|
|
raise TypeError("Already tz-aware, use tz_convert to convert.")
|
|
TypeError: Already tz-aware, use tz_convert to convert.
|
|
2025-12-30 16:06:56,642 - log_config.py - error_task_logger - ERROR - 写入数据库时发生错误: No module named 'numpy.rec'
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\non_standar_performance_to_BI.py", line 204, in write_to_bi
|
|
df = df.replace([None, np.nan, pd.NA, 'nan', 'NaN', 'NAN', ''], None)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\generic.py", line 8125, in replace
|
|
new_data = self._mgr.replace_list(
|
|
src_list=to_replace,
|
|
...<2 lines>...
|
|
regex=regex,
|
|
)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\internals\base.py", line 278, in replace_list
|
|
bm = self.apply_with_block(
|
|
"replace_list",
|
|
...<5 lines>...
|
|
already_warned=_AlreadyWarned(),
|
|
)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\internals\managers.py", line 363, in apply
|
|
applied = getattr(b, f)(**kwargs)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\internals\blocks.py", line 1160, in replace_list
|
|
for i, ((src, dest), mask) in enumerate(zip(pairs, masks)):
|
|
~~~~~~~~~^^^^^^^^^^^^^^^^^^^
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\internals\blocks.py", line 1132, in <genexpr>
|
|
masks = (missing.mask_missing(values, s[0]) for s in pairs)
|
|
~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\missing.py", line 99, in mask_missing
|
|
na_mask = isna(values_to_mask)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\dtypes\missing.py", line 178, in isna
|
|
return _isna(obj)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\dtypes\missing.py", line 207, in _isna
|
|
return _isna_array(obj, inf_as_na=inf_as_na)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\dtypes\missing.py", line 288, in _isna_array
|
|
elif isinstance(values, np.rec.recarray):
|
|
^^^^^^
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\numpy\__init__.py", line 758, in __getattr__
|
|
import numpy.typing as typing
|
|
^^^^^^^^^^^^^^^^^^^^^^^
|
|
ModuleNotFoundError: No module named 'numpy.rec'
|
|
2026-01-06 16:04:19,673 - log_config.py - error_task_logger - ERROR - 任务执行失败: Can only use .dt accessor with datetimelike values
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\update_molecule_reporting_adjustment_to_bi.py", line 207, in main
|
|
df['归属月份'] = df['归属月份'].dt.tz_localize(None).dt.strftime('%Y-%m-%d %H:%M:%S')
|
|
^^^^^^^^^^^^^^^^^
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\generic.py", line 6321, in __getattr__
|
|
return object.__getattribute__(self, name)
|
|
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\accessor.py", line 224, in __get__
|
|
accessor_obj = self._accessor(obj)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\indexes\accessors.py", line 643, in __new__
|
|
raise AttributeError("Can only use .dt accessor with datetimelike values")
|
|
AttributeError: Can only use .dt accessor with datetimelike values. Did you mean: 'at'?
|
|
2026-01-06 16:14:24,812 - log_config.py - error_task_logger - ERROR - 写入数据时发生错误: overflow encountered in multiply
|
|
Traceback (most recent call last):
|
|
File "D:\Idea Project\SaaS_V1.7\back_ground_module\update_denominator_reporting_adjustment_to_bi.py", line 157, in write_to_bi
|
|
dt_utc = pd.to_datetime(timestamp_ms, unit='ms', utc=True)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\tools\datetimes.py", line 1072, in to_datetime
|
|
values = convert_listlike(arg._values, format)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\tools\datetimes.py", line 409, in _convert_listlike_datetimes
|
|
return _to_datetime_with_unit(arg, unit, name, utc, errors)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\pandas\core\tools\datetimes.py", line 517, in _to_datetime_with_unit
|
|
arr = cast_from_unit_vectorized(arg, unit=unit)
|
|
File "pandas/_libs/tslibs/conversion.pyx", line 149, in pandas._libs.tslibs.conversion.cast_from_unit_vectorized
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\numpy\_core\fromnumeric.py", line 3674, in round
|
|
return _wrapfunc(a, 'round', decimals=decimals, out=out)
|
|
File "D:\Program Files\anaconda3\envs\SaaS\Lib\site-packages\numpy\_core\fromnumeric.py", line 54, in _wrapfunc
|
|
return bound(*args, **kwds)
|
|
FloatingPointError: overflow encountered in multiply
|