[Modify] Could not get required interface RRS feed

  • Question

  • Hi all,

    We have created SQL MA that connects to view.

    View definition is something like this:

    SELECT a.*
    FROM dbo.MyTable a
    SELECT DISTINCT workflowId,
    min(id) AS id
    FROM MyTable
    GROUP BY workflowId
    ) AS b
    ON a.workflowId = b.workflowId
    AND =
    AND (
    (a.STATUS = 'R')
    OR (a.STATUS = 'P')

    When we try to run export profile on that MA we get cd-error [Modify] Could not get required interface.

    Running the same update in SQL management studio works.

    Does anyone knows what is causing this behavior?

    Thank You.

    Wednesday, December 17, 2014 10:26 PM

All replies

  • I'm pretty sure it is because your SQL view is not updateable. You can read more about this here -

    Regards, Soren Granfeldt
    blog is at | facebook | twitter at!/MrGranfeldt

    Friday, December 19, 2014 9:45 AM