none
[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
    INNER JOIN (
    SELECT DISTINCT workflowId,
    min(id) AS id
    FROM MyTable
    GROUP BY workflowId
    ) AS b
    ON a.workflowId = b.workflowId
    AND a.id = b.id
    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 - http://msdn.microsoft.com/en-us/library/ms180800.aspx

    Regards, Soren Granfeldt
    blog is at http://blog.goverco.com | facebook https://www.facebook.com/TheIdentityManagementExplorer | twitter at https://twitter.com/#!/MrGranfeldt

    Friday, December 19, 2014 9:45 AM