Query Exception with type CX SY Export no Shared Memory

This article explains about the Exception with the type CX_SY_EXPORT_NO_SHARED_MEMORY resulted when executing the queries with larger set of outputs and the procedure to set the parameters rsdb/esm/buffersize_kb and rsdb/esm/max_objects in the instance profiles to resolve the Shared Memory Error.