The query processor could not start the necessary thread resources for parallel query execution.

• Mac1986

  SSCertifiable

  Points: 6216

  More actions

  April 9, 2013 at 11:50 pm

  #292131

  I'm getting below error while running this query.

  The query processor could not start the necessary thread resources for parallel query execution.

  As per my understanding, # of worker threads is automatically decided by SQL Engine. then how can I avoiud this error.

  does changing the Max worker threads help in this case?

  Please suggest.

  DECLARE @OMSSubscriptionIdentifier AS NVARCHAR(50),

  @CTPSubscriptionIdentifier AS NVARCHAR(50),

  @PromotionCodeIdentifier AS NVARCHAR(50),

  @EDWSourceSystemID AS INT = 2780;

  SELECT @OMSSubscriptionIdentifier = dbo.fnIDFIdentifierDefault(), @CTPSubscriptionIdentifier = dbo.fnIDFIdentifierDefault(),

  @PromotionCodeIdentifier = dbo.fnIDFIdentifierDefault();

  SELECT __$Operation, OnlineServiceSubscriptionIdentifier, PromotionCodeIdentifier as OnlineServicePromotionCode, EDWSourceSystemID, EDWIsDeletedFlag, LNKSID FROM (SELECT NULL as __$Operation,

  CASE WHEN SUB.OMSSubscriptionIdentifier <> @OMSSubscriptionIdentifier

  THEN CAST(SUB.OMSSubscriptionIdentifier AS NVARCHAR(50))

  ELSE CAST(SUB.CTPSubscriptionIdentifier AS NVARCHAR(50))

  END AS OnlineServiceSubscriptionIdentifier,

  prom.PromotionCodeIdentifier, @EDWSourceSystemID AS EDWSourceSystemID, CAST(0 AS bit) AS EDWIsDeletedFlag, NULL AS LNKSID,

  CASE WHEN SUB.OMSSubscriptionIdentifier <> @OMSSubscriptionIdentifier

  THEN SUB.OMSSubscriptionIdentifier_OrderBy

  ELSE SUB.CTPSubscriptionIdentifier_OrderBy

  END AS OnlineServiceSubscriptionIdentifier_OrderBy, prom.PromotionCodeIdentifier_OrderBy FROM stg.IDFOnlineServiceSubscriptionPromotion Prom JOIN stg.IDFOnlineServiceSubscription Sub

  ON Prom.SubscriptionKey = Sub.OnlineServiceSubscriptionSourceKey

  WHERE CASE WHEN SUB.OMSSubscriptionIdentifier <> @OMSSubscriptionIdentifier THEN 2770

  ELSE 2780

  END = @EDWSourceSystemID ) A

  WHERE A.PromotionCodeIdentifier <> @PromotionCodeIdentifier

  ORDER BY UPPER(OnlineServiceSubscriptionIdentifier_OrderBy) , UPPER(PromotionCodeIdentifier_OrderBy) ]