microsoft
fails to create report
excel report fails to build
with a message "we couldn't complete the action for the pivot table "P2" in the sheet "overview" because there's already a table or XML map "azure tabs" there. Make space and try again.
second error also comes up "we couldn't complete the action for the pivot table "P0" in the sheet "overview" because there's already a table or XML map "azure tabs" there. Make space and try again.
Hello @Pieterle-Roux
Do you see any error during the script execution using the -Debug parameter?
Hi Claudio-Merola
this is what I get under the -debug
Get-Job : Cannot validate argument on parameter 'Name'. The argument is null, empty, or an element of the argument collection contains a null value. Supply a collection that does not contain any null values and then try the command again. At C:\Resource inventory script\ARI-main V3.1.7\AzureResourceInventory.ps1:1377 char:30
-
while (get-job -Name $JobNames | Where-Object { $_.State -eq ... -
~~~~~~~~~- CategoryInfo : InvalidData: (:) [Get-Job], ParameterBindingValidationException
- FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.PowerShell.Commands.GetJobCommand
@Pieterle-Roux
apparently the script is failing to extract the resources from your environment.
Do you have all the requirements installed? (i.e: resource-graph az cli extension)
Are you running the script in Windows Powershell or Powershell Core?
I have all the requirements installed and I am running it through windows PowerShell from my local machine
This document is protected by Altron - labelled as General Business Information
Pieter Le Roux Lead: Modern Platform Cloud Infrastructure
@.*** @.*** https://za05.rocketseed.com/rs/13qC0qnq
t +27 11 205 7000
m +27 83 233 5406
e @.@.>
w www.altronkarabina.comhttps://www.altronkarabina.com
@.*** @.*** @.*** View our disclaimer herehttps://za05.rocketseed.com/rs/13GQ2pvu | View our privacy policy herehttps://za05.rocketseed.com/rs/13InNfdf @.***https://za05.rocketseed.com/rs/13MMvRcc
This document is protected by Altron - labelled as General Business Information
From: Claudio Merola @.> Sent: Thursday, February 22, 2024 7:15 PM To: microsoft/ARI @.> Cc: Pieter Le Roux @.>; Mention @.> Subject: Re: [microsoft/ARI] fails to create report (Issue #168)
You don't often get email from @.*** Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification
@Pieterle-Rouxhttps://github.com/Pieterle-Roux
apparently the script is failing to extract the resources from your environment.
Do you have all the requirements installed? (i.e: resource-graph az cli extension)
Are you running the script in Windows Powershell or Powershell Core?
Reply to this email directly, view it on GitHubhttps://github.com/microsoft/ARI/issues/168#issuecomment-1959901191, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGKLYCSTMY5UN7DNDJERSVDYU54HXAVCNFSM6AAAAABDTAMFPWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJZHEYDCMJZGE. You are receiving this because you were mentioned.Message ID: @.***>
then it gets to building the report and hangs on 50% progress and eventually becomes unresponsive
@Pieterle-Roux
Would you be able to to run the script on Powershell Core?
seems to run under powershell core but only if I add the switch -SkipSecurityCenter as soon as I include -securitycenter it reaches 50% and then hangs again
DEBUG: Checking If Should Run Security Center Job. DEBUG: Starting Security Job. DEBUG: Checking If Should Run Policy Job. DEBUG: Starting Policy Processing Job. DEBUG: Checking If Should Run Advisory Job. DEBUG: Starting Advisory Processing Job. DEBUG: Starting Subscriptions job. DEBUG: Starting Processing Jobs in Regular Mode. DEBUG: Starting Jobs Collector. Get-Job : Cannot validate argument on parameter 'Name'. The argument is null, empty, or an element of the argument collection contains a null value. Supply a collection that does not contain any null values and then try the command again. At C:\Resource inventory script\ARI-main V3.1.7\AzureResourceInventory.ps1:1377 char:30 + while (get-job -Name $JobNames | Where-Object { $_.State -eq ... + ~~~~~~~~~ + CategoryInfo : InvalidData: (:) [Get-Job], ParameterBindingValidationException + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.PowerShell.Commands.GetJobCommand
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
Sorry for the late response Claudio
The issue was caused by a recent upgrade to Windows 11 and Group Policies that made changes to my firewall settings, as soon as I disabled the firewall (temporarily) the script completed successfully
Pieter Le Roux Lead: Cloud Altron Digital Business [altron.com digital business website]https://altron.com/digital-business w: altron.com/digital-businesshttps://altron.com/digital-business%20
This document is protected by Altron - labelled as General Business Information From: Claudio Merola @.> Sent: Monday, February 26, 2024 9:49 PM To: microsoft/ARI @.> Cc: Pieter Le Roux @.>; Mention @.> Subject: Re: [microsoft/ARI] fails to create report (Issue #168)
You don't often get email from @.*** Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification
@Pieterle-Rouxhttps://github.com/Pieterle-Roux
Would you be able to to run the script on Powershell Core?
Reply to this email directly, view it on GitHubhttps://github.com/microsoft/ARI/issues/168#issuecomment-1965131883, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGKLYCWDZXAP5NR5JOONDZDYVTRLNAVCNFSM6AAAAABDTAMFPWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRVGEZTCOBYGM. You are receiving this because you were mentioned.Message ID: @.***>