ECMLink request load database with no reason Functions

Bolotny_Andrey

 Hi experts,

On production database we catch request:

WITH cte(id, aid) AS
(SELECT dta.DataID, dta.AncestorID
FROM DTreeAncestors dta
WHERE ((dta.DataID in (:"SYS_B_0"))))
SELECT id as FilterID, aid
from cte INNER JOIN OTSAPXECM_WKSP_LINKS lks on aid = lks.DATAID UNION
SELECT id as FilterID, aid
from cte INNER JOIN OTSAPXECM_WKSP_NOLINK lks on aid = lks.DATAID

Looks like request belong to ECMLink functionality.
Who can describe purpose of this request?
There are no rows in request results. How we can disable it? We not use ECMLink functionality now. The OTSAPXECM_WKSP_LINKS have no data now.
This request executed often and database load for nothing.

Thanks a lot for any help

Reinhard_Loch

Hi Andrey,

this behavior is by design. Extended ECM implements it's own licensing model and tracks each access to a Business Workspace. The query is needed to check if the currently browsed item is located within a Business Workspace and happens in the FilterNodesCallback which is triggered quite often. This can only be switched off by uninstalling the ECMLink module.

Regards,

Reinhard