Cafe - System URL
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Cafe - System URL
hI ,
Any one here uses Cafe before ?
I am trying to configure it to connect to TM1 but couldnt find the right System URL.
What should I enter for that ?
Any one here uses Cafe before ?
I am trying to configure it to connect to TM1 but couldnt find the right System URL.
What should I enter for that ?
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Cafe - System URL
Input the value for the TM1 Cognos Application Server.
This can be found within IBM Cognos Configuration on TM1 Application Server > External System URI
My local installation is: http://localhost:9510
This can be found within IBM Cognos Configuration on TM1 Application Server > External System URI
My local installation is: http://localhost:9510
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: Cafe - System URL
When i did a test connection i got the following error. I have entered as per mention in the "External Server URI". Any idea what else could be wrong ?
I am getting COI-ERR-2019 Connection Failed. COnnection returned an error. Verify that the connection string, including the server name and port number, is correct.
I am getting COI-ERR-2019 Connection Failed. COnnection returned an error. Verify that the connection string, including the server name and port number, is correct.
-
- 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: Cafe - System URL
I assume when you choose datasource type, you did indicate IBM Cognos TM1 and NOT Cognos BI. Works perfectly here. The URI looks correct which is http://your_server:9510
- ioscat
- Regular Participant
- Posts: 209
- Joined: Tue Jul 10, 2012 8:26 am
- OLAP Product: Contributor
- Version: 9.5.2 10.1.1 10.2
- Excel Version: 07+10+13
- Contact:
Re: Cafe - System URL
Good morning!
I can't beat the error
I'm trying to configure CAFE connection to TM1 server, and have tried to use as system URL different names:
http://localhost:9510
http://localhost:9510/pmhub
http://testpc:9510
http://testpc:9510/pnhub
http://testpc.localdomain:9510
http://testpc.localdomain:9510/pmhub
In the Cofiguration the External URI is http://localhost:9510
I can't beat the error
Code: Select all
COI-ERR-2019 Connection failed. Connection returned an error...
http://localhost:9510
http://localhost:9510/pmhub
http://testpc:9510
http://testpc:9510/pnhub
http://testpc.localdomain:9510
http://testpc.localdomain:9510/pmhub
In the Cofiguration the External URI is http://localhost:9510
-
- Posts: 30
- Joined: Tue Jun 07, 2011 8:30 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: Cafe - System URL
Is this after installing FP1? It worked perfectly for me pre-Fix Pack, but now I'm having this same issue.
Matthew Berson
ACG TM1 Consulting
ACG TM1 Consulting
-
- MVP
- Posts: 227
- Joined: Fri Mar 11, 2011 2:18 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003 2007
Re: Cafe - System URL
What kind of environment do you have ?
A single server environment, where everything (TM1 Admin Server, TM1 Server, TM1 Web, TM1 Application Server, etc) is installed on one computer ?
Or a distributed environment, where the components are installed on different computers ?
Especially the TM1 Admin Server being installed on another computer as the TM1 Application Server ?
If you do have a distributed environment, what happens after you executed the steps outlined by the IBM Technote 1658069 ?
http://www-01.ibm.com/support/docview.w ... wg21658069
Configuring TM1 Application Server default admin host in a distributed environment.
What happens after you added the FQDN of the host running the TM1 Application Server to the Local Intranet or Trusted Sites of your web browser as outlined by the IBM Technote 1601314 ?
http://www-01.ibm.com/support/docview.w ... wg21601314
Unable to log into the TM1 Application Server using the Fully Qualified Domain Name (FQDN)
A single server environment, where everything (TM1 Admin Server, TM1 Server, TM1 Web, TM1 Application Server, etc) is installed on one computer ?
Or a distributed environment, where the components are installed on different computers ?
Especially the TM1 Admin Server being installed on another computer as the TM1 Application Server ?
If you do have a distributed environment, what happens after you executed the steps outlined by the IBM Technote 1658069 ?
http://www-01.ibm.com/support/docview.w ... wg21658069
Configuring TM1 Application Server default admin host in a distributed environment.
What happens after you added the FQDN of the host running the TM1 Application Server to the Local Intranet or Trusted Sites of your web browser as outlined by the IBM Technote 1601314 ?
http://www-01.ibm.com/support/docview.w ... wg21601314
Unable to log into the TM1 Application Server using the Fully Qualified Domain Name (FQDN)
-
- Posts: 30
- Joined: Tue Jun 07, 2011 8:30 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: Cafe - System URL
Got the fix for my scenario thanks to Dave Usherwood on this. There is a directory that needs to be deleted after FP1 is applied.
Refer to this post: http://www.tm1forum.com/viewtopic.php?f=3&t=9919
Refer to this post: http://www.tm1forum.com/viewtopic.php?f=3&t=9919
Matthew Berson
ACG TM1 Consulting
ACG TM1 Consulting
-
- Posts: 62
- Joined: Tue Mar 13, 2012 4:34 am
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2007 2010 SP1
Re: Cafe - System URL
Hi All,
I am facing simailar issue i am not able to configure system url under options . i copied external URL http://localhost:9510from cognos configuration it saved with out any issues but when i tried to configure TM1 server installed on different server http://ServerName:9510/ it is showing below error.
I deleted config.ini file from G:\ibm\cognos\tm1_64\tomcat\work\Catalina\localhost\pmhub\eclipse\configuration after installing 10.2 FP2 as suggested in http://www-01.ibm.com/support/docview.w ... wg24036618.
Iam using TM110.2 32 bit cognos cafe on 64 bit 2008 R2 server with 2010 32 bit Excel .
Thanks for your reply in advance.
I am facing simailar issue i am not able to configure system url under options . i copied external URL http://localhost:9510from cognos configuration it saved with out any issues but when i tried to configure TM1 server installed on different server http://ServerName:9510/ it is showing below error.
Code: Select all
[b]COI-ERR-2019 Connection Failed. Connection returned an error. Verify that the connection string, including the server name and port number, is correct.[/b]
Iam using TM110.2 32 bit cognos cafe on 64 bit 2008 R2 server with 2010 32 bit Excel .
Thanks for your reply in advance.
-
- Posts: 62
- Joined: Tue Mar 13, 2012 4:34 am
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2007 2010 SP1
Re: Cafe - System URL
By installing Application Server in Source server ( remote Server where TM1 Server is installed ) resolved my issue.
Every one thanks for your Inputs
Every one thanks for your Inputs