Problem Note 70086: Accessing a flat table created from a MongoDB collection where one of the documents contains a multiple dimension array might result in an error
 |  |  |  |  |
Accessing a flat table that is created from a MongoDB collection might result in an error similar to the following when one of the documents contained a multi-dimension array:
When the flat table is created, a column is created for each element of the array that exists in the MongoDB document. Multi-dimension arrays appear in the flat table as the array base name plus the indices without any separation. So if the array, such as myarr, contains elements such as (11,0) and (1,10), both are given the same name - myarr110. The duplicate column name results in the error when the flat table is accessed.
There is no workaround for this error.
Click the Hot Fix tab in this note to access the hot fix for this issue.
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.4 TS1M6 | ||
A fix for this issue for SAS Threaded Kernel Extension for MongoDB 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I8W.html#70086| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-08-30 11:29:23 |
| Date Created: | 2023-05-09 15:42:12 |