MSRP - MongoDB Storage Resource Provider msrp-mongodb-storage-resource-provider

About MSRP about-msrp

When AEM Communities is configured to use MSRP as its common store, user generated content (UGC) is accessible from all author and publish instances without the need for synchronization nor replication.

See also Characteristics of SRP Options and Recommended Topologies.

Requirements requirements

MongoDB Configuration mongodb-configuration

Select MSRP select-msrp

The Storage Configuration console allows for the selection of the default storage configuration, which identifies which implementation of SRP to use.

On author, to access the Storage Configuration console:

MongoDB Replica Set mongodb-replica-set

For the production environment, it is strongly recommended to setup a replica set, a cluster of MongoDB servers that implements primary-secondary replication and automated failover.

To learn more about replica sets, visit MongoDB’s Replication documentation.

To work with replica sets and learn how to define connections between applications and MongoDB instances, visit MongoDB’s Connection String URI Format documentation.

Example Url for Connecting to a Replica Set example-url-for-connecting-to-a-replica-set

# Example url for:

>[!CAUTION]
>
>AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our [technical support periods](https://helpx.adobe.com/support/programs/eol-matrix.html). Find the supported versions [here](https://experienceleague.adobe.com/docs/?lang=en).
#     servers "mongoserver1", "mongoserver2", "mongoserver3"

>[!CAUTION]
>
>AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our [technical support periods](https://helpx.adobe.com/support/programs/eol-matrix.html). Find the supported versions [here](https://experienceleague.adobe.com/docs/?lang=en).
#     replica set 'rs0'

>[!CAUTION]
>
>AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our [technical support periods](https://helpx.adobe.com/support/programs/eol-matrix.html). Find the supported versions [here](https://experienceleague.adobe.com/docs/?lang=en).
# port numbers only necessary if not default port 27017

>[!CAUTION]
>
>AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our [technical support periods](https://helpx.adobe.com/support/programs/eol-matrix.html). Find the supported versions [here](https://experienceleague.adobe.com/docs/?lang=en).
mongodb://mongoserver1:<mongoport1>,mongoserver2:<mongoport2>,mongoserver3:<mongoport3>/?replicaSet=rs0&maxPoolSize=100&waitQueueMultiple=50&readPreference=secondaryPreferred

Solr Configuration solr-configuration

A Solr installation may be shared between the node store (Oak) and common store (MSRP) by using different collections.

If both the Oak and MSRP collections are used intensively, a second Solr may be installed for performance reasons.

For production environments, SolrCloud mode provides improved performance over standalone mode (a single, local Solr setup).

For configuration details, see Solr Configuration for SRP.

Upgrading upgrading

If upgrading from an earlier version configured with MSRP, it will be necessary to

Publishing the Configuration publishing-the-configuration

MSRP must be identified as the common store on all author and publish instances.

To make the identical configuration available in the publish environment:

Managing User Data managing-user-data

For information regarding users, user profiles and user groups, often entered in the publish environment, visit

MSRP Reindex Tool msrp-reindex-tool

There is an HTTP endpoint for reindexing Solr for MSRP when installing new configuration files or repairing a damaged Solr index.

With this tool, MongoDB is the source of truth for MSRP; backups need only be taken of MongoDB.

The entire UGC tree may be reindexed, or only a specifc subtree, as specified by the *path *data parameter.

This tool may be run from the command line using cURL or any other HTTP tool.

When reindexing, there is a tradeoff between memory and performance controlled by the *batchSize *data parameter, which specifies how many UGC records are reindexed per batch.

A reasonable default is 5000:

Running MSRP Reindex Tool Using cURL Command running-msrp-reindex-tool-using-curl-command

The following cURL command shows what is necessary for an HTTP request to reindex UGC stored in MSRP.

The basic format is:

cURL -u signin -d data reindex-url

signin = administrator-id:password
For example: admin:admin

data = "batchSize=size&path=path"

size = how many UGC entries to reindex per operation
/content/usergenerated/asi/mongo/

path = the root location of the tree of UGC to reindex

reindex-url = the endpoint for reindexing of SRP
http://localhost:4503/services/social/datastore/mongo/reindex

MSRP Reindex Example msrp-reindex-example

curl -s -u admin:admin -d 'batchSize=10000&path=/content/usergenerated/asi/mongo/' http://localhost:4503/services/social/datastore/mongo/reindex

How To Demo MSRP how-to-demo-msrp

To setup MSRP for a demonstration or development environment, see HowTo Setup MongoDB for Demo.

Troubleshooting troubleshooting

UGC Not Visible in MongoDB ugc-not-visible-in-mongodb

Make sure MSRP has been configured to be the default provider by checking the configuration of the storage option. By default, the storage resource provider is JSRP.

On all author and publish AEM instances, revisit the Storage Configuration console or check the AEM repository:

UGC Disappears after Upgrade ugc-disappears-after-upgrade

If upgrading from an exisitng AEM Communities 6.0 site, any pre-existing UGC must be converted to conform to the structure required for the SRP API after upgrading to AEM Communities 6.3.

There is an open source tool available on GitHub for this purpose:

The migration tool can be customized to export UGC from earlier versions of AEM social communities for import into AEM Communities 6.1 or later.

Error - undefined field provider_id error-undefined-field-provider-id

If the following error is seen in the logs, it indicates the Solr schema file is not properly configured.

JsonMappingException: undefined field provider_id jsonmappingexception-undefined-field-provider-id

Caused by: com.fasterxml.jackson.databind.JsonMappingException: undefined field provider_id
at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:129)
at com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:1819)
at com.adobe.cq.social.scf.core.BaseSocialComponent.toJSONString(BaseSocialComponent.java:196)
... 124 common frames omitted

To resolve the error, when following the instructions for Installing Standard MLS, ensure

Secure Connection to MongoDB Fails secure-connection-to-mongodb-fails

If an attempt to make a secured connection to the MongoDB server fails due to a missing class definition, it is necessary to update the MongoDB driver bundle, mongo-java-driver, available from the public maven repository.

Resources resources