search

AsBuiltReport / AsBuiltReport.VMware.vSphere

Repository for AsBuiltReport VMware vSphere module
https://www.asbuiltreport.com
MIT License
113 stars 39 forks source link

Investigate issues with reporting on ESXi Host Datastore Specifications #17

Closed tpcarman closed 5 years ago

tpcarman commented 5 years ago

Report generation crashed with the following error when attempting to collect ESXi Host Datastore Specifications.

Cannot bind argument to parameter 'Rows' because it is an empty collection.

Issue appears to be a missing if statement when collecting ESXi host datastore information. Currently code assumes all ESXi hosts will have a datastore. In this particular case, the report crashes when it tries to retrieve information from a vSAN witness.

To Reproduce Steps to reproduce the behavior:

  1. Attempt to generate a vSphere report where an ESXi host does not have any datastores configured.

Expected behavior If a host does not have any datastores, the script should bypass collection

Desktop (please complete the following information):

tpcarman commented 5 years ago

Resolved in https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/commit/f2d92ca468d781bc9464e0446fa9f4ead9973212

tpcarman commented 5 years ago

Hi @akvirtualgeek, Are you able to provide more information with regards to datastore 'M2-VDP-MGMT'? What size is the datastore? Is it in maintenance mode or have any unique specifications? Thanks, Tim

On Tue, 7 May 2019 at 04:37, akvirtualgeek notifications@github.com wrote:

I'm still seeing this as an issue... I used the new Invoke-AsBuiltReport.VMware.vSphere.ps1 file.... below is what I got.

