Questions tagged [xdb]
For questions related to the Sitecore Experience Database (xDB). If you're using Sitecore 7.2 or earlier, use the `dms` tag instead.
479
questions
0
votes
0answers
19 views
Recommendation on number of Sitecore 9.3 xDB Shards?
Does Sitecore have any documentation on xDB shard sizing?
Per Google analytics we have about 8M visitors per month, 20M sessions per month. All Anonymous users.
Default is 2 shards, max is 18.
...
0
votes
0answers
19 views
Device Detection Not Working on Vanilla Sitecore 8.2
Problems related to device detection and Sitecore Analytics appear to occur in instances of Sitecore XP 8.2..
No Device Detection or GeoIP is being logged into Sitecore analytics, even though I have a ...
0
votes
0answers
22 views
Disaster Recovery setup for xDB in Sitecore 9.1
I need to setup the DR environment for Sitecore 9 CD server. It is deployed in On-premise environment. Since the requirement is a Hot-hot recovery process, so I am planning to follow the article ...
0
votes
1answer
19 views
Sitecore Analytics cookie id does not match in MongoDB Contacts table records
I have Sitecore 8.2 installed in my local environment. I was investigating that is analytics/xDB working correctly in my setup. I opened my site with a browser and saved the cookie ...
1
vote
1answer
32 views
What is the ContactsMerge.aspx Administration Page?
In Sitecore 9.1.1, and possibly other versions, the "/sitecore/admin/xdb/ContactsMerge.aspx" administration tools page exists.
It takes no inputs, has no description of what it does, but a ...
2
votes
1answer
31 views
How to add new properties to ICampaignActivityDefinition interface and deploy it in Sitecore 10
We are upgrading the Sitecore version from 8.2 to 10 and we have a few customizations in our projects related to campaign creation. In Sitecore 8.2 we use to have the SaveCampaign class present in the ...
0
votes
1answer
32 views
How to track user details when session expires? [closed]
Is there any possibility to track the session expired users or logged out users? When a user visits without login details how can I track the user details?
1
vote
2answers
54 views
Experience profile field data missing in Contact Card: First Name
I've encountered a very weird issue which I was hoping to get some advice on.
I've implemented a custom facet in Experience Profile - Sitecore 9.1 which works fine. On my environment there's no ...
2
votes
2answers
54 views
How do I track known contact who clicked a link from EXM
Created a Sitecore 9 form on which activates an EXM with a link redirecting to site's page. During form submission I am saving the contact. How do I track the same contact after clicking the link ...
0
votes
0answers
17 views
Sitecore 9 Analytics - added user agent in the <excludedUserAgents> not working
We have Sitecore 9.0.2 based UAT and Live website in Azure PaaS environment. Before some time we have configured Sitecore analytics tracking in UAT and Live both.
Now what happened is in both ...
1
vote
0answers
73 views
How to add Interaction to the xdb contacts using xconnect provider of Data Exchange framework?
I have the requirement of add interactions to the xdb contacts. For that, I am using xconnect Provider. So how can I add Interactions by using the data exchange framework xconnect provider?
1
vote
0answers
38 views
Extend Sitecore xConnect web API
My requirement is to add more custom data in the xConnect web API response.
For example, when I hit https://xConnect-domain/odata/Contacts then it gives me the default JSON for the contacts only, like ...
0
votes
0answers
38 views
How to Migrate google analytics data to sitecore analytics using Data exchange framework in sitecore 9.2 [duplicate]
We have a requirement of migrating google analytics data into Sitecore analytics using Data Exchange Framework, I have google analytics data in .xlsx format. So How can I migrate these .xlsx format ...
0
votes
1answer
28 views
How to filter the contacts who has hit the persona on specific page
Suppose, we have two pages one with the content relevant to Microsoft and one with content relevant to Apple. I have applied two profile cards, one on microsoft page and one on apple page.
Now, I want ...
0
votes
0answers
31 views
Sitecore 9.1.1 Database CPU crashing ocassionally - XDB query in suspect
I am having trouble debugging why my CPU utilization occasionally reaches 100%!
The query I see which is taking time is
...
RETURN (
SELECT TOP 1
[xdb_refdata].[DefinitionMonikers]....
0
votes
1answer
43 views
Retrieve Sitecore Contacts based on current contact ID
We are having a requirement to capture details and update it to custom facet. Whenever there's an identifier (in my case it is,email address from session) it works as expected. I'm able to see the ...
2
votes
1answer
39 views
Limit and reduce size of xDB in Sitecore 9.2+
In the Sitecore 9.2 release it is mentioned in this post that a new feature is available:
Limit and reduce size of xDB
I haven't been able to find how to enable this in official documentation. Does ...
0
votes
0answers
27 views
External Federated Authentication with Open ID connect - when is the best time to Identify the Contact?
I have a custom IdentityProvidersProcessor for federated user authentication for a front-end user facing site. I would like to also Identify the user as a Contact when they log in. When is the best ...
0
votes
2answers
36 views
XDb collection unavailable exceptions while Xdb is completely disabled
My Sitecore 9.3 website has Xdb and Xdb.Tracking disabled but still CM server error logs always have some XDb collection unavailable exceptions. Is Xdb still coming into picture? These exceptions are ...
0
votes
0answers
17 views
Clicking on Experience profile takes me to /sitecore/service/xdb/disabled.aspx
Below issue is in:
on developer machine,
installed sitecore 9.3 XP scaled.
/admin/showconfig.aspx shows that xDB and tracker are enabled. But when I click on experience profile or experience ...
1
vote
1answer
106 views
How to fix “Session with Id xxxx has reached the max page threshold of 50.” warning
Since launching a v9.0.2 scaled site, I've seen this warning many times in the logs:
10076 09:52:45 WARN Session with Id xxxxxxx has reached the max page
threshold of 50. If you see this message ...
0
votes
1answer
74 views
Trigger Goal on Sitecore Item does not appear in Experience Analytics
I am working with Sitecore 9 update 1, I have created a Goal, deployed and published it. After that, I have applied goal on Home page and other Sitecore pages, the document I followed https://doc....
0
votes
0answers
41 views
List Manager not loading recipients list in sitecore 8.2
We are working with sitecore 8.2 and we have added 8,000 contacts in xdb but when we click on list manager it's keep on loading and in sitecore logs not logging any error to figure out the issue.
we ...
1
vote
1answer
90 views
XDB Disabled - Still getting tracking error in the logs
I have xdb disabled:
xdb.Enabled = false
xdb.Tracking.Enabled = false
Im still getting xdb related errors in the logs. Should this all be disabled (Sitecore 9.3):
7932 11:45:08 ERROR One or more ...
0
votes
0answers
27 views
Sitecore 9.0.2 compatibility with MS SQL 2016 Standard SP2
We are currently using Sitecore 9.0.2 with MS SQL Standard Edition 2016 with ALWAYSON HA.
The xDB is running on SP2-CU4 since always and is working fine. We recently upgraded the XM from SP1-CU15 to ...
0
votes
2answers
42 views
Why I can't create historical Interactions (with a date in the past) And I can't add new facets to already existing interactions
1. Can't add new interaction with historical date
This is the only way to add new interaction problematically
new Interaction(contact, InteractionInitiator, channelId, userAgent);
and as you can see,...
0
votes
0answers
73 views
Any insight on how to fix “XConnect Exception Filter OnException” errors?
Our instance has been pretty stable until recently we started receiving the following errors in XConnect.
Main log
[Error] XConnect Exception Filter OnException(), url - "https://site.com/odata/...
2
votes
0answers
28 views
Update Sitecore Contact Programmatically :For Users on a Shared Computer
I am using Sitecore API to identify and update the contact with a Member ID value Post login.
But the below code seems to update the interaction to the same contact i.e. If two people are logging in ...
1
vote
1answer
21 views
WFFM 8.2 Trying to manually insert form onto razor view
In the header html of our website we would like to insert a form, but it is not accessible from experience editor or content editor so I would like to insert it directly into the cshtml page for the ...
0
votes
0answers
24 views
Explore mode GeoIP data not available
In Sitecore Experience Editor Explore view I am facing one issue in which I am not getting any country list in GeoIP section under Visitor information. Below is the screenshot of my page.
Please ...
0
votes
0answers
74 views
Tracker.Current is null on CD for media request event
I'm using Sitecore 9.1.1, and I've wired an event up to media:request that forces a track of the download page event, as well as increments a counter of number of downloads that a user has performed ...
1
vote
1answer
31 views
Add values for contact facets
I'm using 9.1.1, and at the moment all of the contacts I have in experience profile are coming back as unknown. For our system, you have to log in to use anything beyond the homepage, and as part of ...
0
votes
0answers
43 views
SQL query against all xDB Shard databases
I am looking for a way on T-SQL to be able to query all the shards at same time.
It looks like Sitecore is using a ShardManager that is used on code, which makes sense for them. But I used SQL a lot ...
0
votes
0answers
28 views
Actual IP Address not showing in Mongo DB Interaction table though Analytics.RedactIpAddress is set to true
I know that by default IP address is hashed in Mongo DB interaction table(Sitecore 8.1 Update 2).
But recently I set the value Analytics.RedactIpAddress to true which is by default false, so that ...
0
votes
1answer
34 views
1 CD in pair behind ELB loses connection to SQL
Sitecore 8.2 Update 3. Running two CDs behind ELB in AWS. Same region. This week, one of these CDs has twice lost it's ability to connect to the SQL server (according to the logs). Running SQL on RDS ...
0
votes
1answer
128 views
WFFM not saving data
Sitecore 8.2 update 3. Just installed WFFM 8.2 update 3. Local (to CM) MongoDB for analytics (if that matters?)
I created a template for an item to save the results of a form submission and made "...
0
votes
0answers
30 views
Rebulding Database not showing previous analytics after upgrade
I have upgraded from Sitecore 9 to 9.2 recently. Looking into the database I see all interactions being written to xDB. But from the date of upgrade, the UI has not been updated on Experience ...
2
votes
2answers
80 views
How to get a contact with custom facet?
I am trying to get a sitecore contact with the custom facet.
The custom facet is working fine I have verified it.
The following code is running fine on Standalone and CM environment, but is throwing ...
0
votes
1answer
68 views
How do you add a sitecore contact in CM environment
I am using the below code to add a Sitecore contact which works fine in my Standalone environment but is causing issue on CM environment as the contact is coming null.
Tracker.Current.Session....
1
vote
1answer
189 views
How do you properly query xdb for a contact by email?
I am trying to search an email in Sitecore Xdb using the code :
var queryable = client.Contacts
.Where(c => c.GetFacet<EmailAddressList>(EmailAddressList....
0
votes
1answer
120 views
XConnect: An error occured during resuming a previous index rebuild process
Does anyone have an idea about what could be causing this error? It happens after doing a re-build of the XConnect index. This is in Sitecore 9.3
2020-03-30 20:11:02.896 -05:00 [Error] An error ...
3
votes
0answers
113 views
xDB not tracking Custom Facet
Version: Sitecore 9.2
I have followed these tutorials:
- https://himmatsinghdulawat.blogspot.com/2019/06/create-custom-facet-model-in-sitecore-9.html
- How to properly configure a custom facet in ...
0
votes
0answers
26 views
How do I get SiteName populated for WebView facets?
I have CD server data getting collected by XConnect collection, but when it's serialized and saved to a shard, the WebView FacetData JSON is missing SearchKeywords and SiteName. Since SiteName is ...
0
votes
0answers
52 views
Sitecore 8.2 website went down when MongoDB crashed, how to prevent [duplicate]
Sitecore 8.2 Update 3
We have a single CM that also hosts MongoDB for analytics. We also have 2 CDs.
This morning MongoDB crashed when it apparently ran out of memory. I thought Sitecore was supposed ...
0
votes
0answers
27 views
Rebuild Reporting DB on Sitecore Managed Cloud
I am experiencing an issue where my Experience Analytics data is current but my Experience Profile data is out of sync. I believe to fix this issue, I need to rebuild the Reporting db and Analytics ...
0
votes
2answers
41 views
How to trigger a generic event through code
Page Events (defined in /sitecore/system/settings/Analytics/Page Events) cann be triggered like this:
var pageEventDefinition = Sitecore.Analytics.Tracker.MarketingDefinitions.PageEvents[pageEventId];...
3
votes
1answer
304 views
How do I change the Sitecore Analytics cookie to be SameSite=None?
With the default security changes in browsers, third party cookies are getting blocked. Sitecore's SC_ANALYTICS_GLOBAL_COOKIE doesn't seem to have a SameSite property in it so it is being treated as ...
0
votes
0answers
122 views
Spoof IP Address for testing Sitecore Geolocation?
My site is on a CDN and uses True-Client-IP for tracking:
<setting name="Analytics.ForwardedRequestHttpHeader" value="True-Client-IP" />
I'm trying to test geolocation feature in production, ...
0
votes
0answers
41 views
Sitecore custom contact facet
Getting exception on Xdb BuildModel().
Please help me with the below exception.
'CollectionModel.Model' threw an exception of type 'System.TypeInitializationException'
Data: {System.Collections....
1
vote
0answers
41 views
Slow Sitecore platform due to lot of data in Mongo DB
We observed very bad performance of Sitecore Digital Platform. Applications like List manager, indexing are very very slow. Contact data and corresponding properties within contact are getting ...