TM1 9.4 and Workflow 9.4.1
TM1 9.4 and Workflow 9.4.1
Hi,
I am testing this Workflow(AKA Planning Manager??)
Anyway, after installation, when I open Excel and select TM1 Workflow -> Admin(as manual indicated), the error message shows up:
Compile Error in hidden module : frmTaskActions
Does anyone know what casues this error?
I was testing it on dev server a month ago and it was working fine. Then I stopped testing it. Today I went back to the dev server, and it doesn't work anymore. I tried complete uninstall and reinstall everything(TM1 Server, TM1 Client, Workflow, Excel)
It still gives me the same error.
Any thought would be appreciated.
Thanks.
I am testing this Workflow(AKA Planning Manager??)
Anyway, after installation, when I open Excel and select TM1 Workflow -> Admin(as manual indicated), the error message shows up:
Compile Error in hidden module : frmTaskActions
Does anyone know what casues this error?
I was testing it on dev server a month ago and it was working fine. Then I stopped testing it. Today I went back to the dev server, and it doesn't work anymore. I tried complete uninstall and reinstall everything(TM1 Server, TM1 Client, Workflow, Excel)
It still gives me the same error.
Any thought would be appreciated.
Thanks.
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
Has your excel version been updated in any way?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Re: TM1 9.4 and Workflow 9.4.1
Thank you, Jim, for the reply.
I re-installed Office 2003 Pro with Complete option.
Is there any excel patch I have to install?
I re-installed Office 2003 Pro with Complete option.
Is there any excel patch I have to install?
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
I'm not sure if a sepcific patch will solve your issue. I'm just trying to identify any other possible areas of change. Have you tried running Microsoft Update to update your Excel install. It may not help but it is worth a try,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
I've never used Workflow, but I think that this one may warrant a support request. A compile error will generally come from one of two things:hpark wrote: Compile Error in hidden module : frmTaskActions
Does anyone know what casues this error?
- Invalid VBA code. Unlikely in itself, since AFAIK the VBA6 libraries haven't been significantly changed in yonks so if that was the problem it wouldn't have worked in the past either; or
- An invalid external (library) reference. Granted this struck me as unlikely since you reinstalled everything, but honestly it's the only thing I can think of. It's possible that a library that the add-in is dependent on either didn't install properly or didn't register properly.
Rather than groping around in the dark it may be better to raise a support request describing the symptoms and giving the version number of both Workflow and Excel, and ask whether there are any dependencies in the code in that module that you should be looking for.
But I do agree with Jim; make sure that all updates for Excel have been installed first, and that you're running with the latest SP for your version.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Ajay
- Regular Participant
- Posts: 183
- Joined: Wed May 14, 2008 8:27 am
- OLAP Product: TM1
- Version: 10.2.0, PA 2.0.9
- Excel Version: 2016
- Location: London
Re: TM1 9.4 and Workflow 9.4.1
Hi
Did you manage to resolve the issue as I am now hitting the exact same error ?
Cheers
Ajay
Did you manage to resolve the issue as I am now hitting the exact same error ?
Cheers
Ajay
-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
Uninstall the MS security patch introduced by KB960715 (http://www.microsoft.com/technet/securi ... 60715.mspx) and you will be fine. However if you have auto update turned on, this patch will get install again and you will be backed to square one.
It's MS problem/contraint/restriction, whatever they call it.
It's MS problem/contraint/restriction, whatever they call it.
- rodrigo
- Posts: 49
- Joined: Tue Jun 03, 2008 10:34 pm
- OLAP Product: TM1, Executive Viewer
- Version: 9.4 MR1 with FP3
- Excel Version: 2003
Re: TM1 9.4 and Workflow 9.4.1
old.. but
I dont have that KB patch, i looked partially on IBM site (i am still waiting for my code) and it seems that KB932349 (which i dont have also) is also responsable as probably other KB´s. patches. I really dont know if i have the same trouble because I installed it on 9.1. SP 4 with Applix financial planning 1.3 sp 1, I have a XP Pro SP3.
¿was solved? if automatic updates causes this, is a bit annoying...
thanks amigos.

I dont have that KB patch, i looked partially on IBM site (i am still waiting for my code) and it seems that KB932349 (which i dont have also) is also responsable as probably other KB´s. patches. I really dont know if i have the same trouble because I installed it on 9.1. SP 4 with Applix financial planning 1.3 sp 1, I have a XP Pro SP3.
¿was solved? if automatic updates causes this, is a bit annoying...
thanks amigos.

-
- Posts: 38
- Joined: Wed Mar 25, 2009 7:35 am
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2003
Re: TM1 9.4 and Workflow 9.4.1
Hi kangkc,kangkc wrote:Uninstall the MS security patch introduced by KB960715 (http://www.microsoft.com/technet/securi ... 60715.mspx) and you will be fine. However if you have auto update turned on, this patch will get install again and you will be backed to square one.
It's MS problem/contraint/restriction, whatever they call it.
Thank you so much for your tips.
I have uninstalled KB960715 and it really works well now.
Thanks again and best regards!

-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
No worry.
Just found that MS released another ActiveX Killbits, KB973346. I would try to avoid this till I have time to test it out.
Just found that MS released another ActiveX Killbits, KB973346. I would try to avoid this till I have time to test it out.
-
- Posts: 19
- Joined: Fri May 15, 2009 12:44 pm
- Version: 9.4 MRC
- Excel Version: 2000
Re: TM1 9.4 and Workflow 9.4.1
I hit the same error!
After I deleted the KB960715 yesterday , It solved.
But I update KB973525 today , this error come again .And now i can't rollback to make the workflow work . Even if i uninstalled KB973525
Can anyone can help !
After I deleted the KB960715 yesterday , It solved.
But I update KB973525 today , this error come again .And now i can't rollback to make the workflow work . Even if i uninstalled KB973525
Can anyone can help !
-
- Community Contributor
- Posts: 139
- Joined: Mon Sep 15, 2008 1:45 pm
Re: TM1 9.4 and Workflow 9.4.1
I have run into the same error on different machines with excel 2003 and excel 2007. It seems likely to me that it has to do with windows updates as other posters mentioned.
However, if you are just testing workflow it may be worth to wait for 9.5 as workflow is completely redone and at least 'looks' a lot better than in earlier versions. (I have only seen it demo'ed not actually played with it myself yet - it looks a lot like workflow in cognos planning now)
Jeroen
However, if you are just testing workflow it may be worth to wait for 9.5 as workflow is completely redone and at least 'looks' a lot better than in earlier versions. (I have only seen it demo'ed not actually played with it myself yet - it looks a lot like workflow in cognos planning now)
Jeroen
-
- Posts: 38
- Joined: Wed Mar 25, 2009 7:35 am
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2003
Re: TM1 9.4 and Workflow 9.4.1
Come across with the same problem again
While there is no KB960715, I uninstalled KB973346,but it doesn't work
Any ideas?

While there is no KB960715, I uninstalled KB973346,but it doesn't work

Any ideas?
-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: TM1 9.4 and Workflow 9.4.1
Only way to get around this is this article:
http://www.developersdex.com/vb/message ... &r=6570804
You will have to edit registry.
http://www.developersdex.com/vb/message ... &r=6570804
You will have to edit registry.

-
- Posts: 38
- Joined: Wed Mar 25, 2009 7:35 am
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2003
Re: TM1 9.4 and Workflow 9.4.1
Following the method in
http://forums.olapforums.com/viewtopic.php?f=3&t=1740
My workflow works well now.
Thank you all.
http://forums.olapforums.com/viewtopic.php?f=3&t=1740
My workflow works well now.
Thank you all.
-
- Posts: 13
- Joined: Fri Nov 06, 2009 6:48 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
Re: TM1 9.4 and Workflow 9.4.1
Hi,
I am from Milind team,
I have changed the compatibility flag DWORD to 0 under {0ECD9B64-23AA-11D0-B351-00A0C9055D8E} key,but still am getting the same error.
is there any other things needs to be checked?
Rgds,
Nat
I am from Milind team,
I have changed the compatibility flag DWORD to 0 under {0ECD9B64-23AA-11D0-B351-00A0C9055D8E} key,but still am getting the same error.
is there any other things needs to be checked?
Rgds,
Nat
- rodrigo
- Posts: 49
- Joined: Tue Jun 03, 2008 10:34 pm
- OLAP Product: TM1, Executive Viewer
- Version: 9.4 MR1 with FP3
- Excel Version: 2003
Re: TM1 9.4 and Workflow 9.4.1
Is strange,
Did you close all excel workflow manager sessions, on a better scenario, any excel opened on the server or computer?
Did you close all excel workflow manager sessions, on a better scenario, any excel opened on the server or computer?
-
- Posts: 1
- Joined: Wed Nov 11, 2009 11:39 am
- OLAP Product: Cognos TM1
- Version: TM191_SP3_U2_x86
- Excel Version: MS excel 2003 sp2
which verstion of patches to solve this problem
Hi ,
How to implement the patches in the server( I mean Application patches,we are currently using Cognos TM19.1 SP3 U2 version).Patches needs to be installed in order to solve the copy and paste problem .Please suggest which patches we need to implement whihc are suitable for this version ,?
We except your response at the earliest.
Thank you,
Praveen
How to implement the patches in the server( I mean Application patches,we are currently using Cognos TM19.1 SP3 U2 version).Patches needs to be installed in order to solve the copy and paste problem .Please suggest which patches we need to implement whihc are suitable for this version ,?
We except your response at the earliest.
Thank you,
Praveen