87746 999 616 Type Mismatch error 9.0SP3U9 Client in Citrix

Post bug reports and the status of reported bugs
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 5991
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia

87746 999 616 Type Mismatch error 9.0SP3U9 Client in Citrix

Post by Alan Kirk » Thu Dec 17, 2009 10:54 pm

Regular readers will be aware of the "affection" that I have for unhandled errors in code that people charge money for.

The method of load is unimportant; via an application shortcut, manually, by including it in the add-ins list; same result, every time.
The 9.0 SP3 client (tm1p.xla and related files) is located in a folder on a server.

When a local user opens this add-in on their desktop it works, provided that security restrictions are overcome.

However when it is used in Citrix, it generates an error 13 (Type Mismatch) on load. The menu item Save Workbook On TM1 Server is missing from the menu (the text is blank), and is not functional. (External files can still be added via Server Explorer.) The Print Reports menu item is blank, but still functions when you select it.

Leaving aside the fact that someone wrote VBA code in professional level software *WITHOUT AN ERROR HANDLER*, first, we can't deploy this via Citrix if the users will get an error message every time they load the add-in and second, we're missing a piece of functionality that was planned to be used extensively.

The Citrix server is an Intel Xeon running Windows Server 2003 Enterprise Edition SP1.

I'm aware that 9.0 goes off support in only a couple of weeks but really, it shouldn't be that hard to whack in a couple of lines of code in the add-in to do an error check and look up how the On Error Goto statement works. Odds are it's happening where the menu items are being created.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Post Reply