Problem Note 70449: Accessing a MongoDB table might result in “ERROR: CLI prepare error: Error occurred during Post Optimization. : Invalid descriptor field identifier”
 |  |  |  |  |
Running a query against a flat table for a MongoDB table might result in the following error:
ERROR: CLI prepare error: Error occurred during Post Optimization. : Invalid descriptor field identifier
This error occurs when the original names are used instead of the unique column names that were generated when the flat table was created. This issue causes the column names to clash.
There is no workaround for this issue.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to MongoDB | Linux for x64 | 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#70449| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-10-31 12:10:55 |
| Date Created: | 2023-10-17 10:56:42 |