Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors


This week’s Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors. 

1. Find out what user the eConnect service is running under. Press the Windows + R key on your keyboard to bring up the Run command. Type in “services.msc” and hit enter. This will open the services window. Find the “eConnect for Microsoft Dynamics GP 20XX Integration Service”

tt-sql-trace-1
2. Once you find the service, right click on it, go to Properties, and go to the Log On tab.  Write down the user that is used there. In my screenshot the user is eonedemo\Administrator:

tt-sql-trace-2
3. Open SQL server management studio and connect to the SQL server that is storing your GP databases. Once in management studio, go to Tools – SQL Server Profiler. This will open the profiler window. It should automatically open a Trace Properties window. If it does not, just go to File – New Trace.  

4. In the Trace Properties window, change to the Events Selection tab and uncheck the top three events. (see screenshot)

tt-sql-trace-3
5. Click on the Column Filters button (shown above) and highlight Login Name. Then click on the Like button and put in the name you found in step 2. In my case it was eonedemo\administrator


tt-sql-trace-4
6. Click OK and then click Run on the Trace Window. 

7. Go into SmartConnect and run the map you are getting the error on. Once you get the error, stop the trace by clicking on the stop button at the top of the window. Then go to Edit – Find and type in the procedure name you are trying to trace, in this case it’s the taUpdateCreateCustomerRcd procedure. Once you find where the error occurred copy the data from the bottom part of the window. 

tt-sql-trace-5
8. Run the query in Query Analyzer and see what result you get. In my case I got an error 251, which is an eConnect error code.

tt-sql-trace-6
9. To find the eConnect error, run the following query. Select * from Dynamics..taErrorCode where ErrorCode=XXX. In my case, the error was 251, so I replaced XXX with 251.

tt-sql-trace-7

    10. My error is telling me that the Customer ID already exists and the Update If Exists flag is set to not allow updates.

    If you have further questions regarding eConnect errors please search our Knowledge Base articles or email support@eonesolutions.com for more information. 

    1 Comment

    1. brent olsen on August 30, 2018 at 1:41 pm

      Note that if you are debugging a task it may have a different sql login which will have to be added to the Like statement in the Column filter to get the task execution profile.

    Leave a Comment





    RECENT POSTS


    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
    New Webinar: Getting Started with Matrix Reporting in Popdock

    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.