Error Merging node and machine data...

[hughbrien]

I did a git pull, so I should have the latest code:

I got hte following error :

Retrieving backends for NA_US_CCS_50627...

Retrieving servers...

all_snapshots_df is empty, skipping merge...

Merging node and machine data...

KeyError: "['AppDynamics|Agent|Agent Pid', 'Physical_type', 'Swap_type'] not found in axis" Traceback: File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/exec_code.py", line 85, in exec_func_with_error_handling result = func() ^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 576, in code_to_exec exec(code, module.dict) File "/Users/hbrien/Software/AppDynamics-Data-Extractor/appd-extractor.py", line 999, in all_nodes_merged_df.drop(columns=['agentConfig', 'AppDynamics|Agent|JVM Info', 'AppDynamics|Agent|Agent Pid', 'AppDynamics|Agent|Agent version', 'AppDynamics|Agent|Build Number', 'AppDynamics|Agent|Install Directory', 'AppDynamics|Agent|Machine Info', 'controllerConfig', 'cpus', 'ipAddresses', 'networkInterfaces', 'Physical_type', 'Swap_type', 'volumes'], inplace=True) File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/frame.py", line 5581, in drop return super().drop( ^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/generic.py", line 4788, in drop obj = obj._drop_axis(labels, axis, level=level, errors=errors) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/generic.py", line 4830, in _drop_axis new_axis = axis.drop(labels, errors=errors) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/indexes/base.py", line 7070, in drop raise KeyError(f"{labels[mask].tolist()} not found in axis")

[hughbrien]

[hughbrien]

I also tried it on a Single Application and got a "different" error :

KeyError: "['AppDynamics|Agent|JVM Info', 'AppDynamics|Agent|Agent Pid', 'AppDynamics|Agent|Agent version', 'AppDynamics|Agent|Build Number', 'AppDynamics|Agent|Install Directory', 'AppDynamics|Agent|Machine Info', 'Physical_type', 'Swap_type'] not found in axis" Traceback: File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/exec_code.py", line 85, in exec_func_with_error_handling result = func() ^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 576, in code_to_exec exec(code, module.dict) File "/Users/hbrien/Software/AppDynamics-Data-Extractor/appd-extractor.py", line 999, in all_nodes_merged_df.drop(columns=['agentConfig', 'AppDynamics|Agent|JVM Info', 'AppDynamics|Agent|Agent Pid', 'AppDynamics|Agent|Agent version', 'AppDynamics|Agent|Build Number', 'AppDynamics|Agent|Install Directory', 'AppDynamics|Agent|Machine Info', 'controllerConfig', 'cpus', 'ipAddresses', 'networkInterfaces', 'Physical_type', 'Swap_type', 'volumes'], inplace=True) File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/frame.py", line 5581, in drop return super().drop( ^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/generic.py", line 4788, in drop obj = obj._drop_axis(labels, axis, level=level, errors=errors) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/generic.py", line 4830, in _drop_axis new_axis = axis.drop(labels, errors=errors) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/hbrien/Software/AppDynamics-Data-Extractor/venv/lib/python3.12/site-packages/pandas/core/indexes/base.py", line 7070, in drop raise KeyError(f"{labels[mask].tolist()} not found in axis")

[hughbrien]

[robertvandervoort]

this was changed a while back. ensure you've got the latest code.