ASR Deployment Planner - Hyper-v

Question

I am trying to run the ASRDeploymentPlanner.exe to compile a report.

I get the following:

HYPER-V TO AZURE ASR DEPLOYMENT PLANNER

Using existing price details from RateCard.xml..
Preparing deployment planner report...
Calculating total IOPS and data churn...
Consolidating virtual machine details...
Profiling data of VM sa-cem-01 not found.
Profiling data of VM sa-adc-03 not found.
Profiling data of VM sa-adc-03 not found.
Mapping virtual machines to storage account...
Assigning Azure VM role size for virtual machines...
Calculating required bandwidth for given RPO values...
Generating VM batching guideline for initial replication...
Generating excel report...
Failed to generate excel report.
Failed to generate deployment planner report. Exiting.

In the CapacityPlanner.txt i get the following:

07/19/2022 20:12:47:Excel generation threw exception: : Threw Exception.Type: System.InvalidCastException, Exception.Message: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Tried removing the following from registry type library: 000208D5-0000-0000-C000-000000000046

Uninstalled and reinstalled Office, still no joy.

Answer 1

Hi @Chris Thompson
if the 1.9 folder is in the key, try to delete it, just like:
\TypeLib{000208D5-0000-0000-C000-000000000046}\1.9\
After that, reboot and Try to run a full an Online Repair (not a Quick Repair)

*if you don't find the folder, run online repair the same way

Get in touch if you need more help with this issue.

--please don't forget to "Accept the answer" if the reply is helpful--