Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Integration Manager 2010 SP 2 Crashes when Selecting Excel Data Source

Posted on by 2,281

Has anyone had any success using an Excel data source with Integration Manager 2010?

I am trying to create a simple integration with an XLSX data source.  I can create the DSN for the Excel file in IM (using the ACE driver v14.00), but as soon as I select the Data Source in the Simple or Advanced ODBC Source, Integration Manager crashes.

I saw this old 2008 thread and Mariano's post regarding a workaround with IM 10, but that doesn't seem to work with IM 2010.

I've tested on two machines and get the same results on both.

 http://www.archivum.info/microsoft.public.greatplains/2008-04/01335/Re:_boosting_connectivity_on_GP_workstations

http://dynamicsgpblogster.wordpress.com/2008/05/24/integration-manager-v9-0-v10-0-problem-with-microsoft-excel-2007-dsns/

It seems that IM 2010 crashes using the newer ACE XLSX driver.

 I've tried saving the file as an Excel 97-2003 xls file, but that results in the same crash if the same XLS / XLSX ACE driver (v14.00)  is used.

I've also tried using the older XLS ODBC driver (v6.01).  Although IM doesn' t immediately crash, it gives me a "No tables found" message.

 Problem signature:
  Problem Event Name: BEX
  Application Name: Microsoft.Dynamics.GP.IntegrationManager.exe
  Application Version: 11.0.1767.0
  Application Timestamp: 4da87806
  Fault Module Name: MSVCR90.dll
  Fault Module Version: 9.0.30729.6161
  Fault Module Timestamp: 4dace5b9
  Exception Offset: 0003523b
  Exception Code: c0000417
  Exception Data: 00000000
  OS Version: 6.1.7601.2.1.0.272.7
  Locale ID: 1033
  Additional Information 1: 3896
  Additional Information 2: 389661daf8315bf792ef7b6babdc073b
  Additional Information 3: 7a0d
  Additional Information 4: 7a0d39aa8166f1e6d12d664ebea405b3

 

*This post is locked for comments

  • Suggested answer
    steveendow Profile Picture
    steveendow 2,281 on at
    Re: Integration Manager 2010 SP 2 Crashes when Selecting Excel Data Source

    Update:  Well, it has been several years since I setup an Excel data source with Integration Manager.  

    I forgot to define the Data Range in the XLSX file.

    Once I added the Data Range, the ACE XLSX driver worked fine and IM didn't crash.

    And that also explains the "No tables found" message with the older ODBC XLS driver.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans