Page 1 of 1

Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Posted: Fri Aug 03, 2018 10:47 pm
by Alan Kirk
I haven't submitted this at this point because I need to check whether this is just a "my machine" thing or something that applies to everyone.

Environment: Windows 10 professional 64 bit.
TM1 10.2.2 FP 7
Excel 2016 (64 bit) from Office 365. Note particularly the "64 bit" part which is where I suspect this issue is coming from.

If I select "Dimension Open" in Perspectives to update an .xdi, then:
(a) If the data directory specified is empty, then an empty list will be shown as expected; but
(b) If the data directory has even a single file (.xdi) in it, Excel will generate an "Automation Error" warning, then crash.

If the data directory is empty I can create a new dimension and save it correctly. (Although Excel will shove the ever-accursed "Book1" in my face after it creates the new .xdi and I have to manually change to the new .xdi file.) However once the file is saved, I can't re-open it through Dimension Open because... Automation Error, crash.

(Workaround: It can be opened as a regular file, updated and saved as a dimension without any major problem. other than the irritating Extension Hardening warning which of course I immediately turned off.)

I'm not encountering this with PA2 (the bits that actually work, that is; Perspectives and Web but not PAX because, well, Docker), but in the PA2 test environment (on a different machine) I'm using Excel 2016 (Office 365) 32 bit.

It could therefore be specific to my machine or, what I think is more likely, there's an issue with the VBA code that reads the list of files in the data directory when it's run by 64 bit Excel.

Is anyone else experiencing this in a similar environment?

Re: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Posted: Wed Nov 14, 2018 1:32 am
by penguinsareawesome
I am getting the same error using PA 2.0.4 with a 64-bit version of Excel 2013. Dimension worksheets are fine when opening using the 32-bit version (on multiple machines) so seems that the issue is the 64bit version of excel/Tm1 add-in.

I am also able to save the dimension on the 64-bit version as long as I open it via the standard excel function, not the Tm1 add-in drop -down option

Re: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Posted: Mon May 20, 2019 3:47 am
by Eighty3
We upgraded from TM1 10.2.1 to PA 2.0 this week and encountered this issue with Microsoft Excel 2013 64 bit

As pointed out by penguinsareawesome, 32 bit works fine

Thanks for the workaround Alan

Is IBM aware of this bug?

Re: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Posted: Tue Jan 07, 2020 1:59 pm
by jwafro
I have a client with the same issue - opening developer options/ "dimension open" causes excel to crash with Excel O365 and Excel 2019 MSO 64 bit.
This same issue has been reproduced using PA 2.0.8 and 10.2.2 under the O365, using Planning Sample.

They need to use the developer feature as they wholesale change the dimensions used in their analysis, and alternative solutions are not as elegant - eg Dimensional editor is clunky, no desire to use TI scripts and CSV inputs either.

We have found that if the local server data directory, once an XDI or XRU file is saved in there will cause Excel to completely crash without error messages when attempting to open a file from that folder. When run directly on the server we got a VBA Automation Error code 440 before the system close.

Creating a new XDI/XRU file in a blank folder works fine, (eg "Dimension New") and loads into the system.

They are maintaining the system using the work around mentioned by others above, eg. Opening the XDI file in excel directly as an excel document and then using the developer/ Dimension Save option.

Anyone heard of a fix from IBM on this?