IBM Support

Not able to connect to Cognos 10 from "IBM Cognos for Microsoft Office 10.1.0"

Troubleshooting


Problem

After installation and configuration IBM Cognos for Microsoft Office enable to connect to Cognos 10, an error occurs "System.Net.WebException: Unable to connect to the remote server".

Symptom

Error received:
System.Net.WebException: Impossible de se connecter au serveur distant ---> System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu 128.30.52.37:80
à System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
à System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
à System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- Fin de la trace de la pile d'exception interne ---
à System.Net.HttpWebRequest.GetResponse()
à System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials credentials)
à System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials)
à System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)
à System.Xml.XmlTextReaderImpl.OpenStream(Uri uri)
à System.Xml.XmlTextReaderImpl.DtdParserProxy_PushExternalSubset(String systemId, String publicId)
à System.Xml.XmlTextReaderImpl.DtdParserProxy.System.Xml.IDtdParserAdapter.PushExternalSubset(String systemId, String publicId)
à System.Xml.DtdParser.ParseExternalSubset()
à System.Xml.DtdParser.ParseInDocumentDtd(Boolean saveInternalSubset)
à System.Xml.DtdParser.Parse(Boolean saveInternalSubset)
à System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
à System.Xml.XmlTextReaderImpl.ParseDocumentContent()
à System.Xml.XmlTextReaderImpl.Read()
à System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
à System.Xml.XmlDocument.Load(XmlReader reader)
à System.Xml.XmlDocument.LoadXml(String xml)
à Cognos.Office.Framework.DataSource.Cognos8.C8SOAPUtilities.ParseError(Stream stream)
à Cognos.Office.Framework.DataSource.Cognos8.HttpConnection.Send(String sSOAPRequestBody, String sAction, Boolean CacheResult)
à Cognos.Office.Framework.DataSource.Cognos8.HttpConnection.Send(ISOAPRequest request)
à Cognos.Office.Framework.DataSource.Cognos8.C8ContentStore.PortalTree_DoWork(RequestInfo req)
à Cognos.Office.Framework.Threading.ThreadPool.Thread_DoWork(Object sender, DoWorkEventArgs e)

Cause

The address for the IBM Cognos BI gateway, in the IBM Cognos for Microsoft Office configuration, is not correct.

Environment

Windows

Resolving The Problem

On the IBM Cognos toolbar, click the Options button .
In the left navigation pane, click IBM Cognos.
Under IBM Cognos Systems, in the System gateway URI box, type the URI that identifies the location of the IBM Cognos BI gateway.
An example is the following, where server name is either the IP address of the computer or the computer name: "http://servername/ibmcognos/cgi-bin/cognos.cgi "

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Cognos for Microsoft Office","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 November 2022

UID

swg21574005