Hi
In one of our solution(Solution without Swift and Rapido) we use Ecom Catalog with Product List template for XML feed
that work fine before, but after upgrade to 9.14.2 or higher
We got this kind of error
If I change Content to Application/JSON
Original Error text
SELECT PagedProducts.ProductSelectionTotalCount, ProductOutputs.* FROM ( SELECT ProductResults.ProductAutoID, ProductResults.ProductSelectionTotalCount, ProductResults.RowNumber FROM ( SELECT EcomProducts.ProductAutoID, COUNT(EcomProducts.ProductID) OVER () AS ProductSelectionTotalCount, ROW_NUMBER() OVER(ORDER BY ProductName COLLATE Danish_Norwegian_CI_AS ASC, ProductID ASC) AS RowNumber FROM ( SELECT DISTINCT AssortedGroupProductSelections.GroupProductRelationProductID FROM ( SELECT DISTINCT GroupProductSelections.GroupProductRelationProductID , AssortmentItems.AssortmentItemLanguageID FROM ( SELECT EcomGroupProductRelation.GroupProductRelationProductID FROM EcomGroupProductRelation WHERE ( EcomGroupProductRelation.GroupProductRelationGroupID IN ( @p0 , @p1 , @p2 , @p3 , @p4 , @p5 , @p6 , @p7 , @p8 , @p9 , @p10 , @p11 , @p12 , @p13 , @p14 , @p15 , @p16 , @p17 , @p18 , @p19 , @p20 , @p21 , @p22 , @p23 , @p24 , @p25 , @p26 , @p27 , @p28 , @p29 , @p30 , @p31 , @p32 , @p33 , @p34 , @p35 , @p36 , @p37 , @p38 , @p39 , @p40 , @p41 , @p42 , @p43 , @p44 , @p45 , @p46 , @p47 , @p48 , @p49 , @p50 ) ) GROUP BY EcomGroupProductRelation.GroupProductRelationProductID ) AS GroupProductSelections LEFT OUTER JOIN EcomAssortmentItems WITH (NOLOCK) AS AssortmentItems ON ( AssortmentItems.AssortmentItemProductID = GroupProductSelections.GroupProductRelationProductID ) LEFT OUTER JOIN EcomAssortments AS Assortments ON ( Assortments.AssortmentID = AssortmentItems.AssortmentItemAssortmentID ) WHERE ( ( AssortmentItems.AssortmentItemAssortmentID IN ( @p51,@p52,@p53,@p54,@p55 ) OR ( AssortmentItems.AssortmentItemAssortmentID IN ( @p56,@p57,@p58 ) AND AssortmentItems.AssortmentItemProductID NOT IN (SELECT AssortmentItemProductID FROM EcomAssortmentItems WITH (NOLOCK) WHERE AssortmentItemAssortmentID IN (@p51,@p59,@p52,@p60,@p53,@p61,@p62,@p63,@p64,@p65,@p66,@p67,@p68,@p69,@p70,@p71,@p72,@p73,@p74,@p75,@p54,@p55,@p76,@p77,@p78,@p79,@p80,@p81,@p82,@p83,@p84,@p85,@p86,@p87,@p88,@p89,@p90,@p91,@p92,@p93,@p94,@p95,@p96,@p97,@p98,@p99,@p100,@p101,@p102,@p103,@p104,@p105,@p106,@p107,@p108,@p109,@p110)) ) ) OR ( AssortmentItems.AssortmentItemAssortmentID IS NULL ) OR ( ( COALESCE( AssortmentItems.AssortmentItemProductVariantID, '' ) <> '' ) AND ( NOT EXISTS( SELECT MasterAssortmentItems.AssortmentItemAutoID FROM EcomAssortmentItems WITH (NOLOCK) AS MasterAssortmentItems WHERE ( MasterAssortmentItems.AssortmentItemProductID = AssortmentItems.AssortmentItemProductID ) AND ( MasterAssortmentItems.AssortmentItemLanguageID = AssortmentItems.AssortmentItemLanguageID ) AND ( COALESCE( MasterAssortmentItems.AssortmentItemProductVariantID, '' ) = '' ) ) ) AND ( EXISTS( SELECT VariantProducts.ProductAutoID FROM EcomProducts AS VariantProducts WHERE ( VariantProducts.ProductID = AssortmentItems.AssortmentItemProductID ) AND ( VariantProducts.ProductLanguageID = AssortmentItems.AssortmentItemLanguageID ) AND ( COALESCE( VariantProducts.ProductVariantID, '' ) <> '' ) AND ( NOT EXISTS ( SELECT VariantAssortmentItems.AssortmentItemProductVariantID FROM EcomAssortmentItems WITH (NOLOCK) AS VariantAssortmentItems WHERE ( VariantAssortmentItems.AssortmentItemProductID = AssortmentItems.AssortmentItemProductID ) AND ( VariantAssortmentItems.AssortmentItemLanguageID = AssortmentItems.AssortmentItemLanguageID ) AND ( COALESCE( VariantAssortmentItems.AssortmentItemProductVariantID, '' ) = COALESCE( VariantProducts.ProductVariantID, '' ) ) ) ) ) ) ) ) ) AS AssortedGroupProductSelections ) AS ProductSelections INNER JOIN EcomProducts ON ( EcomProducts.ProductID = ProductSelections.GroupProductRelationProductID ) AND ( EcomProducts.ProductLanguageID = @p111 ) AND ( EcomProducts.ProductActive = @p112 ) AND ( ( ISNULL( EcomProducts.ProductPeriodId, '' ) = '' ) OR ( EcomProducts.ProductPeriodId IN ( SELECT EcomPeriods.PeriodID FROM EcomPeriods WHERE ( ( COALESCE( EcomPeriods.PeriodShowProductsAfterExpiration, 0 ) = @p112 ) OR ( ( COALESCE( EcomPeriods.PeriodActive, 1 ) = @p112 ) AND ( ( COALESCE( EcomPeriods.PeriodAlways, 0 ) = @p112 ) OR ( ( COALESCE( EcomPeriods.PeriodEndDate, @p113 ) >= @p113 ) AND ( COALESCE( EcomPeriods.PeriodStartDate, @p113 ) <= @p113 ) ) ) ) ) AND ( EcomPeriods.PeriodHidden IN ( 1, @p112 ) ) ) ) ) AND ( COALESCE( EcomProducts.ProductVariantID, '' ) = '') AND ( ISNULL(EcomProducts.ProductHidden, 0) <> @p112 ) ) AS ProductResults WHERE ( ProductResults.RowNumber BETWEEN @p114 And @p115 ) ) As PagedProducts INNER JOIN EcomProducts As ProductOutputs On ( ProductOutputs.ProductAutoID = PagedProducts.ProductAutoID ) ORDER BY PagedProducts.RowNumber ASC
We create new Feed in PIM, that work fine
