It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,033
×1,230

question asked: Nov 20 '12, 9:53 a.m.
question was seen: 7,786 times
last updated: Nov 21 '12, 2:41 p.m.

Related questions

Insight 1.1.1 cant access : http://9.6.98.189:80/ibmcognos/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/close.xts

0
Cesar Sasaki (511●2●89●129) | asked Nov 20 '12, 9:53 a.m.
Hi

I have installed the Rational Insight 1.1.1 (or I must say the RRDI 2.0 with the Insight extension).
Run the setup correctly (at least I thought I was) and then I wanted to try to use a excel spreadsheet as a Live data model. But when creating the Data Source in the Framework Manager I got this error :

 No se puede acceder al servicio en el URL: http://9.6.98.189:80/ibmcognos/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/close.xtsCompruebe que la información de su URI de pasarela está configurada correctamente y que el servicio está disponible.Para obtener información adicional, póngase en contacto con el administrador del servicio.

Is it in spanish but is something like " You can not access the URL service : http........... Check the information of our gateway URI is configured correctly and if the service is available."

What do I have to change?
I can go in to the URL of the Insight and it opens but cant create a data source.

Thanks






Accepted answer

0
permanent link
Kelvin Low (163●2●1) | answered Nov 20 '12, 12:34 p.m.
JAZZ DEVELOPER

I assume you got Framework Manager (FM) installed through the Insight 1.1.1 Development Tools. To fix the issue, run Cognos Configuration that was installed with FM, click Environment and modify the following URIs to point to your report server. For example,

Gateway URI: http://reportserver1.ibm.com:9080/reporting/servlet/dispatch

Dispatcher URI for external applications: http://reportserver1.ibm.com:9080/reporting/servlet/dispatch

Save the changes and relaunch FM again.

Cesar Sasaki selected this answer as the correct answer
Comments
Cesar Sasaki commented Nov 20 '12, 5:49 p.m.

Hi

Thanks for the reply, it worked. But then when testing my data source (excel spreadsheet) in the  "New data source" it  take an error State.
Any idea please?

2 other answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kelvin Low (163●2●1) | answered Nov 20 '12, 6:26 p.m.
JAZZ DEVELOPER
Can you describe the steps you took to define the Excel data source in FM?
Comments
Cesar Sasaki commented Nov 20 '12, 11:24 p.m.

I create on FM a new project, then select create new data source and choose the one I had previously create in the ODBC connections of the DSN system.
Then when I put test connection I got "Error".

I followed a guide from someone of IBM to use a excel spreadsheet as a live data model.!

0
permanent link
Kelvin Low (163●2●1) | answered Nov 21 '12, 2:41 p.m.
JAZZ DEVELOPER

You can follow this Jazz.net article, https://jazz.net/library/article/671/, to integrate an Excel spreadsheet with Rational Insight. The key things to watch out are:

1. Make sure you run the 32-bit ODBC Administrator tool when adding the System DSN for the Excel spreadsheet.

2. Make sure you select the correct driver in the ODBC Administrator tool. For example, select the Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) if your spreadsheet was created using Excel 2010 and saved in .xlsx format. If you select the wrong driver, the data source test in FM will fail.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.