{"id":447,"date":"2018-09-03T15:57:21","date_gmt":"2018-09-03T14:57:21","guid":{"rendered":"http:\/\/blogs.kent.ac.uk\/unseenit\/?p=447"},"modified":"2018-09-04T08:16:12","modified_gmt":"2018-09-04T07:16:12","slug":"fim-modify-could-not-get-required-interface","status":"publish","type":"post","link":"https:\/\/blogs.kent.ac.uk\/unseenit\/fim-modify-could-not-get-required-interface\/","title":{"rendered":"FIM &#8220;[Modify] Could not get required interface&#8221;"},"content":{"rendered":"<p>To save you the hassle when searching for the answer you seek, please be aware that, for reasons unknown, FIM&#8217;s (or MIM&#8217;s) SQL Server connector is unable to write to a Multivalue Table when the base &#8220;table&#8221; is actually a read-only View.<\/p>\n<p>We had a pre-existing SQL VIEW from which I was merrily pulling data. There was a new requirement to send some multi-valued data back to the SQL Server so we created a multi-value table to sit next to the existing VIEW. We thought we were so clever\u2026<\/p>\n<p>Whenever an Export tried to insert a row into the Multivalue table it received the following error (cd-error):<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-450\" src=\"http:\/\/blogs.kent.ac.uk\/unseenit\/files\/2018\/09\/image.png\" alt=\"\" width=\"665\" height=\"162\" srcset=\"https:\/\/blogs.kent.ac.uk\/unseenit\/files\/2018\/09\/image.png 665w, https:\/\/blogs.kent.ac.uk\/unseenit\/files\/2018\/09\/image-300x73.png 300w\" sizes=\"(max-width: 665px) 100vw, 665px\" \/><\/p>\n<blockquote><p>Error information<\/p>\n<p>Connected data source error code: 0x80230808<\/p>\n<p>Connected data source error: [Modify] Could not get required interface<\/p><\/blockquote>\n<p>This appears to be some sort of bug in the SQL Server connector agent and the general advise appears to be to either convert the base view into a table or, if that&#8217;s not possible, configure up two separate MAs (one for pulling and one for pushing).<\/p>\n<p>With thanks to Daniel at\u00a0<a href=\"https:\/\/identityexperts.co.uk\/\">Identity Experts<\/a>\u00a0for the pointers.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To save you the hassle when searching for the answer you seek, please be aware that, for reasons unknown, FIM&#8217;s (or MIM&#8217;s) SQL Server connector &hellip; <a href=\"https:\/\/blogs.kent.ac.uk\/unseenit\/fim-modify-could-not-get-required-interface\/\">Read&nbsp;more<\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[28943,1],"tags":[197214,196,28944,28945,197212,197211,28985],"_links":{"self":[{"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/posts\/447"}],"collection":[{"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/comments?post=447"}],"version-history":[{"count":5,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/posts\/447\/revisions"}],"predecessor-version":[{"id":454,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/posts\/447\/revisions\/454"}],"wp:attachment":[{"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/media?parent=447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/categories?post=447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/unseenit\/wp-json\/wp\/v2\/tags?post=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}