Excel crashes when searching for a HA

David_Biot

At one of our customers, every time we try to Search for a Hardware Asset, excel crashes.

I'm running the latest version of Asset Excell Addon, and the latest updates of Office 2016 (x86) are installed.
Showing organizations and other information works, but searching the Hardware Assets results in the loading message and after a few minutes it crashes.

Adam_Dzyacky

I experienced the identical issue and Cireson (well, @Tony_Collett) provided a more distilled Type Projection that could be leveraged with Asset Excel as the default one for Hardware Assets attemps to pull all relationships.

I'm not entirely thrilled about the result because to me, it makes me question if perhaps I have some unnecessary degree of relationship complexity in an environment that this program (Asset Excel) is perhaps indirectly exposing. To be absolutely clear, there is no hard evidence to support this observation of mine - just something I've been pondering over.

I have the unsealed MP which contains said TP, not sure if anyone at Cireson is opposed if I shared this.

Adam_Dzyacky

I experienced the identical issue and Cireson (well, @Tony_Collett) provided a more distilled Type Projection that could be leveraged with Asset Excel as the default one for Hardware Assets attemps to pull all relationships.

I'm not entirely thrilled about the result because to me, it makes me question if perhaps I have some unnecessary degree of relationship complexity in an environment that this program (Asset Excel) is perhaps indirectly exposing. To be absolutely clear, there is no hard evidence to support this observation of mine - just something I've been pondering over.

I have the unsealed MP which contains said TP, not sure if anyone at Cireson is opposed if I shared this.

David_Biot

Hey Adam. It would be great if you can share this MP.

Adam_Dzyacky

It probably goes without saying, change the extension from TXT to XML and then import. Then in the Asset Excel App before you go to query HW assets, head into the settings of Asset Excel and select this new type projection to be used.

damon_mulligan

@David_Biot
Did @Adam_Dzyacky answer/type projection work for you? If it did. please accept his answer above. If not, what issues are you still having?