Dear Experts,

 

I have installed CTP3, using DQS i am trying to perform data discovery analysis for SQL Server table .

after i hit the start button i have an error saying "Execution of parallel task failed".

Any assistance is highly appreciated..

 

PS- i have run a query as below as well

USE

 

[DQS_MAIN]

GO

/****** Object: ServiceQueue [dbo].[ParallelExecutionRequestQueue] ******/

ALTER

 

QUEUE [dbo].[ParallelExecutionRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[ParallelExecutionActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

)

USE

 

[DQS_MAIN]

GO

/****** Object: ServiceQueue [dbo].[ParallelCalibrationRequestQueue] ******/

ALTER

 

QUEUE [dbo].[ParallelCalibrationRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[ParallelCalibrationActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

)

USE

 

[DQS_MAIN]

GO

/****** Object: ServiceQueue [dbo].[CalibrationRequestQueue] ******/

ALTER

 

QUEUE [dbo].[CalibrationRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[CalibrationActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

)

 

but of No Use

 

 

Many Thanks in advance

 

Ref: DQS Knowledge Discovery

Dear Experts,

 

I have installed CTP3, using DQS i am trying to perform data discovery analysis for SQL Server table .

after i hit the start button i have an error saying "Execution of parallel task failed".

Any assistance is highly appreciated..

 

PS- i have run a query as below as well

USE

 

 

 

GO

/****** Object: ServiceQueue [dbo].[ParallelExecutionRequestQueue] ******/

ALTER

 

 QUEUE [dbo].[ParallelExecutionRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[ParallelExecutionActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

 

USE

 

 

 

GO

/****** Object: ServiceQueue [dbo].[ParallelCalibrationRequestQueue] ******/

ALTER

 

 QUEUE [dbo].[ParallelCalibrationRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[ParallelCalibrationActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

 

USE

 

 

 

GO

/****** Object: ServiceQueue [dbo].[CalibrationRequestQueue] ******/

ALTER

 

 QUEUE [dbo].[CalibrationRequestQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [internal_core].[CalibrationActivator] , MAX_QUEUE_READERS = 1 , EXECUTE AS N'dbo' ), POISON_MESSAGE_HANDLING (STATUS = ON

 

 

but of No Use

 

 

Many Thanks in advance

 

)

 

[DQS_MAIN]

 

)

 

[DQS_MAIN]

 

)

 

[DQS_MAIN]

 

Hello,

 

1. Did you restart SQL Server service after running above script?

2. Could you please send me DQ Server log file zipped? (located at c:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\DQServerLog.DQS_MAIN.log if you use the default instance name) to royaari@microsoft.com?

Thanks,

Ronen

 

 

• Proposed as answer by Céline_Rodríguez Wednesday, October 03, 2012 10:51 AM

Was this thread resolved? Let's mark it answered if so, but I wasn't sure what the resolution was. Thanks! Jason

It works for me!

Hi

Did you eventually get this working?  I am running SQL Server 2012 SP2 CU5 on a 8-way 32GB RAM Server.  It seems DQS is fine running Knowledge Discovery and Matching on smaller datasets eg 100,000 records, but as soon as I ramp it up to 200,000 or 1 million it. Fails with "Execution of Parallel task failed". 

From the DQServerLog.DQS_Main.log.

Microsoft.Ssdqs.Core.Service.Calibration.Parallel.RunParallelCalibrationTaskFlow.Process(IMasterContext context)
---end---
 ---> Microsoft.Ssdqs.Core.Service.Calibration.CalibrationException: Execution of parallel task failed. ---> System.Data.SqlClient.SqlException: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.;

Is there any further scalability or performance tweaks that need to be made?