VERBOSE: [ 10:13:12:420 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:12:424 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' started. VERBOSE: [ 10:13:17:267 ] [ Document ] - Processing table 'M2-DSC00-MGMT02 vSAN Configuration'. VERBOSE: [ 10:13:17:294 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' completed. VERBOSE: [ 10:13:17:298 ] [ Document ] - Processing section 'vSAN' completed. VERBOSE: [ 10:13:17:348 ] [ Document ] - Processing section 'Datastores' started. VERBOSE: [ 10:13:17:352 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:354 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:417 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:434 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:436 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:490 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:494 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:496 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:531 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:537 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:539 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:624 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:629 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:630 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:680 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:685 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:686 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' started. VERBOSE: [ 10:13:17:741 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:746 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' completed. VERBOSE: [ 10:13:17:748 ] [ Document ] - Processing section 'Datastores' completed. VERBOSE: [ 10:13:17:810 ] [ Document ] - Processing section 'Datastore Clusters' started. VERBOSE: [ 10:13:17:814 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:818 ] [ Document ] - Processing section 'M2-VDP-MGMT' started. VERBOSE: [ 10:13:17:825 ] [ Document ] - Processing paragraph 'The following table details the conf[..]'. VERBOSE: [ 10:13:17:828 ] [ Document ] - Processing blank line. New-AsBuiltReport : Attempted to divide by zero. At line:1 char:1

  • New-AsBuiltReport -Report VMware.vSphere -Target m2-mgmt-vc01.gci.com ...
    • CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    • FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,New-AsBuiltReport

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489728283, or mute the thread https://github.com/notifications/unsubscribe-auth/ADU7SIZX6XS5QBHU4AUH7C3PUB3HPANCNFSM4HASVOZQ .

tpcarman commented 5 years ago

Reopening issue to investigate Divide by zero errors

akvirtualgeek commented 5 years ago

Sorry I deleted the comment online soon after I made it.

M2-VDP-MGMT It turns out was an empty data store cluster... once I deleted it, the script completed successfully. This is probably a usecase that wasn’t expected.

Jeremy Mayfield

On Mon, May 6, 2019 at 5:41 PM Tim Carman notifications@github.com wrote:

Hi akvirtualgeek, Are you able to provide more information with regards to datastore ' M2-VDP-MGMT'? What size is the datastore? Is it in maintenance mode or have any unique specifications? Thanks, Tim

On Tue, 7 May 2019 at 04:37, akvirtualgeek notifications@github.com wrote:

I'm still seeing this as an issue... I used the new Invoke-AsBuiltReport.VMware.vSphere.ps1 file.... below is what I got.

VERBOSE: [ 10:13:12:420 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:12:424 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' started. VERBOSE: [ 10:13:17:267 ] [ Document ] - Processing table 'M2-DSC00-MGMT02 vSAN Configuration'. VERBOSE: [ 10:13:17:294 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' completed. VERBOSE: [ 10:13:17:298 ] [ Document ] - Processing section 'vSAN' completed. VERBOSE: [ 10:13:17:348 ] [ Document ] - Processing section 'Datastores' started. VERBOSE: [ 10:13:17:352 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:354 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:417 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:434 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:436 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:490 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:494 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:496 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:531 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:537 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:539 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:624 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:629 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:630 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:680 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:685 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:686 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' started. VERBOSE: [ 10:13:17:741 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:746 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' completed. VERBOSE: [ 10:13:17:748 ] [ Document ] - Processing section 'Datastores' completed. VERBOSE: [ 10:13:17:810 ] [ Document ] - Processing section 'Datastore Clusters' started. VERBOSE: [ 10:13:17:814 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:818 ] [ Document ] - Processing section 'M2-VDP-MGMT' started. VERBOSE: [ 10:13:17:825 ] [ Document ] - Processing paragraph 'The following table details the conf[..]'. VERBOSE: [ 10:13:17:828 ] [ Document ] - Processing blank line. New-AsBuiltReport : Attempted to divide by zero. At line:1 char:1

  • New-AsBuiltReport -Report VMware.vSphere -Target m2-mgmt-vc01.gci.com ...

  • CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException

  • FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,New-AsBuiltReport

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub < https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489728283 , or mute the thread < https://github.com/notifications/unsubscribe-auth/ADU7SIZX6XS5QBHU4AUH7C3PUB3HPANCNFSM4HASVOZQ

.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489873321, or mute the thread https://github.com/notifications/unsubscribe-auth/AMABS3VJJTUGXAEBE6ESRCTPUDM3NANCNFSM4HASVOZQ .

tpcarman commented 5 years ago

Hi Jeremy,

I have just tested this in my homelab and it appears you have discovered a bug. I will raise an issue for this.

Thanks for letting me know.

Cheers, Tim.

On Tue, 7 May 2019 at 13:24, akvirtualgeek notifications@github.com wrote:

Sorry I deleted the comment online soon after I made it.

M2-VDP-MGMT It turns out was an empty data store cluster... once I deleted it, the script completed successfully. This is probably a usecase that wasn’t expected.

Jeremy Mayfield

On Mon, May 6, 2019 at 5:41 PM Tim Carman notifications@github.com wrote:

Hi akvirtualgeek, Are you able to provide more information with regards to datastore ' M2-VDP-MGMT'? What size is the datastore? Is it in maintenance mode or have any unique specifications? Thanks, Tim

On Tue, 7 May 2019 at 04:37, akvirtualgeek notifications@github.com wrote:

I'm still seeing this as an issue... I used the new Invoke-AsBuiltReport.VMware.vSphere.ps1 file.... below is what I got.

VERBOSE: [ 10:13:12:420 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:12:424 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' started. VERBOSE: [ 10:13:17:267 ] [ Document ] - Processing table 'M2-DSC00-MGMT02 vSAN Configuration'. VERBOSE: [ 10:13:17:294 ] [ Document ] - Processing section 'M2-DSC00-MGMT02' completed. VERBOSE: [ 10:13:17:298 ] [ Document ] - Processing section 'vSAN' completed. VERBOSE: [ 10:13:17:348 ] [ Document ] - Processing section 'Datastores' started. VERBOSE: [ 10:13:17:352 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:354 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:417 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:434 ] [ Document ] - Processing section 'DE300180101439-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:436 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:490 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:494 ] [ Document ] - Processing section 'DE300180101440-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:496 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:531 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:537 ] [ Document ] - Processing section 'DE300180101441-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:539 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:624 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:629 ] [ Document ] - Processing section 'DE300180101442-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:630 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' started. VERBOSE: [ 10:13:17:680 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:685 ] [ Document ] - Processing section 'DE300180101444-01-01-service-datastore1' completed. VERBOSE: [ 10:13:17:686 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' started. VERBOSE: [ 10:13:17:741 ] [ Document ] - Processing table 'Datastore Specifications'. VERBOSE: [ 10:13:17:746 ] [ Document ] - Processing section 'VxRail-Virtual-SAN-Datastore-MGMT' completed. VERBOSE: [ 10:13:17:748 ] [ Document ] - Processing section 'Datastores' completed. VERBOSE: [ 10:13:17:810 ] [ Document ] - Processing section 'Datastore Clusters' started. VERBOSE: [ 10:13:17:814 ] [ Document ] - Processing paragraph 'The following section provides infor[..]'. VERBOSE: [ 10:13:17:818 ] [ Document ] - Processing section 'M2-VDP-MGMT' started. VERBOSE: [ 10:13:17:825 ] [ Document ] - Processing paragraph 'The following table details the conf[..]'. VERBOSE: [ 10:13:17:828 ] [ Document ] - Processing blank line. New-AsBuiltReport : Attempted to divide by zero. At line:1 char:1

  • New-AsBuiltReport -Report VMware.vSphere -Target m2-mgmt-vc01.gci.com ...

  • CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException

  • FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,New-AsBuiltReport

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <

https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489728283

, or mute the thread <

https://github.com/notifications/unsubscribe-auth/ADU7SIZX6XS5QBHU4AUH7C3PUB3HPANCNFSM4HASVOZQ

.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub < https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489873321 , or mute the thread < https://github.com/notifications/unsubscribe-auth/AMABS3VJJTUGXAEBE6ESRCTPUDM3NANCNFSM4HASVOZQ

.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/AsBuiltReport/AsBuiltReport.VMware.vSphere/issues/17#issuecomment-489892828, or mute the thread https://github.com/notifications/unsubscribe-auth/ADU7SI2Y73QPUV5C4AGVOQTPUDY45ANCNFSM4HASVOZQ .

tpcarman commented 5 years ago

Issue #35 opened to address the issue with the datastore cluster.