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