{"id":5240,"date":"2015-12-21T11:55:56","date_gmt":"2015-12-21T11:55:56","guid":{"rendered":"http:\/\/www.qgate.co.uk\/knowledge\/?p=5240"},"modified":"2025-06-04T10:22:19","modified_gmt":"2025-06-04T10:22:19","slug":"paribus-discovery-infor-crm-trigger-issues","status":"publish","type":"post","link":"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/","title":{"rendered":"Paribus 365&#x2122; Data Cleansing \u2013 Infor CRM SLX Trigger Issues"},"content":{"rendered":"<p><!----------------------------- Article Header Start - DO NOT REMOVE ------------------------------><\/p>\n<table class=\"article-header-table\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-header\">\n<td style=\"border-top: 5px solid currentColor;\" valign=\"top\" width=\"25%\"><b>Summary:<\/b><\/td>\n<td style=\"border-top: 1px solid currentColor;\" valign=\"top\">Infor CRM v8.1 introduced numerous SQL triggers to facilitate various integrations.<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td valign=\"top\"><b>Article Type:<\/b><\/td>\n<td valign=\"top\">Troubleshooting<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 3px; border-bottom-style: solid;\" valign=\"top\"><strong>Related Product(s):<\/strong><\/td>\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 1px; border-bottom-style: solid;\" valign=\"top\">This article relates to the following products:<p><\/p>\n<ul>\n<li>Paribus 365&#x2122; Data Cleansing<\/li>\n<li>Infor CRM SLX (Saleslogix)&nbsp;<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Header End ---------------------------------------><\/p>\n<h2><strong>Introduction<\/strong><\/h2>\n<p>Infor CRM v8.1 introduced numerous SQL triggers to facilitate various integrations.<\/p>\n<p>An issue has been found with the CONTACT_INTEGRATION_INSERT trigger, which is utilized by all of the Infor CRM integrations and can cause a Paribus 365 contact merge to fail. The issue specifically relates to the <strong>ERP integration<\/strong> and affects the ERPPHONENUMBER and ERPEMAILADDRESS tables.<\/p>\n<p>To better explain the issue, some information on the Paribus 365 merge process.<\/p>\n<p>The Paribus 365 merge<strong>&nbsp;<\/strong>engine does a lot of \u2018clever\u2019 data manipulation of Infor CRM data to ensure and safeguard a full synchronization (Slx sync) of the Accounts\/Contacts that we merge and consolidate. To this end we don\u2019t just move Accounts and Contacts (as this would inherently break the sync), we perform what we call a \u201cDeep Copy\u201d \u2013 That is we delete the Account\/Contact and then re-insert it (with the same AccountID\/ContactID but updated relationship and with the correct target SyncID.<\/p>\n<h2><strong>The issue<\/strong><\/h2>\n<p>Due to the nature of the above merge process, the merged record is re-inserted and causes the CONTACT_INTEGRATION_INSERT trigger to fire. The trigger attempts to insert the record into the ERPPHONENUMBER and ERPEMAILADDRESS tables but, as the records already exists, it fails due to unique indexes on the ERPPHONENUMBERID and ERPEMAILADDRESSID fields.<\/p>\n<p>This is <strong>ONLY<\/strong> the case if the Infor CRM system started life on <strong>7.5.4<\/strong> or earlier.<\/p>\n<p>In Infor CRM systems that started life on <strong>v8 or above,<\/strong> the indexes have been changed to be <strong>non-unique. <\/strong>Therefore, in these systems the merge will work without issue. However, you will have duplicate records in the ERPPHONENUMBER and ERPEMAILADDRESS tables.<\/p>\n<p>These tables should not contain duplicate records and the Infor CRM documentation states, \u201c<em>while these tables do not have a field defined as a primary key, the ERPPHONENUMBERID and ERPEMAILADDRESSID fields should be unique and considered primary keys<\/em>\u201d.<\/p>\n<h2><strong>Resolution<\/strong><\/h2>\n<p>For this particular issue only, if you are NOT using ANY of the Infor CRM integrations then you can safely disable the CONTACT_INTEGRATION_INSERT trigger and this will prevent both scenarios above.<\/p>\n<p>If you are using ANY of the integrations and you encounter an issue with a Paribus contact merge, <em>Please contact your Infor CRM business partner for further advice.<\/em><\/p>\n<p>It is widely recommended if you are NOT using any of the Infor CRM integrations then the SQL triggers should all be disabled.<\/p>\n<p><em>This article will be updated pending further information from Infor.<\/em><\/p>\n<p><!----------------------------- Article Footer Start - DO NOT REMOVE ------------------------------><\/p>\n<table style=\"border-bottom: none;\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"width: 25%; border-top-color: currentColor; border-top-width: 3px; border-top-style: solid;\" valign=\"top\"><strong>&nbsp;Related Resources:<\/strong><\/td>\n<td style=\"width: 75%; border-top-color: currentColor; border-top-width: 1px; border-top-style: solid;\" valign=\"top\">\n<ul>\n<li>None<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\"><strong><span style=\"color: #444444;\"><span style=\"line-height: 14px; font-size: 14px;\">Further Information:<\/span><\/span><\/strong><\/td>\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\">\n<ul>\n<li><a href=\"https:\/\/www.paribuscloud.com\/help\/\">Paribus 365 Help Center<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/faqs\/\">Paribus 365 Data Cleansing FAQs<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/troubleshooting\/\">Paribus 365 Data Cleansing Troubleshooting<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/how-to-guides\/\">Paribus 365 Data Cleansing How-To Guides<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/technical-articles\/\">Paribus 365 Data Cleansing Technical Articles<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/documents\/\">Paribus 365 Data Cleansing Document Library<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Footer End ---------------------------------------><\/p>\n\n\n<p><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-5240\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-5240\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Summary: Infor CRM v8.1 introduced numerous SQL triggers to facilitate various integrations. Article Type: Troubleshooting Related Product(s): This article relates to the following products: Paribus 365&#x2122; Data Cleansing Infor CRM SLX (Saleslogix)&nbsp; Introduction Infor CRM v8.1 introduced numerous SQL triggers to facilitate various integrations. An issue has been found with the CONTACT_INTEGRATION_INSERT trigger, which is &hellip; <a href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Paribus 365&#x2122; Data Cleansing \u2013 Infor CRM SLX Trigger Issues<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-5240\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-5240\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[134,1956,13,23,25],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.1.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"What to do with the trigger issues relating to the ERP integration and effects the ERPPHONENUMBER and ERPEMAILADDRESS tables\" \/>\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.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Paribus 365\u2122 Data Cleansing \u2013 Infor CRM SLX Trigger Issues\" \/>\n<meta property=\"og:description\" content=\"What to do with the trigger issues relating to the ERP integration and effects the ERPPHONENUMBER and ERPEMAILADDRESS tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\" \/>\n<meta property=\"og:site_name\" content=\"The Paribus Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-21T11:55:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T10:22:19+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@ParibusDedupe\" \/>\n<meta name=\"twitter:site\" content=\"@ParibusDedupe\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\",\"name\":\"QGate Software Ltd\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/qgate\/\",\"https:\/\/www.youtube.com\/channel\/UCZBmNdUEnRL9RH0ah3US99g\",\"https:\/\/twitter.com\/ParibusDedupe\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/05\/QGate_logo_4c.png\",\"width\":1808,\"height\":700,\"caption\":\"QGate Software Ltd\"},\"image\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"name\":\"The Paribus Help Center\",\"description\":\"Customer Self Help, Paribus events and product news\",\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.paribuscloud.com\/help\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/#webpage\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\",\"name\":\"Paribus 365\\u2122 Data Cleansing \\u2013 Infor CRM SLX Trigger Issues\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\"},\"datePublished\":\"2015-12-21T11:55:56+00:00\",\"dateModified\":\"2025-06-04T10:22:19+00:00\",\"description\":\"What to do with the trigger issues relating to the ERP integration and effects the ERPPHONENUMBER and ERPEMAILADDRESS tables\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\"},\"headline\":\"Paribus 365&#x2122; Data Cleansing \\u2013 Infor CRM SLX Trigger Issues\",\"datePublished\":\"2015-12-21T11:55:56+00:00\",\"dateModified\":\"2025-06-04T10:22:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-infor-crm-trigger-issues\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"articleSection\":\"Infor CRM,Paribus 365,Paribus Discovery,Technical Article,Troubleshooting\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\",\"name\":\"Paribus 365 Team\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/00c6cd7408c3531da38599fd6bccaa5c?s=96&d=mm&r=g\",\"caption\":\"Paribus 365 Team\"},\"sameAs\":[\"http:\/\/www.Paribus365.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8hT1P-1mw","_links":{"self":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/5240"}],"collection":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/comments?post=5240"}],"version-history":[{"count":18,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/5240\/revisions"}],"predecessor-version":[{"id":24200,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/5240\/revisions\/24200"}],"wp:attachment":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/media?parent=5240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/categories?post=5240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/tags?post=5240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}