I’ve worked with Smartview and the Essbase add-in since the beginning of time. Literally. Remember when you had to rebot after every single install or uninstall? Good times.
I’ve been working with OAC (for those that are newbies to the Oracle world, OAC stands for Oracle Analytics Cloud) and Excel 2013. I was having some issues and realized I needed to download the latest version of SV (220.127.116.11.720). I THOUGHT I downloaded it correct. It SAID I was using version 18.104.22.168.720. My issues did not resolve, so I reached out to Oracle support. They asked that I uninstall and then restinall SV.
OK! No Problem. I do this in my sleep!
Not this time. That sucker would not uinstall. It would get stuck at the 30% marker, and not budge. I reached out to our very smart team of infrastructure consultants. Did you know that there is another Schwartzberg out there in the world? That’s right, Ross Schwartzberg, who just happens to be the brother of Glenn (I KNOW you know Glenn).
Ross and I literally spent HOURS on my computer. We tried to find the files it was looking for, googled, researched and got really frustrated. Finally, I said, “Hey, what if we delete the registry”.
Oh I know..that is a huge NO NO. Don’t touch the registry. I get it. But dadugm, I am just not myself without a Smartview install on my machine. It’s like bread a butter. If you’re an EPM consultant, you HAVE to have Smartview.
So, here’s what we did:
Navigated to HKEY_CURRENT_USER\Software\Hyperion Solutions\HyperionSmartView (proof that ‘Hyperion’ is truly not dead).
Took a backup of HyperionSmartView, and then deleted HyperionSmartView. I did say “are we sure about this” about 100 times. Again, you don’t mess with the registry!
Then, I navigated to the path where SV gets installed and renamed the current SmartView folder to SmartView_old.
After that, I was able to unistall it from Control Panel (where you’re normally supposed to do it), and remove the SV instances.
I then reinstalled 22.214.171.1240 with no issues, and all of my OAC issues were gone!
So, moral of the story, blow it away in the registry if all else fails.