Cafe - System URL

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

Post by winsonlee »

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 ?
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Cafe - System URL

Post by Edward Stuart »

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

Post by winsonlee »

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.
kangkc
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

Post by kangkc »

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

Post by ioscat »

Good morning!
I can't beat the error

Code: Select all

COI-ERR-2019 Connection failed. Connection returned an 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
mberson
Posts: 30
Joined: Tue Jun 07, 2011 8:30 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Cafe - System URL

Post by mberson »

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

Post by moby91 »

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)
mberson
Posts: 30
Joined: Tue Jun 07, 2011 8:30 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Cafe - System URL

Post by mberson »

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
Matthew Berson
ACG TM1 Consulting
Jodha
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

Post by Jodha »

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.

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]
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.
Jodha
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

Post by Jodha »

By installing Application Server in Source server ( remote Server where TM1 Server is installed ) resolved my issue.

Every one thanks for your Inputs
Post Reply