{"id":19,"date":"2011-05-24T09:45:00","date_gmt":"2011-05-24T09:45:00","guid":{"rendered":"http:\/\/greytrix.com\/Blogs\/sageaccpacerp\/?p=19"},"modified":"2024-02-13T09:26:05","modified_gmt":"2024-02-13T09:26:05","slug":"cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/","title":{"rendered":"Can&#8217;t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items"},"content":{"rendered":"<p>While browsing through the Accpac Forum today, we came across an interesting post regarding ACCPAC Collation Method. We had faced the same problem in our development projects and we are sure one of you must have too, so this blog.<br \/>\nIf you are trying to do a DbLoad from a Data Dump that used collation Latin 1 General, and are getting below error because you have duplicate UOM\u2019s per item which violates data integrity of your new DB which has a different collation (case insensitive collation).<\/p>\n<div style=\"text-align: center;\"><a href=\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5610216679879503378\" style=\"cursor: pointer; width: 279px; height: 126px;\" src=\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\" alt=\"\" border=\"0\" \/><\/a><\/div>\n<p>What you can do is before taking the Data Dump, Query the ICUNIT table in SQL to get the list of duplicate UOM, alternatively you can also write a Macro (if you know programming or we are always there \ud83d\ude42 that will figure out the duplicate UOM\u2019s for items. Once you have the list of duplicates, go ahead and delete extra records (make sure you take proper backup of your system first), then take the Data Dump and try to load the data in case insensitive collation environment.<\/p>\n<p>This should solve the problem.<\/p>\n<p>You can use following query to find out duplicate UOM assigned to item.<br \/>\nSELECT ITEMNO,UPPER(UNIT), COUNT(UPPER(ITEMNO)) FROM ICUNIT<br \/>\nGROUP BY ITEMNO,UPPER(UNIT)<br \/>\nHAVING COUNT(ITEMNO) &gt;1<br \/>\n<b>For any queries or more information, please drop us an email at <a title=\"mailto:sage@greytrix.com\" href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. <\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While browsing through the Accpac Forum today, we came across an interesting post regarding ACCPAC Collation Method. We had faced the same problem in our development projects and we are sure one of you must have too, so this blog. If you are trying to do a DbLoad from a Data Dump that used collation\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\">Read More &raquo;<\/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":[2],"tags":[],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Can&#039;t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \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\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Can&#039;t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"While browsing through the Accpac Forum today, we came across an interesting post regarding ACCPAC Collation Method. We had faced the same problem in our development projects and we are sure one of you must have too, so this blog. If you are trying to do a DbLoad from a Data Dump that used collation\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-24T09:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T09:26:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\",\"name\":\"Can't Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\",\"datePublished\":\"2011-05-24T09:45:00+00:00\",\"dateModified\":\"2024-02-13T09:26:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage\",\"url\":\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\",\"contentUrl\":\"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can&#8217;t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Can't Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \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\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/","og_locale":"en_US","og_type":"article","og_title":"Can't Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"While browsing through the Accpac Forum today, we came across an interesting post regarding ACCPAC Collation Method. We had faced the same problem in our development projects and we are sure one of you must have too, so this blog. If you are trying to do a DbLoad from a Data Dump that used collation\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2011-05-24T09:45:00+00:00","article_modified_time":"2024-02-13T09:26:05+00:00","og_image":[{"url":"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/","name":"Can't Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png","datePublished":"2011-05-24T09:45:00+00:00","dateModified":"2024-02-13T09:26:05+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#primaryimage","url":"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png","contentUrl":"http:\/\/2.bp.blogspot.com\/-w5QmLTAzO9k\/Tdt-WJ0wbhI\/AAAAAAAABac\/pRmFOQPV2_I\/s1600\/image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/05\/24\/cant-load-db-on-selecting-different-collation-than-latin-1-general-due-to-duplicate-uom-defined-per-items\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Can&#8217;t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":33646,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19\/revisions\/33646"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}