Trace parcer в D365

[Lankey]

(@P1 bigint,@P2 bigint,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int)
SELECT T1.CHILDPARTY,T1.LEGALENTITYDATAAREAID,T1.PARENTPARTY,T1.RELATIONSHIPTYPEID,
T1.VALIDFROM,T1.VALIDFROMTZID,T1.VALIDTO,T1.VALIDTOTZID,T1.SCHEMAVERSION,T1.RECVERSION,
T1.PARTITION,T1.RECID,T2.CHILDPARENTNAME,T2.CHILDPARTYTYPE,T2.DESCRIPTION,
T2.ISSYMMETRIC,T2.PARENTCHILDNAME,T2.PARENTPARTYTYPE,T2.RELATIONSHIPTYPEID,T2.SYSTEMTYPE,
T2.RECVERSION,T2.PARTITION,T2.RECID,T3.NAME,T3.RECVERSION,T3.RECID,T3.INSTANCERELATIONTYPE,T4.NAME,T4.RECVERSION,T4.RECID,
T4.INSTANCERELATIONTYPE 

FROM DIRPARTYRELATIONSHIP T1 CROSS JOIN DIRRELATIONSHIPTYPETABLE T2 

LEFT OUTER JOIN DIRPARTYTABLE T3 
ON ((T3.PARTITION=5637144576) AND (T1.CHILDPARTY=T3.RECID)) 

LEFT OUTER JOIN DIRPARTYTABLE T4 
ON ((T4.PARTITION=5637144576) AND (T1.PARENTPARTY=T4.RECID)) 
WHERE ((T1.PARTITION=5637144576) AND ((T1.PARENTPARTY=@P1) OR (T1.CHILDPARTY=@P2))) 
AND ((T2.PARTITION=5637144576) AND (((T2.SYSTEMTYPE<@P3) OR (T2.SYSTEMTYPE>@P4)) 
AND (T1.RELATIONSHIPTYPEID=T2.RELATIONSHIPTYPEID))) 

AND 
(EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T5 
WHERE ((T5.PARTITION=5637144576) 
AND (((T5.SYSTEMTYPE<@P5) OR (T5.SYSTEMTYPE>@P6)) AND (T1.CHILDPARTY=T5.OTHERPARTY))))) 
AND 

(EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T6 
WHERE ((T6.PARTITION=5637144576) AND (((T6.SYSTEMTYPE<@P7) OR (T6.SYSTEMTYPE>@P8)) AND (T1.PARENTPARTY=T6.OTHERPARTY))))) 
ORDER BY T1.VALIDFROM DESC OPTION(FAST 8)

В dirPartyTable 84024 записи
В dirPartyRelationship 284046 записи
В dirRelationshipTypeTable 42 записи

В трейспарсере то же самое, но с подставленными значениями

[Lankey]

SELECT T1.CHILDPARTY,
	T1.LEGALENTITYDATAAREAID,
	T1.PARENTPARTY,
	T1.RELATIONSHIPTYPEID,
	T1.VALIDFROM,
	T1.VALIDFROMTZID,
	T1.VALIDTO,
	T1.VALIDTOTZID,
	T1.SCHEMAVERSION,
	T1.RECVERSION,
	T1.PARTITION,
	T1.RECID,
	T2.CHILDPARENTNAME,
	T2.CHILDPARTYTYPE,
	T2.DESCRIPTION,
	T2.ISSYMMETRIC,
	T2.PARENTCHILDNAME,
	T2.PARENTPARTYTYPE,
	T2.RELATIONSHIPTYPEID,
	T2.SYSTEMTYPE,
	T2.RECVERSION,
	T2.PARTITION,
	T2.RECID,
	T3.NAME,
	T3.RECVERSION,
	T3.RECID,
	T3.INSTANCERELATIONTYPE,
	T4.NAME,
	T4.RECVERSION,
	T4.RECID,
	T4.INSTANCERELATIONTYPE 
FROM DIRPARTYRELATIONSHIP T1 CROSS 
JOIN DIRRELATIONSHIPTYPETABLE T2 LEFT 
OUTER 
JOIN DIRPARTYTABLE T3 ON ((T3.PARTITION=5637144576) 
	AND (T1.CHILDPARTY=T3.RECID)) LEFT 
OUTER 
JOIN DIRPARTYTABLE T4 ON ((T4.PARTITION=5637144576) 
	AND (T1.PARENTPARTY=T4.RECID)) 
WHERE ((T1.PARTITION=5637144576) 
	AND ((T1.PARENTPARTY=0) 
	OR (T1.CHILDPARTY=0))) 
	AND ((T2.PARTITION=5637144576) 
	AND (((T2.SYSTEMTYPE<29) 
	OR (T2.SYSTEMTYPE>40)) 
	AND (T1.RELATIONSHIPTYPEID=T2.RELATIONSHIPTYPEID))) 
	AND (
EXISTS (
SELECT 'X' 
FROM DIRPARTYRELATIONSHIPSUNIONVIEW T5 
WHERE ((T5.PARTITION=5637144576) 
	AND (((T5.SYSTEMTYPE<29) 
	OR (T5.SYSTEMTYPE>40)) 
	AND (T1.CHILDPARTY=T5.OTHERPARTY))))) 
	AND (
EXISTS (
SELECT 'X' 
FROM DIRPARTYRELATIONSHIPSUNIONVIEW T6 
WHERE ((T6.PARTITION=5637144576) 
	AND (((T6.SYSTEMTYPE<29) 
	OR (T6.SYSTEMTYPE>40)) 
	AND (T1.PARENTPARTY=T6.OTHERPARTY))))) 
	ORDER BY T1.VALIDFROM DESC OPTION(FAST 9)

Это из трейспарсера. В SQL Server Management Studio возвращает тут же 0 записей.

[Lankey]

( а из формы GlobalAddressBook->New около 30 минут висит, а потом выдается сообщение, что запись в DirPartyRelationship не может быть выбрана )