Error message: EBM login dialog window stops halfway and never fully loads.
Initial Login Window Halts Halfway
Description: When opening a Cube file (e.g. EBMOfficeBridge.xlsm) the initial login window progress bar stops halfway and will never complete. Indicative of an Internet Explorer event, which loops because of security issues on the client side or because the local machine being used is attempting to open a 32-bit iexplore.exe process instead of a 64-bit iexplore.exe process.
Note: To confirm the issue:
- While in the Excel cube file hit Alt + F8 to bring up the MVBA interface. Click Edit and then Pause or Stop to see dialog window code progress, as seen above.
- Additionally, to further validate the problem, the client IT department can look in the event logs under Security to see the events for process creation (e.g., event ID 4688).
- From there, compare with a working machine. Confirm by looking at the command line column in task manager that the working machine was opening both iexplore.exe processes from C:\Program Files\, whereas the non-working machine would open the first iexplore.exe process from C:\Program Files\, and then the second process would be spawned by the first but would open from C:\Program Files (x86)\. Unsure why this happens, but that’s how it’s confirmed.
Solution: Add a registry key to force the machine to use 64-bit IE. Internal IT dept on the client-side will need to force IE to always open in 64-bit mode. This can be done through a registry key data entry as follows:
- KEY: HKLM\SOFTWARE\Microsoft\Internet Explorer\Main
- TYPE: DWORD
- NAME: TabProcGrowth
- VALUE: 0