Problem Note 66459: A SAS/ACCESS® Interface to MongoDB schema scan fails with "ERROR: CLI error trying to establish connection ... Error in the LIBNAME statement ..."
 |  |  |  |  |
In SAS/ACCESS Interface to MongoDB, when you work with a MongoDB database that contains embedded documents 15 or more levels deep, the schema_collection scan fails. In this scenario, you receive the following error:
ERROR: CLI error trying to establish connection: Column not found
ERROR: Error in the LIBNAME statement.
ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to MongoDB | Linux for x64 | 9.4 | 9.42 | 9.4 TS1M6 | 9.4 TS1M7 |
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
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates
The MongoDB database contains embedded documents in the database. When these documents are more than 15 levels deep, SAS/ACCESS Interface to MongoDB returns an error after schema creation.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-02-15 12:04:33 |
| Date Created: | 2020-08-11 10:35:04 |