HRESULT E_FAIL has been returned from a call to a COM component

HRESULT E_FAIL has been returned from a call to a COM component

Ever got this error message from Visual Studio? Well I’m using mine for BI projects and this helped for me:

Start —> Run —> regsvr32 %SystemRoot%\System32\msxml3.dll

Start —> Run —> regsvr32 %SystemRoot%\SysWOW64\msxml3.dll

If it doesn’t, maybe you’ll be able to find a solution here.








Advertisements

PowerPivot Memory error: Allocation failure

Did you receive this error message from PowerPivot?

Memory error: Allocation failure : Not enough storage is available to process this command. .
The operation has been cancelled.

PowerPivot-32bits-memory-error-allocation-failure-full

PowerPivot-32bits-memory-error-allocation-failure

Well…you’re probably using PowerPivot’s 32-bits version, more info: InstallPowerPivot.com

“The PowerPivot add-in runs as an extension of Excel and the PowerPivot Vertipaq in-memory engine loads within the same process space. As 32-bit Excel is limited to a 2GB virtual address space. Once you start adding up all of the uses of those virtual addresses, you will find that the largest PowerPivot workbook that you can create on a 32-bit machine is something like 500-700MB. Excel, all of the add-ins, the in-memory database itself and all of the rest just takes up lots and lots of space.” by Dave Wickert

Open Task Manager and locate Excel:

Excel-32bits-task-manager

In my case, it’s not causing any problems since I’m not near the 500 to 700 MB of memory usage.

What shall I do?
– Close all other PowerPivot workbooks which are active (if there are any)
– Reduce the imported datasets/tables by applying filters (in the Table Import Wizard)
– Close Excel (and all PowerPivot workbooks) to clear the memory and re-open that particular PowerPivot workbook
– Install the 64-bits version of PowerPivot (also requires a 64-bits version of Microsoft Excel), more info: InstallPowerPivot.com