Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Change without Change, really isn’t very good


In the past few weeks we have seen a few of our customers experience some interesting behavior after upgrading their Microsoft Dynamics GP to a new release. In SmartConnect they had a change data source on one of the Dynamics GP tables that was running on a schedule. Interestingly, the map never failed, but it never sent any updates after the upgrade. The reason…there was no longer a trigger to populate the records that needed to be changed.

Where did the trigger go? The answer is pretty simple actually. When Dynamics GP adds new columns to the table structure, it actually does four things:

       1. Copies all the current records in that table to temp table.
       2. Drops the table (and coincidentally, any triggers).
       3. Recreates the table with the new columns.
       4. Copies in the old data from the temp table into the new table.

The main reason for doing this is to ensure that the unique ID for each record is at the end of the table (which is a perfectly good reason) but the consequences of losing all triggers can wreak havoc on other applications using those triggers.

Fortunately, SmartConnect can fix this issue very easily. Simply, open up any affected map and hit the Save button. This will recreate the trigger on the table and now your changes will go through successfully. As many people may be upgrading to newer versions of Dynamics GP 2015, just be aware if you have change data sources.

Have some questions? Feel free to comment below!

Leave a Comment





RECENT POSTS


Meet the eOne Team at BC Tech Days 2023
Tech Tuesday: Building My First Matrix Report
Overcoming the Top Challenges of Zendesk Integration
Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.