Questions tagged [mongodb]
All questions related to the use of MongoDB in a Sitecore environment - xDB, sessions, ...
108
questions
4
votes
0
answers
313
views
Sitecore Analytics Channel Detection
Sitecore has a bunch of Channels defined in /sitecore/system/Marketing Control Panel/Taxonomies/Channel.The config Sitecore.Analytics.Channel specify the different channels that are assigned for ...
- 818
12
votes
1
answer
792
views
Sitecore XDB cleanup to limit size
On our current system XDB is grown very large, the interactions DB is around 80% of the total database size, followed by KeyBehaviourCache at 5% then GeoIps and Contacts at 4%. We need to reduce the ...
- 2,382
1
vote
0
answers
98
views
How can we Size or Estimate the xDB Conversion Process while upgrading from 7.2 to 8.2? [closed]
We are in process of upgrading Sitecore 7.2 to 8.2 Update 5 (may be Update 6 later). As part of the process client wants to migrate the historical analytics data from SQL to Mongo (On-Premise). Client ...
- 2,534
9
votes
2
answers
408
views
Any Guidelines to choose between SQL or Mongo for xDB on Sitecore 9?
Want to check if we have any guidelines (metrics) helpful to decide either Mongo or SQL will be good fit while Upgrading to Sitecore 9, especially if the current version in below 7.5 (No Mongo). ...
- 2,534
5
votes
3
answers
368
views
Custom Report from xDB (MongoDB) based in Geo Ips
We are on Sitecore 8.2 rev. 170614 (8.2 Update-4) using MongoDB On-Premise mode with custom SSL Setup.
Need to submit a custom report to business based on various logins (and related data) ...
- 2,534
3
votes
1
answer
749
views
Mongo db Interactions table not getting updated
In my dev machine I am not getting any interactions added in interaction table of mongo db. My session state entry in web.config is as follows:
<sessionState mode="InProc" cookieless="false" ...
- 405
3
votes
1
answer
308
views
Speed up fetching data from interactions table of Mongo db
We have a requirement in which we must get values from mongo db faster than the current scenario. We have few articles in our project and there is an option to fetch recent articles which are most ...
- 405
6
votes
3
answers
888
views
Is MongoDB a prerequisite to install EXM?
I'm installing the EXM 3.5 initial release in a recent upgraded Sitecore 8.2 update 5 (from update 2), and I am mentioning that because I had to set Xdb.Enabled and Xdb.Tracking.Enabled to false in ...
- 2,969
0
votes
1
answer
938
views
All reporting api services returning 404 response
I am currently enabling xDB on an Sitecore 8.2.5 install that has recently been upgraded from an 8 initial release. It has never had xDB enabled. I'm getting some issues where data appears to be added ...
- 143
1
vote
1
answer
132
views
Analytics location - no data follow-up
I found this question previously asked and answered on this topic: Sitecore Analytics Location has no data.
As a follow-up to that, if I just purchased the GeoIP service and turned on the Analytics....
- 5,082
4
votes
2
answers
822
views
"Method not found" error with MongoDB.MongoCursor
I have problem with MongoDB.Driver.MongoCursor. When I want to set tracking I get an error:
Method not found: 'MongoDB.Driver.MongoCursor`1 Sitecore.Analytics.Data.DataAccess.MongoDb....
- 311
14
votes
0
answers
1k
views
Submit queue is not working [closed]
I was looking for a fallback for Analytics when MongoDB was not available anymore and the "Submit queue" was exactly what I needed on paper.
My Issue
It seems that the "Sitecore.Analytics....
- 283
3
votes
1
answer
2k
views
How do I anonymize contact data in MongoDB?
I need to send a copy of my MongoDB to Sitecore Support for investigation. For security reasons I want all sensitive data to be anonymized.
Fields I'm talking about are: FirstName, LastName, ...
- 1,601
2
votes
1
answer
661
views
Where to find Visit Duration and Latest Date Visited in Code Behind
I am creating a process that reads in the Sitecore analytics contact collection and gets information needed for a report. It is read and inserted in SQL Server. Not sure how to get some of the fields ...
- 755
5
votes
2
answers
778
views
Sitecore MongoDB Compatibility Version
As per the Sitecore recommendation from the below link Mongo DB 3.2.1 is recommended, but when we look at the Mongo DB we are having 3.2.15 patch update as the latest.
Sitecore Recommendation : ...
- 627
3
votes
2
answers
232
views
500 error page for Sitecore Start Up with no Solr or mongo connected
I'm trying to configure a 500 error page.h I have successfully done this for handling exceptions once the application is already up and running.
However I'm having an issue where if Solr Or MongoDB ...
- 143
5
votes
1
answer
322
views
Contact Not Found Exception thrown with valid contact IDs
In the following code...
var contactManager = GetContactManager();
var contact = contactManager.LoadContactReadOnly(contactId);
if (contact == null)
{
Log.Info("MySite.Presentation.Controllers....
- 1,675
13
votes
3
answers
1k
views
Contact (guid) could not be locked in the xDB
I've got a site where I'm invoking Tracker.Current.Session.Identify(), passing in the authenticated user's email address.
It works fine locally, but when deployed the identify call often - but not ...
- 4,093
1
vote
0
answers
43
views
Sitecore WFFM- get all dropouts data programmatically [duplicate]
We have the requirement like, pull the all dropout users information and send email to our client.
I know that WFFM captures form dropout data, but how to get this data pro-grammatically,I check with ...
- 93
6
votes
1
answer
384
views
WFFM: How multisite FormData get saved in MongoDB?
I am using Sitecore 8.1 with WFFM. Can anyone please explain me how the multi-site information get saved in FormData?.
As per my understanding FormData will get saved with FormID and its Fields in ...
- 237
4
votes
1
answer
307
views
WFFM: What happens when we delete a wffm form?
I am using Sitecore 8.1 with WFFM. And i am new to WFFM. I found that when user enters data to WFFM forms it will get stored in MongoDB formdata collection. What will happen if the WFFM form will get ...
- 237
0
votes
1
answer
1k
views
Getting System.NullReferenceException while setting value into Sitecore.Analytics.Tracker.Current.Session.Identify
We are using Azure B2C for Login into Our website, but in CM server we are getting below error . The Same code is working in CD server. I don't remember what i have missed in CM server (any config ...
- 717
1
vote
1
answer
368
views
xDB InProc shared session state in load-balanced environment
I am auditing the xDB configuration on a site based on Sitecore 7.5.
The setup is plain with no custom interactions being registered.
We are dealing with the last scenario here, "Content delivery ...
- 1,813
1
vote
1
answer
164
views
Where can I find Developer Resources for Sitecore Analytics?
My company decided to get more involved with Sitecore Analytics, with the goal of Personalization in mind. I have a good understanding of Sitecore in general, but I never prepared a custom report or ...
2
votes
2
answers
1k
views
Mongo Replica Set Connection Error, Sitecore 81
I have a POC of a Mongo Replica (Mongo 3.0.14) set created locally using VirtualBox. I have a Primary, Secondary and Arbiter created and initiated in the replica set:
Using Robomongo from my host ...
- 4,821
4
votes
1
answer
1k
views
How to Join MongoDb Collections Using Sitecore Mongo Db Report Data Source
Am using sitecore 8.0, below code gets the analytics from the mongo db. I have two collections "ineractions" and "ContactId", I want to join both the collections using common field "contact" from ...
- 305
4
votes
1
answer
114
views
What Sitecore understands about Mongo from its ConnectionStrings?
Here's my scenario
Sitecore 8.1 update 1 in Datacenter X
Sitecore 8.1 update 1 in Datacenter Z (stand-by failover)
MongoDB Replica Set (rs0) Primary and Secondary in Datacenter X
MongoDB Replica Set (...
- 2,969
2
votes
1
answer
383
views
Sitecore 8.2 update 2 authentication failed on MongoDB 3.2 [closed]
I've the following scenario
Sitecore 8.2 update 2
MongoDB 3.2
Now, I'm trying to setup authentication to MongoDB, and as soon as I update the mongod.cfg
security:
authorization: enabled
and the ...
- 2,969
0
votes
1
answer
257
views
Sitecore 7.5 WFFM FormData Collection Never Created in MongoDB
I am troubleshooting an older instance of Sitecore where Form reports are blank for all WFFM forms. In my investigation, I found that the FormData collection is never created in MongoDB. I tested ...
- 4,821
3
votes
1
answer
198
views
How do I get access to my Contact Card information
I'm running Sitecore 8.1 Original Release, and I'm trying to run this code:
var repository = new ContactRepository();
var contact = repository.LoadContactReadOnly(contactId);
where contactId is ...
- 2,938
1
vote
0
answers
33
views
What are the steps I could take to debug non-functioning Experience Analytics (MongoDB)? [duplicate]
On one of the websites I'm working on the Site Analytics are broken - a MongoDB database is successfully created by Sitecore to store Analytics data and I can see the Analytics interface in Content ...
user1475
2
votes
1
answer
457
views
How to secure MongoDB replica set environment?
Currently, I have 3 servers running MongoDB 3.0 as part of a Replica Set, and no security is applied. To connect I simple use
mongodb://m01,m02,m03/analytics?replicaSet=rs0
Is it possible create ...
- 2,969
15
votes
3
answers
9k
views
ERROR: Cannot create tracker (Message:session is not initialized) Sitecore 8.1 update 2
I am getting below error in logs and none of the interaction data is collected in mongoDB also.
Verified with Post looks everything Ok in my solution.
ERROR Cannot create tracker.
Exception: ...
- 441
6
votes
1
answer
427
views
Sitecore 8.1 update 2 production health check
Sitecore healthcheck.aspx checks connection to all DBs mentioned in connectionString.config.
I want to test
If analytics data being captured or not in MongoDB replication set
Processing Server ...
- 441
2
votes
0
answers
457
views
Sitecore Commerce CM Server MongoDB.Driver.MongoDuplicateKeyException
We are setting up Sitecore Commerce with Sitecore 8.1 using a CM + CD Server on Azure and experiencing the below error in our logs
For some reason on the CM server we are receiving the following ...
- 203
5
votes
4
answers
1k
views
No contact created in MongoDB when session is closed
8.2 update 0. I have changed session to be 1 minute instead of the default 20 minutes. When I log into the site, in incognito, surf around and close the browser. No contact is ever created in the ...
- 13k
5
votes
2
answers
1k
views
How can I create a custom Page Events report in Sitecore 8?
I wanted to create a report on particular page events. In Sitecore 7.2 we had a PageEvents table; in Sitecore 8 xDB, this table seems to be missing from the Reporting DB.
I checked the Interactions ...
- 185
2
votes
1
answer
4k
views
How to get values from MongoDb based on an ID using a C# LINQ query?
I am getting values based on formId in MongoDB using the following query:
db.FormData.find({FormID:new BinData(3,"nMVvjlcHGU68zFBBCeYdsg==")})
It works in the MongoDB command prompt only. How can I ...
- 337
0
votes
1
answer
193
views
Error message - unable to connect to tracking_contact on a CD server [closed]
I have a Sitecore 8.1 instance that was upgraded from v7.5. We are using hosted Mongo at ObjectRocket. I don't remember during the upgrade process any step that told me I was supposed to add a ...
- 3,359
4
votes
1
answer
145
views
Analytics Stops upon Code Deployment
I am not sure if anyone ran into this issue before:
We have an in house built tool to deploy code from the build server to specified destinations. Mongo reports/Custom Analytics is not working ...
- 393
13
votes
2
answers
2k
views
MongoDB historical data and data truncation
We have noticed that our MongoDB's are growing steadily. Which is an obvious result of just capturing all kinds of user interactions.
However, we can't have the xDB grow infinitely...
I can't seem ...
- 625
17
votes
2
answers
796
views
What are options for archiving xDB data?
I've ran into a number of different scenarios lately around xDB and data retention and archiving.
What is the best practice for archiving data in xDB in general? For example, is there a best practice ...
- 1,697
12
votes
2
answers
2k
views
How can I create a custom report in Experience Analytics?
I'm pretty new at Sitecore, so I don't know if this is possible. I am able to log some custom page events (click on an anchor on the client side) in xDB. I can then query this with Robomongo. But ...
- 175
7
votes
3
answers
1k
views
How do I run MongoDB and SOLR Docker images that work with Windows Server 2016?
I'm trying to configure my Sitecore 8.2 instance in a Docker container using Windows Server 2016. I've been able to successfully setup IIS in a Docker container, but am unable to find any containers/...
- 2,938
12
votes
2
answers
4k
views
MongoDB and Disaster Recovery
What are peoples best practices for MongoDB and disaster recovery?
What I'm interested in is less around resilience (we have replica sets - and are looking at SaaS solutions too) but more around ...
- 2,632
-2
votes
1
answer
927
views
How to query form data from mongodb, based on a specific value?
I have the following data in MongoDB:
{
"_id":BinData(3, "Q6z94uPrW0+IcUnjkwjFCw=="),
"_t":"FormData",
"FormID":BinData(3, "nMVvjlcHGU68zFBBCeYdsg=="),
"ContactId":BinData(3, "...
- 337
10
votes
1
answer
130
views
Is it possible to distribute my xDB MongoDB databases over 3 locations?
So I've been reading up on geographically distributed MongoDB setups.
I am juggling around an architectural approach/concept for a project. This is roughly what I am looking at.
A centralised ...
- 24.7k
10
votes
4
answers
3k
views
What happens when MongoDB is down?
We are building an infrastructure for xDB internally and our internal network team asked us what would happen if the MongoDB instances were down.
We, of course are deploying MongoDB with Replica set ...
- 2,363
5
votes
3
answers
164
views
What weighs in when migrating lots of external content to MongoDB and/or SOLR?
I am tasked with importing a large bulk of transaction data and make it available to my Sitecore solution. We're talking roughly 10 million transaction records that we need to be able to utilise real-...
- 24.7k
7
votes
3
answers
1k
views
Can I use the in-memory storage engine for my MongoDB based sessions?
MongoDB 3.2+ offers the option of putting some or all of the structures into an in-memory engine. I was thinking to try out this capability for discardable data such as Sitecore sessions - for which ...
- 24.7k