Synchronization editor: Preparing report stuck at the end

mekindad over 2 years ago

I want to see sync log but it is always stuck at the end of 212 pages.

Using 25% of CPU and after some hours no result.

This happens every time with a particular workflow

suggestions?

Parents

0 Niels de Groot over 2 years ago

You could also run the following query.

SELECT m.MessageContext
	,m.MessageString
	,m.MessageType
	,m.SequenceNumber
	,j.CreationTime
	,j.ProjectionContext
	,j.ProjectionConfigDisplay
	,j.SystemVariableSetDisplay
	,j.DisplayNameQualified
FROM DPRJournalMessage m
LEFT OUTER JOIN (
	SELECT j.UID_DPRJournal
		,j.CreationTime
		,j.ProjectionContext
		,j.ProjectionConfigDisplay
		,j.SystemVariableSetDisplay
		,c.DisplayNameQualified
	FROM DPRJournal j
	JOIN DPRProjectionConfig c ON j.UID_DPRProjectionConfig = c.UID_DPRProjectionConfig
	) AS j ON m.UID_DPRJournal = j.UID_DPRJournal
WHERE MessageType <> N'I'
ORDER BY j.CreationTime DESC

Reply

0 Niels de Groot over 2 years ago

You could also run the following query.

SELECT m.MessageContext
	,m.MessageString
	,m.MessageType
	,m.SequenceNumber
	,j.CreationTime
	,j.ProjectionContext
	,j.ProjectionConfigDisplay
	,j.SystemVariableSetDisplay
	,j.DisplayNameQualified
FROM DPRJournalMessage m
LEFT OUTER JOIN (
	SELECT j.UID_DPRJournal
		,j.CreationTime
		,j.ProjectionContext
		,j.ProjectionConfigDisplay
		,j.SystemVariableSetDisplay
		,c.DisplayNameQualified
	FROM DPRJournal j
	JOIN DPRProjectionConfig c ON j.UID_DPRProjectionConfig = c.UID_DPRProjectionConfig
	) AS j ON m.UID_DPRJournal = j.UID_DPRJournal
WHERE MessageType <> N'I'
ORDER BY j.CreationTime DESC

Children

No Data