{"id":38,"date":"2018-09-05T05:43:38","date_gmt":"2018-09-05T05:43:38","guid":{"rendered":"https:\/\/www.aladan.net\/MIMicry\/?p=38"},"modified":"2018-09-05T05:44:55","modified_gmt":"2018-09-05T05:44:55","slug":"hints-when-performing-bulk-updates-using-lithnetrma","status":"publish","type":"post","link":"https:\/\/www.aladan.net\/MIMicry\/2018\/09\/05\/hints-when-performing-bulk-updates-using-lithnetrma\/","title":{"rendered":"Hints when performing bulk updates using LithnetRMA"},"content":{"rendered":"

When you have a lot of records to update in the MIM Service, LithnetRMA is your friend.\u00a0 And I mean your really good <\/em>friend.<\/p>\n

But sometimes things don’t go all your way.\u00a0 If you have a lot<\/em> of objects to update, you might see this error after a few thousand have been processed:<\/p>\n

\"\"<\/p>\n

I suspect there’s an internal pointer (SQL maybe?) that loses its way after a large block of records have been deleted.\u00a0 Sadly, even Search-ResourcesPaged has the same problem:<\/p>\n

\"\"<\/p>\n

So you will need to put a ring on it.\u00a0 Well, a loop anyway:<\/p>\n

\"\"<\/p>\n

This sort of thing typically gives me a throughput of about 1 request per second, which isn’t stellar.\u00a0 Fortunately, Powershell ISE has a File -> New Powershell Window menu option, so you can open up a few windows and set yourself up with some hacky parallelisation:<\/p>\n

\"\"<\/p>\n

Take particularly note of the XPath here that processes Ident values starting with ‘a’, ‘b’, ‘c’ and ‘d’.\u00a0 In your second ISE tab, paste in the script and change it to process ‘e’, ‘f’, ‘g’ and ‘h’, and so on.<\/p>\n

I find that I get good performance improvement up to around 5-6 windows running in parallel.\u00a0 Beyond that I don’t see a lot of request speed-up, but your mileage may vary!<\/p>\n

Note: in this post’s screen snapshots “Ident” is a custom attribute that was being deprecated in the customer’s solution.\u00a0 I wanted to clear all the values currently in the MIM Service, in order to then let me remove the binding.\u00a0 Usually you’d use AccountName to divide objects up for parallel scripting, regardless of what attributes you are updating.<\/p>\n","protected":false},"excerpt":{"rendered":"

When you have a lot of records to update in the MIM Service, LithnetRMA is your friend.\u00a0 And I mean your really good friend. But sometimes things don’t go all your way.\u00a0 If you have a lot of objects to update, you might see this error after a few thousand have been processed: I suspect…<\/span><\/p>\n

Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6,12,8],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-good","category-howto","category-lithnet","category-mimservice"],"_links":{"self":[{"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":3,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":45,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/posts\/38\/revisions\/45"}],"wp:attachment":[{"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aladan.net\/MIMicry\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}