Forum Discussion

usrmcsf78's avatar
usrmcsf78
Copper Contributor
Jan 09, 2020

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:

...

No RepliesBe the first to reply

Resources