Virtual tours

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

[DataConnection.HandleError]:

Query:

WITH AllData AS
(
SELECT *, ROW_NUMBER() OVER (ORDER BY CMS_ORN) AS [CMS_RN] FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY Name) AS [CMS_ORN], ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END) AS [CMS_C], ROW_NUMBER() OVER (PARTITION BY DocumentNodeID ORDER BY CASE WHEN NodeLinkedNodeID IS NULL THEN 1 ELSE 2 END) AS [CMS_DUP] FROM View_CzT_Tour3D_Joined WHERE [NodeSiteID] = @NodeSiteID AND ([Published] = @Published AND (NodeAliasPath LIKE N'/Tourists/travel-info/virtual-tours/%') AND [DocumentCulture] = @DocumentCulture)
)
AS SubData
WHERE [CMS_C] = @CMS_C AND [CMS_DUP] = @CMS_DUP
)
SELECT *, (SELECT COUNT(*) FROM AllData) AS [CMS_TOT] FROM AllData WHERE CMS_RN BETWEEN 271 AND 285 ORDER BY CMS_RN


Caused exception:
The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.