{"id":8079,"date":"2014-06-18T06:38:14","date_gmt":"2014-06-18T06:38:14","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=8079"},"modified":"2014-06-18T06:38:14","modified_gmt":"2014-06-18T06:38:14","slug":"rebalancing-complex-territory-structures","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/","title":{"rendered":"Rebalancing complex territory structures"},"content":{"rendered":"

When it comes to Territories, implementation complexity increases. When it comes to migration of territories and rebalancing the territory structure, it becomes more complex. I have already discussed on this blog how you can swiftly carry our Territory migration. See below link.
\nRelated Post:<\/strong><\/em><\/span> Territory Migration <\/a>
\nNow I will discuss how to handle rebalancing of complex territory structure. Here by I am sharing my experience with you where we came across a complex and unmanaged territory structure where 1400+ territories were created in Sage CRM and never gone under Territory Rebalancing activity. Customer came up reporting that they are not able to create, move or merge territories anymore, hence our first step was to run Territory Rebalancing but it started giving errors in the process.
\nGoing by the Sage CRM guide books; it is clearly mentioned that \u201cMerging and Moving a territory requires rebalancing of the Territory tree structure\u201d also there are instructions that the standard capacity for a territory structure is 16 “child territories” on each territory, and five territory levels deep. A complex territory structure may require the expansion of the standard capacity.
\nSince it was not able to rebalance the territory structure hence we started troubleshooting through log files and after some deep excavation and series of troubleshooting we came up with steps which helped us resolving this issue, I hope it will help\/give some direction to you in case you are facing similar issues:
\nStep1.\u00a0\u00a0 Backup Sage CRM Database.
\nStep2. \u00a0 Check! No record should be lying without territory in any entity involved in merging\/moving activity. If you find any record with null value, update it with worldwide or respective territory value.
\nStep3. \u00a0 Restart both DB and Application server.
\nStep4.\u00a0\u00a0 Disable all triggers before merging. (In our case there were various triggers created on different entities).
\nStep5. \u00a0 Stop CRM services and lock the system before rebalancing the territories.
\nStep6. \u00a0 Run territory rebalancing.
\nStep7. \u00a0 Unlock CRM and Refresh metadata.
\nStep8. \u00a0 Restart both servers.
\nStep9. \u00a0 Stop CRM services and lock the system before moving\/merging the territories.
\nStep10. Now we were able to Merge Territories without any error.
\nStep11. Enable all triggers, Reset IIS and Run CRM services.
\nNote* Do not logout CRM admin account while CRM is locked; unlock CRM before logging out from CRM.
\nAlso Read:<\/strong><\/em><\/span>
\n1) Re-assignment within same team\/territory<\/a>
\n2) User\u2019s Home Territory and Assigned to rights in CRM<\/a>
\n3) Setting a Territory field by default to Worldwide<\/a>
\n4) Mass Update and Territory Update In Sage CRM<\/a>
\n5) Territory Profiles Issue in CRM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

When it comes to Territories, implementation complexity increases. When it comes to migration of territories and rebalancing the territory structure, it becomes more complex. I have already discussed on this blog how you can swiftly carry our Territory migration. See below link. Related Post: Territory Migration Now I will discuss how to handle rebalancing of\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[245,309,332,400],"tags":[1621,1879,2010,2430],"class_list":["post-8079","post","type-post","status-publish","format-standard","hentry","category-migration-sage-crm","category-rebalancing","category-sage-crm","category-territory-sage-crm","tag-migration","tag-rebalancing","tag-sage-crm","tag-territory"],"yoast_head":"\nRebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"When it comes to Territories, implementation complexity increases. When it comes to migration of territories and rebalancing the territory structure, it becomes more complex. I have already discussed on this blog how you can swiftly carry our Territory migration. See below link. Related Post: Territory Migration Now I will discuss how to handle rebalancing of\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-18T06:38:14+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/\",\"name\":\"Rebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2014-06-18T06:38:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rebalancing complex territory structures\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/","og_locale":"en_US","og_type":"article","og_title":"Rebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components","og_description":"When it comes to Territories, implementation complexity increases. When it comes to migration of territories and rebalancing the territory structure, it becomes more complex. I have already discussed on this blog how you can swiftly carry our Territory migration. See below link. Related Post: Territory Migration Now I will discuss how to handle rebalancing of\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-06-18T06:38:14+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/","name":"Rebalancing complex territory structures - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2014-06-18T06:38:14+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/06\/18\/rebalancing-complex-territory-structures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Rebalancing complex territory structures"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=8079"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8079\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=8079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=8079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=8079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}