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
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
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
|
2 other answers
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.
|
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
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.