Symptom

Screen:
Launching Excel link:

IBM Cognos 8 Controller Link
System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Configuration.ConfigurationErrorsException: The configuration section cannot contain a CDATA or text element. (C:\Program Files\cognos\c8v5\ControllerProxyServer\web.config line 113)
at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(yyyyyyy
[OK]

Launching 'main' Controller program (CCR.EXE):

An error occurred while trying to access the server

Event Viewer (Application Log):

Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2011-07-18
Time: 14:53:14
User: N/A
Computer: SERVERNAME
Description:
Error occured at 2011-07-18 14:53:14 in 2007 Microsoft Office system, Error No=5, Source=FrangoDirect.ConnectionDirect.IntegrationType#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Configuration.ConfigurationErrorsException: The configuration section cannot contain a CDATA or text element. (C:\Program Files\cognos\c8v5\ControllerProxyServer\web.config line 113)
at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.HttpContext.GetSection(String sectionName)
at System.Web.Configuration.HttpConfigurationSystem.GetSection(String sectionName)
at System.Web.Configuration.HttpConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String configKey)
at System.Configuration.ConfigurationManager.GetSection(String sectionName)
at System.Configuration.ConfigurationManager.get_AppSettings()
at Cognos.Controller.Proxy.SoapExtension.ServerExtension.Init()
at Cognos.Controller.Proxy.SoapExtension.ServerExtension.Initialize(Object initializer)
at System.Web.Services.Protocols.SoapReflectedExtension.CreateInstance(Object initializer)
at System.Web.Services.Protocols.SoapMessage.InitializeExtensions(SoapReflectedExtension[] reflectedExtensions, Object[] extensionInitializers)
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, HttpContext context, HttpRequest request, HttpResponse response)
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing), HelpFile= HelpContext=0