2020-12-10 20:33:11 Thu root ERROR IFA: 蒋亮, 客户: 曹建晓的基金月报生成异常,错误追踪:None 2020-12-10 20:39:34 Thu root ERROR IFA: 蒋亮, 客户: 曹建晓的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 32, in __init__ self.get_group_result() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 50, in get_group_result portfolio_diagnose = self.get_portfolio_diagnose(group_result["fund_id_list"], invest_amount=group_result["total_cost"]) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 84, in get_portfolio_diagnose portfolio_diagnose.optimize() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/portfolio_diagnose.py", line 558, in optimize self.abandoned_portfolio = self.abandon(self.origin_portfolio) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/portfolio_diagnose.py", line 466, in abandon z_score = search_rank(fund_rank, fund, metric='z_score') File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/portfolio_diagnose.py", line 76, in search_rank return fund_rank[fund_rank['fund_id'] == fund][metric].values[0] IndexError: index 0 is out of bounds for axis 0 with size 0 2020-12-10 20:39:36 Thu root ERROR IFA: 王斐, 客户: 王平的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006GNQ' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006GNQ' 2020-12-10 20:39:39 Thu root ERROR IFA: Linda, 客户: 王俊贤的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00005AFK' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00005AFK' 2020-12-10 20:39:43 Thu root ERROR IFA: Linda, 客户: 莫映辉的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:39:46 Thu root ERROR IFA: 陈居平, 客户: LIANG QIANG的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00005AFK' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00005AFK' 2020-12-10 20:39:48 Thu root ERROR IFA: Linda, 客户: 钟毅(赵嘉)的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:39:50 Thu root ERROR IFA: Linda, 客户: 许磊的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:39:52 Thu root ERROR IFA: Linda, 客户: 刘亚光的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:39:55 Thu root ERROR IFA: Linda, 客户: 马达的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:00 Thu root ERROR IFA: Linda, 客户: MOUHUILING的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:01 Thu root ERROR IFA: 罗正清, 客户: 陈鹤一的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 26, in __init__ self.df = self.user_customer.calculate_total_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 202, in calculate_total_data return_ratio_df, month_return_ratio_df, contribution_decomposition = self.combination_yield(resample_cur_folio_result_cnav_data, fund_id_list) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 420, in combination_yield amount_ratio_shift.iloc[num_va] = amount_ratio_shift.values[num_va+1] IndexError: index 9 is out of bounds for axis 0 with size 9 2020-12-10 20:40:04 Thu root ERROR IFA: 张晶, 客户: 张乃民的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:06 Thu root ERROR IFA: 陈居平, 客户: XIE PING PETER的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:07 Thu root ERROR IFA: 陈居平, 客户: 刘素美的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF0000681Q' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF0000681Q' 2020-12-10 20:40:09 Thu root ERROR IFA: 陈哲, 客户: 朱红的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF0000681Q' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF0000681Q' 2020-12-10 20:40:11 Thu root ERROR IFA: 高扬, 客户: 高扬的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:13 Thu root ERROR IFA: 高扬, 客户: 于振亭的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:17 Thu root ERROR IFA: 宋宜曲, 客户: 马崧元的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006AZF' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006AZF' 2020-12-10 20:40:21 Thu root ERROR IFA: 佟学智, 客户: 史亦农的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:25 Thu root ERROR IFA: 佟学智, 客户: 曲杰的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:27 Thu root ERROR IFA: 王艳松, 客户: 王凤辉的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 369, in group_fund_basic_info_data fund_hoding_info = {"fund_strategy_name": dict_substrategy[int(row["substrategy"])], "fund_name": row["fund_name"]} ValueError: cannot convert float NaN to integer 2020-12-10 20:40:28 Thu root ERROR IFA: 殷红星, 客户: 魏小燕的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:34 Thu root ERROR IFA: 殷红星, 客户: 薛珍珍的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:35 Thu root ERROR IFA: 殷红星, 客户: 何淑珍的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:36 Thu root ERROR IFA: 殷红星, 客户: 张玉仙的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:37 Thu root ERROR IFA: 杨旻, 客户: 程静的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:39 Thu root ERROR IFA: 张岱琦, 客户: 曾壮强的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:40 Thu root ERROR IFA: 郭闽深, 客户: 童翔英的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:40:41 Thu root ERROR IFA: 田晶晶, 客户: 王平生的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:46 Thu root ERROR IFA: 张文乐, 客户: 张建国的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:47 Thu root ERROR IFA: 宋玉杰, 客户: 曹百英的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:48 Thu root ERROR IFA: 娄宇恒, 客户: 贺雅琳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:50 Thu root ERROR IFA: 陈雅娟, 客户: 盛关炎的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:51 Thu root ERROR IFA: 吴超, 客户: 吴超的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:52 Thu root ERROR IFA: 苏晓瑜, 客户: 何小芳&陈贤杰的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF0000681Q' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF0000681Q' 2020-12-10 20:40:54 Thu root ERROR IFA: 刘文辉, 客户: 曲颜如的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:40:55 Thu root ERROR IFA: 万鹏, 客户: 陈勇的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:41:00 Thu root ERROR IFA: 俞琳莉 , 客户: 贝颂华的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:41:01 Thu root ERROR IFA: 吴影仪, 客户: 胡子恒的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:03 Thu root ERROR IFA: 欧子临, 客户: 吴志丹的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:08 Thu root ERROR IFA: 李欣, 客户: 袁明宇的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:09 Thu root ERROR IFA: 蒋亮, 客户: 杨琳琳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:14 Thu root ERROR IFA: 商凌宇, 客户: 华芳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:18 Thu root ERROR IFA: 邓涛, 客户: 邓光明的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:21 Thu root ERROR IFA: 于洁, 客户: 李伟弘的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 369, in group_fund_basic_info_data fund_hoding_info = {"fund_strategy_name": dict_substrategy[int(row["substrategy"])], "fund_name": row["fund_name"]} ValueError: cannot convert float NaN to integer 2020-12-10 20:41:24 Thu root ERROR IFA: 汤鲁欣, 客户: 贺孝琴的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:25 Thu root ERROR IFA: Linda, 客户: 鲍家丰的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:27 Thu root ERROR IFA: Linda, 客户: 牟智松的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00006693' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00006693' 2020-12-10 20:41:32 Thu root ERROR IFA: 高扬, 客户: 周妮的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:36 Thu root ERROR IFA: 高扬, 客户: 贺雨丰的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:39 Thu root ERROR IFA: 佟学智, 客户: 郭丽的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:40 Thu root ERROR IFA: 佟学智, 客户: 徐淑华的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:44 Thu root ERROR IFA: 佟学智, 客户: 沈阳凯迈化工进出口有限公司的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:46 Thu root ERROR IFA: 佟学智, 客户: 张媛的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:50 Thu root ERROR IFA: 杨旻, 客户: 熊琳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:54 Thu root ERROR IFA: 苏晓瑜, 客户: 林艺娟的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:56 Thu root ERROR IFA: 王斐, 客户: 金炜的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:58 Thu root ERROR IFA: 王斐, 客户: 莫慧达的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:41:59 Thu root ERROR IFA: 吴影仪, 客户: 吴影仪的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:00 Thu root ERROR IFA: 蒋亮, 客户: 杨亭的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:02 Thu root ERROR IFA: 商凌宇, 客户: 王宏柏的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:05 Thu root ERROR IFA: 商凌宇, 客户: 谢刚的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:09 Thu root ERROR IFA: 庄金刚, 客户: 平春梅的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:10 Thu root ERROR IFA: 王月琴, 客户: 孙鼎文的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:11 Thu root ERROR IFA: 徐伟, 客户: 夏燕芳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:12 Thu root ERROR IFA: 徐伟, 客户: 杜雪明的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:16 Thu root ERROR IFA: 李军, 客户: 李军的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:20 Thu root ERROR IFA: 陈晓燕, 客户: 常州汇德通信技术有限公司的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:21 Thu root ERROR IFA: 陈晓燕, 客户: 谢韵的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:24 Thu root ERROR IFA: 张嘉, 客户: 赵晨淋的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:25 Thu root ERROR IFA: 佟学智, 客户: 佟广财的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:26 Thu root ERROR IFA: 佟学智, 客户: 奔飞的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:28 Thu root ERROR IFA: 佟学智, 客户: 张春波的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:30 Thu root ERROR IFA: 张文乐, 客户: 蔡源的基金月报生成异常,错误追踪:Traceback (most recent call last): File "pandas/_libs/index.pyx", line 444, in pandas._libs.index.DatetimeEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 1592611200000000000 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 413, in pandas._libs.index.DatetimeEngine.get_loc File "pandas/_libs/index.pyx", line 446, in pandas._libs.index.DatetimeEngine.get_loc KeyError: Timestamp('2020-06-20 00:00:00') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/datetimes.py", line 625, in get_loc return Index.get_loc(self, key, method, tolerance) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: Timestamp('2020-06-20 00:00:00') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 46, in __init__ self.total_customer_order_cnav_df = self.total_combine_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 278, in total_combine_data if pd.isnull(p_nav_df.loc[confirm_share_date, cur_fund_id]): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/generic.py", line 3491, in xs loc = self.index.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/datetimes.py", line 627, in get_loc raise KeyError(orig_key) from err KeyError: Timestamp('2020-06-20 00:00:00') 2020-12-10 20:42:31 Thu root ERROR IFA: 娄宇恒, 客户: 王中举的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:35 Thu root ERROR IFA: 蒋亮, 客户: 于正之的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:37 Thu root ERROR IFA: 蒋亮, 客户: 侯怡莉的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:39 Thu root ERROR IFA: 蒋亮, 客户: 刘西玲的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:43 Thu root ERROR IFA: 杨恺, 客户: 杨恺的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2895, in get_loc return self._engine.get_loc(casted_key) File "pandas/_libs/index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/hashtable_class_helper.pxi", line 1675, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas/_libs/hashtable_class_helper.pxi", line 1683, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'HF00002JJ2' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 28, in __init__ self.d = self.user_customer.calculate_group_result_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 152, in calculate_group_result_data result_fund_nav_info, result_fund_hoding_info = self.group_fund_basic_info_data(cur_folio_order_data, cur_folio_result_cnav_data, cumulative_profit, total_cost) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 344, in group_fund_basic_info_data fund_basic_info["cur_nav"] = round(float(self.fund_nav_total[cur_fund_id].dropna().values[-1]), 4) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 2902, in __getitem__ indexer = self.columns.get_loc(key) File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2897, in get_loc raise KeyError(key) from err KeyError: 'HF00002JJ2' 2020-12-10 20:42:43 Thu root ERROR IFA: 佟学智, 客户: 李恒祉的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:43 Thu root ERROR IFA: 佟学智, 客户: 杨海燕的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:44 Thu root ERROR IFA: 王斐, 客户: 高雅娟的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:44 Thu root ERROR IFA: 蒋亮, 客户: 杨扬的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:45 Thu root ERROR IFA: 蒋亮, 客户: 赵振东的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:45 Thu root ERROR IFA: 蒋亮, 客户: 刘晔的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:46 Thu root ERROR IFA: 蒋亮, 客户: 孙琳琳的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:46 Thu root ERROR IFA: 商凌宇, 客户: 曲伟浩的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:46 Thu root ERROR IFA: 杨恺, 客户: 谢申生的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:47 Thu root ERROR IFA: 王燎原, 客户: 吕伟丽的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:49 Thu root ERROR IFA: 赵淑慧, 客户: 梁建的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0 2020-12-10 20:42:49 Thu root ERROR IFA: 宋卓, 客户: 朱瑛的基金月报生成异常,错误追踪:Traceback (most recent call last): File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/timed_task.py", line 64, in call_month_report DataIntegrate(ifauser_id, customer_id, '{}_{}_.pdf'.format(ifauser_name, customer_name)) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/utils/jinjia2html_v2.py", line 22, in __init__ self.user_customer = UserCustomerResultAdaptor(ifa_id, customer_id) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/result_service_v2.py", line 22, in __init__ super().__init__(user_id, customer_id, end_date) File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 44, in __init__ self.fund_nav_total, self.fund_cnav_total = self.get_customer_fund_nav_data() File "/Users/pengxiong/Desktop/tamp_workspace/fund_report/app/service/data_service.py", line 137, in get_customer_fund_nav_data self.last_nav_date = str(all_fund_cnav.dropna(how="all").index.values[-1])[:10] IndexError: index -1 is out of bounds for axis 0 with size 0