1

Closed

DQS File error

description

When I try to import the DQS file with the downloaded files of the project "Cleanse and Curate Master Data", I obtain a error : The DQS file contains an unexpected data type.

I try this on a SQL Server 2012 SP1, developer Edition in English and French version.

This is the complete error message :

SQL Server Data Quality Services

Message Id: ApplicationUnhandledException

An unhandled exception has occurred. For more details, see the Data Quality Services client log.

System.AggregateException: One or more errors occurred. ---> Microsoft.Ssdqs.Proxy.ImportExport.ImportExportException: Error occurred in a server proxy call during the import/export process. ---> Microsoft.Ssdqs.Proxy.ImportExport.ImportProcessFailedException:
---begin---
UID=72b8f099-c629-4ab1-ae1f-983e193d90dc
MessageID=ImportExportBadDqsFileType
MessageDateTime=1/21/2013 12:53:27 PM
Data=
Exception=Microsoft.Ssdqs.ImportExportManagement.ImportExport.ImportExportException: The DQS file contains an unexpected data type.
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.DomainBaseImportExportManager.InputDomainBase(ImportExportReader reader)
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.DomainBaseImportExportManager.Import(ImportExportReader reader)
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.ImportExportManager.Import(Stream input)
at Microsoft.Ssdqs.ImportExportManagement.Calibrator.ImportDomainCalibrator.Calibrate(IMasterContext masterContext, CalibrationMode calibrationMode, ConfigurationDomParameter calibratorConfiguration)
at Microsoft.Ssdqs.Core.Service.Calibration.Impl.ExecuteCalibratorFlow.Process(IMasterContext context)
---end---

--- End of inner exception stack trace ---
at Microsoft.Ssdqs.Proxy.ImportExport.ImportAsProcessManager.WaitUntillProcessCompletes(Int64 processId, Int64 knowledgebaseId, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Proxy.ImportExport.ImportAsProcessManager.DomainImport(Int64 knowledgebaseId, String fileName, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.ImportExportProvider.ImportDomainTask(String fileName, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.ImportExportProvider.<>c__DisplayClass12.b__f()
at System.Threading.Tasks.Task1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
---> (Inner Exception #0) Microsoft.Ssdqs.Proxy.ImportExport.ImportExportException: Error occurred in a server proxy call during the import/export process. ---> Microsoft.Ssdqs.Proxy.ImportExport.ImportProcessFailedException:
---begin---
UID=72b8f099-c629-4ab1-ae1f-983e193d90dc
MessageID=ImportExportBadDqsFileType
MessageDateTime=1/21/2013 12:53:27 PM
Data=
Exception=Microsoft.Ssdqs.ImportExportManagement.ImportExport.ImportExportException: The DQS file contains an unexpected data type.
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.DomainBaseImportExportManager.InputDomainBase(ImportExportReader reader)
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.DomainBaseImportExportManager.Import(ImportExportReader reader)
at Microsoft.Ssdqs.ImportExportManagement.ImportExport.ImportExportManager.Import(Stream input)
at Microsoft.Ssdqs.ImportExportManagement.Calibrator.ImportDomainCalibrator.Calibrate(IMasterContext masterContext, CalibrationMode calibrationMode, ConfigurationDomParameter calibratorConfiguration)
at Microsoft.Ssdqs.Core.Service.Calibration.Impl.ExecuteCalibratorFlow.Process(IMasterContext context)
---end---

--- End of inner exception stack trace ---
at Microsoft.Ssdqs.Proxy.ImportExport.ImportAsProcessManager.WaitUntillProcessCompletes(Int64 processId, Int64 knowledgebaseId, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Proxy.ImportExport.ImportAsProcessManager.DomainImport(Int64 knowledgebaseId, String fileName, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.ImportExportProvider.ImportDomainTask(String fileName, ImportExportCancellationToken cancelToken)
at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.ImportExportProvider.<>c__DisplayClass12.b__f()
at System.Threading.Tasks.Task
1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()<---
Closed Jan 23, 2013 at 1:00 AM by spelluru
Resolved.

comments

PGeiger wrote Jan 21, 2013 at 11:12 AM

Problem fixed.

I tried to import the DQS file as a domain import file.

With my excuses.

spelluru wrote Jan 23, 2013 at 12:59 AM

No problem at all. Glad you figured it out.