Data Source Unavailable !

Technote (troubleshooting)


Problem(Abstract)

Unable to create External Excel File Data Source. After 'browsing' to 'Select File', the user receives the above error.

Symptom

AllErrors.log:

2013-06-06 17:42:31,490 [14] ERROR Ibm.CognosDM.Services.Exceptions.CdmErrorHandler - (null) ExceptionToken: 6ec82987-9939-415d-95ca-fde24a865792 ? ? ? Ibm.CognosDM.DataSources.DataSourceUnavailableException: Connectiong to data sources with Windows Authentication is disabled
at Ibm.CognosDM.BusinessLogic.ExternalData.DataSources.DataSourceImpersonator.RunUnderWindowsCredentials[T](Func`1 func)
at SyncInvokeGetCanConnectToExternalExcelFile(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)



Environment

CDM 10.2.x.xxxx

Excel Data Source


Resolving the problem

Ensure that the CDM application can access the External Excel File.


Note:
For CDM 10.2.0, edit the CDM.config
For CDM 10.2.1, edit the CREDENTIALS.config

Edit the config file with a user that can access the file (ie like a domain admin or Service Acct with admin rights to where the Excel file is).

Steps:
1. Navigate to the CDM installation directory: C:\inetpub\wwwroot\CognosDM-Server\Config
2. Edit the CDM.config file
3. <WindowsAuthentication>
<DataSourcesCredentials enabled="true" userName="domain\username" password="userpswd" />
<ActiveDirectoryImportCredentials enabled="true" userName="" password="" />
</WindowsAuthentication>


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Disclosure Management
Cognos Disclosure Management

Software version:

10.2, 10.2.1

Operating system(s):

Windows

Reference #:

1640025

Modified date:

2013-07-03

Translate my page

Machine Translation

Content navigation