TM1 Performance modeler Login issue

Post Reply
krithika331
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

Post by krithika331 »

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.
Attachments
2.jpg
2.jpg (48.36 KiB) Viewed 6289 times
1.png
1.png (125.62 KiB) Viewed 6289 times
User avatar
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

Post by macsir »

Search "Unable to connect to the Planning service" in google. Try them.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
krithika331
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

Post by krithika331 »

I have tried the options searching the google but didn't work. Could anybody please reply who had the similar issue and resolution.
Edward Stuart
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

Post by Edward Stuart »

What options did you try?
krithika331
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

Post by krithika331 »

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.
Edward Stuart
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

Post by Edward Stuart »

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
krithika331
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

Post by krithika331 »

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
Wim Gielis
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

Post by Wim Gielis »

krithika331 wrote:
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tunit
ForceReevalutionOfFeedersForFedCellsOnDataChange=T
Could it be a typo? You're missing an a.

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
User avatar
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

Post by JulianS »

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.
Post Reply