Hi,
I have installed the TM1 10.2.2 version ( Windows 10 OS) and installed the SSL certificates also. The architect and perspective is working fine but when I open the TM1 performance modeler , it is throwing errors. For the default server, Planning sample as " Unable to connect to the Planning service" and for another server as "could not login to any available Servers with the provided credentials. Could you please tell me what is the issue, even when the architect , perspective is working fine with the same login. Attached are the screenshots.
TM1 Performance modeler Login issue
-
- Posts: 44
- Joined: Thu May 01, 2014 12:46 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
TM1 Performance modeler Login issue
- Attachments
-
- 2.jpg (48.36 KiB) Viewed 6292 times
-
- 1.png (125.62 KiB) Viewed 6292 times
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: TM1 Performance modeler Login issue
Search "Unable to connect to the Planning service" in google. Try them.
-
- Posts: 44
- Joined: Thu May 01, 2014 12:46 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: TM1 Performance modeler Login issue
I have tried the options searching the google but didn't work. Could anybody please reply who had the similar issue and resolution.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: TM1 Performance modeler Login issue
What options did you try?
-
- Posts: 44
- Joined: Thu May 01, 2014 12:46 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: TM1 Performance modeler Login issue
Tried the below options but it is not working. When i login with planning Sample server, it allows login and i can see the server but when click ok then it throws the error " Unable to connect to the Planning service"
1.Increase the Max Connections value to allow user to open more connections to the TM1 server.
2.Login into Architect and open each view and the ones that do not open should be deleted.
1.Increase the Max Connections value to allow user to open more connections to the TM1 server.
2.Login into Architect and open each view and the ones that do not open should be deleted.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: TM1 Performance modeler Login issue
Is the TM1 server available in applications portal? Is the server name available in your XML configuration file(s)
http://www-01.ibm.com/support/docview.w ... wg21961103
http://www.tm1forum.com/viewtopic.php?t=7653
http://www-01.ibm.com/support/docview.w ... wg21961103
http://www.tm1forum.com/viewtopic.php?t=7653
-
- Posts: 44
- Joined: Thu May 01, 2014 12:46 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: TM1 Performance modeler Login issue
i have tried the given option but still couldn't succeed. I got the attached warning error and I had updated the tm1s.cfg file also with below options. But Still it throws the error as " unable to connect to the planning service". I tried to connect to another server also but it throws the same error as " unable to connect to the planning service"
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tunit
ForceReevalutionOfFeedersForFedCellsOnDataChange=T
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tunit
ForceReevalutionOfFeedersForFedCellsOnDataChange=T
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Performance modeler Login issue
Could it be a typo? You're missing an a.krithika331 wrote:
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tunit
ForceReevalutionOfFeedersForFedCellsOnDataChange=T
ForceReevaluationOfFeedersForFedCellsOnDataChange
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- JulianS
- Posts: 20
- Joined: Fri Jul 07, 2017 1:34 pm
- OLAP Product: TM1
- Version: 10.3
- Excel Version: 2013
Re: TM1 Performance modeler Login issue
Hi krithika331,
I've had very similar issues at a clients, it was an install problem for us.
What we did to fix it was to
A)Uninstall the TM1 application (making sure that you have all your TM1 models saved somewhere safe).
B)We then made sure that the TM1 folder was removed completely from the C:\Program_files\IBM folder as we have had models lurking there after an uninstall.
C)Set the clock on the server back to when the Install SSL certificates were valid (eg just set the time back on the server to say middle of last year 1/6/2016).
D) Install TM1 and PM will install correctly.
E) Move the clock forward again to the correct time.
F) Then apply the SSL updates.
It worked for us but it was a new vanilla install, so maybe something to try if all else fails
Good luck dude.
I've had very similar issues at a clients, it was an install problem for us.
What we did to fix it was to
A)Uninstall the TM1 application (making sure that you have all your TM1 models saved somewhere safe).
B)We then made sure that the TM1 folder was removed completely from the C:\Program_files\IBM folder as we have had models lurking there after an uninstall.
C)Set the clock on the server back to when the Install SSL certificates were valid (eg just set the time back on the server to say middle of last year 1/6/2016).
D) Install TM1 and PM will install correctly.
E) Move the clock forward again to the correct time.
F) Then apply the SSL updates.
It worked for us but it was a new vanilla install, so maybe something to try if all else fails
Good luck dude.