Hello,
I'm encountering the following error with Excel Report (version 20231219.1 / ArcGIS Monitor 2023.3):
***
2024-01-17 11:45:38.530739 service,Instances Saturation Percent,svcInstSat
2024-01-17 11:45:42.904467 100 of 611
2024-01-17 11:45:45.149826 200 of 611
2024-01-17 11:45:47.359358 300 of 611
2024-01-17 11:45:49.594722 400 of 611
2024-01-17 11:45:51.809831 500 of 611
2024-01-17 11:45:54.050438 600 of 611
2024-01-17 11:45:56.168793 611 of 611
2024-01-17 11:46:00.863627 ignoring duplicate metric Instances Saturation Percent
2024-01-17 11:46:05.113542 100 of 611
2024-01-17 11:46:07.291487 200 of 611
2024-01-17 11:46:09.495792 300 of 611
2024-01-17 11:46:11.674840 400 of 611
2024-01-17 11:46:13.845674 500 of 611
2024-01-17 11:46:16.040122 600 of 611
2024-01-17 11:46:18.112665 611 of 611
Sheetname 'svcInstSat', with case ignored, is already in use.
Traceback (most recent call last):
File "ExcelReport.py", line 14, in main
File "modules\report_builder.py", line 24, in __init__
File "modules\Wkb\wkb_builder.py", line 67, in __init__
File "modules\Wkb\wkb_builder.py", line 164, in _add_wks_stats
File "modules\Xlswriter\xls_wks.py", line 7, in __init__
File "xlsxwriter\workbook.py", line 189, in add_worksheet
File "xlsxwriter\workbook.py", line 759, in _add_sheet
File "xlsxwriter\workbook.py", line 829, in _check_sheetname
xlsxwriter.exceptions.DuplicateWorksheetName: Sheetname 'svcInstSat', with case ignored, is already in use.
None
Traceback (most recent call last):
File "ExcelReport.py", line 14, in main
File "modules\report_builder.py", line 24, in __init__
File "modules\Wkb\wkb_builder.py", line 67, in __init__
File "modules\Wkb\wkb_builder.py", line 164, in _add_wks_stats
File "modules\Xlswriter\xls_wks.py", line 7, in __init__
File "xlsxwriter\workbook.py", line 189, in add_worksheet
File "xlsxwriter\workbook.py", line 759, in _add_sheet
File "xlsxwriter\workbook.py", line 829, in _check_sheetname
xlsxwriter.exceptions.DuplicateWorksheetName: Sheetname 'svcInstSat', with case ignored, is already in use.
***
For about the past week, since upgrading from 2023.2 to 2023.3, I was getting this error while still using version 20230825.1, in case it's useful in any way:
***
01/09/2024 04:00:26 AM INFO: host,CPU Cores Utilized,hostCPUCoresUtil
01/09/2024 04:00:33 AM INFO: host,CPU Utilized,hostCPUUtil
01/09/2024 04:00:40 AM INFO: host,Connectivity host windows_discover,hostConnectivityhostwind
01/09/2024 04:00:47 AM INFO: host,Connectivity host windows_metrics,hostConnectivityhostwind
01/09/2024 04:00:49 AM ERROR: Sheetname 'hostConnectivityhostwind', with case ignored, is already in use.
01/09/2024 04:00:49 AM ERROR: None
Traceback (most recent call last):
File "ExcelReport.py", line 14, in main
File "modules\report_builder.py", line 24, in __init__
File "modules\Wkb\wkb_builder.py", line 42, in __init__
File "modules\Wkb\wkb_builder.py", line 116, in _add_wks_stats
File "modules\Xlswriter\xls_wks.py", line 7, in __init__
File "xlsxwriter\workbook.py", line 189, in add_worksheet
File "xlsxwriter\workbook.py", line 759, in _add_sheet
File "xlsxwriter\workbook.py", line 829, in _check_sheetname
xlsxwriter.exceptions.DuplicateWorksheetName: Sheetname 'hostConnectivityhostwind', with case ignored, is already in use.
***
Thanks for any help you can provide.
Chris
