Cognos Analytics 11.06 Kills TM1 Web
-
- Posts: 22
- Joined: Sun Mar 12, 2017 1:41 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0.21, PAW
- Excel Version: Excel 2013
- Location: Los Angeles, Atlanta
Cognos Analytics 11.06 Kills TM1 Web
We are currently trying to install Cognos Analytics 11.06 to handle authentication under mode 5 for our Planning Analytics 2.0.2 install. We have twice not encountered the same issue. After installing Cognos Analytics and starting up the server for the first time, Cognos TM1 completely stops running on port 9510. The port doesn't even show as active anymore when TM1 services are started up like it should. We're not sure if the Analytics install has a default port number that conflicts with 9510, but what is also odd is that even after completely uninstalling Cognos Analytics, TM1Web still doesn't come up. Not sure if there's something conflicting entries in the registry or something but we're having a hard time conceptualizing why starting Cognos analytics would alter our tm1 install to the point that it completely fails, and seems to be irreversible short of completely uninstalling and re-installing tm1 on the server.
Thanks!
Thanks!
- Elessar
- Community Contributor
- Posts: 341
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Cognos Analytics 11.06 Kills TM1 Web
Hi,
What "netstat -an" says?
The database used for content store can take port 9510. What DB are you using? Is it on the same machine?
What "netstat -an" says?
The database used for content store can take port 9510. What DB are you using? Is it on the same machine?
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 22
- Joined: Sun Mar 12, 2017 1:41 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0.21, PAW
- Excel Version: Excel 2013
- Location: Los Angeles, Atlanta
Re: Cognos Analytics 11.06 Kills TM1 Web
Netstat isn't showing anything active on the port 9510 anymore. Thanks for the tip on the contentstore. We are trying to run Analytics and TM1 on the same machine. The biggest mystery to me still is that something appears to be modified in our TM1 install during the initial boot of the analytics server that I can't seem to figure out how to reverse. I assumed that if 9510 just had a port conflict between analytics and tm1 that things would function on tm1 when I don't have the analytics server started, and especially after a full uninstall of analytics, but that doesn't seem to be the case. There seems to be some remnant of the install that I can't seem to be able to get rid of with the analytics uninstaller. Even after uninstalling analytics, starting the TM1 services doesn't boot up tm1 web anymore, and even though there are no errors on startup, nothing shows active on 9510 on netstat.
There's also, of course, nothing of use in the tm1web.log file.
There's also, of course, nothing of use in the tm1web.log file.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Cognos Analytics 11.06 Kills TM1 Web
So you're trying to run Cognos BI and TM1 om the same box? All I can say is why? I'm pretty sure that is not a preferred or recommended configuration from IBM. Trying to save a few bucks on a some hardware and a Windows server license cannot be worth the hassles you are running into.
- jim wood
- Site Admin
- Posts: 3951
- 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: Cognos Analytics 11.06 Kills TM1 Web
To be fair IBM make it look like the "same box" in their demos. But I agree with Tomok, having them on the same box is never a good plan.
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
- Elessar
- Community Contributor
- Posts: 341
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Cognos Analytics 11.06 Kills TM1 Web
You didn't answer the "DB for content store" question If Informix was installed by default, after the CA uninstallation Informix might not be uninstalled and still can listen to 9510.
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
- jim wood
- Site Admin
- Posts: 3951
- 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: Cognos Analytics 11.06 Kills TM1 Web
Answering questions? Blimey, you're obviously an optimist!!!
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
-
- Posts: 22
- Joined: Sun Mar 12, 2017 1:41 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0.21, PAW
- Excel Version: Excel 2013
- Location: Los Angeles, Atlanta
Re: Cognos Analytics 11.06 Kills TM1 Web
So to update everyone. We got everything working in this configuration by uninstalling tm1 and analytics fully and then redoing the install with analytics installed on a clean machine and configured, and then adding the tm1 install. Once tm1 was re-installed and started up there were no issues with tm1 web. I'm not sure at all why but what it appears was happening is that somehow the analytics install was corrupting an existing tm1 install. I hadn't seen anything in IBM's documentation that suggested it was a necessity to install analytics on the server first, but that appears to be the case from this experience. The reason we are thinking about using the same server is because we only plan on using CA for authentication and not any of the analysis products, which we'll end up disabling in configuration.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Cognos Analytics 11.06 Kills TM1 Web
You don't need the full Cognos BI suite installed to use CAM. There is a run-time component that you can install that only does the CAM stuff.
-
- Posts: 22
- Joined: Sun Mar 12, 2017 1:41 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0.21, PAW
- Excel Version: Excel 2013
- Location: Los Angeles, Atlanta
Re: Cognos Analytics 11.06 Kills TM1 Web
This looks like it was covered in another thread and there it didn't seem that the runtime environment didn't exist past 10.1.
http://www.tm1forum.com/viewtopic.php?t=12167
Since we are running Planning Analytics 2.0.2 that didn't seem to be an option anymore. If it is we would definitely do that instead of running the full CA server.
http://www.tm1forum.com/viewtopic.php?t=12167
Since we are running Planning Analytics 2.0.2 that didn't seem to be an option anymore. If it is we would definitely do that instead of running the full CA server.