To access data from MongoDB, SAS/ACCESS^® builds a relational schema that is based on a scan of the collections and documents in MongoDB. The scanning might result in a memory error when the collections are very large and complicated. 

With this hot fix, an enhancement has been made to improve the scan process to avoid the process failing with an error. 

When a MongoDB collection causes a memory failure, the following occurs:

• The collection that generates the error is skipped and the scanning continues with the rest of the collections. 
• A note is written to the log with the number of collections that were skipped.
• A warning is written to the log with the name of only the first collection that was skipped.

This behavior might result in one or more tables being omitted from the resulting schema.

The hot fix also might offer faster performance and a reduction in the amount of memory that is needed for the building of the schema.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

A fix for this issue for SAS Threaded Kernel Extension for MongoDB 9.42 is available at:

A fix for this issue for SAS/ACCESS Interface to MongoDB 9.41 is available at: