All News

Filter by:

[Error loading the control 'CUNY_GC_NewsRepeater', check event log for more details]

[DataConnection.HandleError]:

Query:

WITH AllData AS
(
SELECT *, ROW_NUMBER() OVER (ORDER BY NewsReleaseDate DESC) AS CMS_RN FROM View_CUNY_GC_News_Joined WHERE NodeSiteID = @NodeSiteID AND (((((DocumentID IN ( SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN (649, 650, 651, 652, 653, 655, 656, 657, 658, 660, 661, 662, 663, 664, 690, 701, 713, 714, 715, 716, 720, 722, 723, 880, 881)))) AND ((DocumentID IN ( SELECT DocumentID FROM CMS_DocumentCategory WHERE...

...FROM CMS_DocumentCategory WHERE CategoryID IN (880))))) AND ((DocumentID IN ( SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN (880))))) AND (Published = @Published AND (NodeAliasPath LIKE N'/Page-Elements/%') AND DocumentCulture = @DocumentCulture)
)
SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 10 ORDER BY CMS_RN


Caused exception:
There is insufficient system memory in resource pool 'default' to run this query.