Forum Discussion
Excel for macOS crashes when retrieving data from MongoDB
I am having difficulties writing data retrieved from MongoDB to Excel (Office 365 subscription, Version 16.32 (19120802) on macOS Catalina). In Excel, under Data -> New Database Query -> From Database -> System DSN, I can connect to our Atlas-hosted MongoDB via BI Connector (also cloud-hosted) using MongoDB Unicode ODBC 1.2.0 driver. The SQL query in the Microsoft Query window that follows successfully returns data (in the very same window), but Excel crashes when clicking the Return Data button, which should write the data retrieved to the Excel sheet. Upon crashing, a Microsoft Error Reporting window pops up with a long error log, the first few lines of which are as follows:
Microsoft Error Reporting log version: 2.0
Error Signature:
Exception: EXC_BAD_INSTRUCTION
ExceptionEnumString: 2
Exception Code: 0x00000001 (0x00007faccea56408)
Date/Time: 2020-01-08 23:20:56 +0000
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Bitness: x64
Application Version: 16.32.0.19120802
Crashed Module Name: CoreFoundation
Crashed Module Version: 6.9.0
Crashed Module Offset: 0x00000000001008ab
Blame Module Name: Microsoft Excel
Blame Module Version: 16.32.0.191208
UnsymbolicatedChecksum: EBC9AD0F003C1051085F81492394AE7D
Blame Module Offset: 0x000000000028f343
StackHash: 67205ec35edd423e-dm_2_main
Application LCID: 2057
Extra app info: Reg=en Loc=0x0809
Build Type: Release
Crashed thread Stack Pointer: 0x_00007ffee2619ab0
Crashed thread: 0
uncaught ObjC exception, reason: The window has been marked as needing another Update Constraints in Window pass, but it has already had more Update Constraints in Window passes than there are views in the window.
Last Exception Backtrace:
...