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.
471
questions
0
votes
1answer
26 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
22 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
31 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
32 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
22 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
1answer
24 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
14 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
46 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
35 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
35 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
0answers
38 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
23 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
35 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
45 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
25 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
20 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
44 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
29 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
30 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
26 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
92 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
29 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
70 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
64 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
124 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
74 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
99 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
25 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
48 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
18 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
39 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
201 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
91 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
35 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
40 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 ...
0
votes
0answers
59 views
Experience Analytics graph cannot be displayed due to a server error
I am trying to configure a CM + Process Server for Sitecore 8.2 Update-6. We are on Sitecore Managed Cloud M3. I went through the steps in the documentation and enabled/disabled all relevant configs ...
1
vote
1answer
42 views
xDB Data Migration Tool 3.0.0 [closed]
First question:
Do the packages get installed on the Sitecore 8 instance or the Sitecore 9.2 instance?
Second question:
The installation guide refers to three files:
Data Exchange Framework 3.0
xDB ...
1
vote
1answer
103 views
How can I see subscribe and unsubscribe list in sitecore database
Where is the following EXM information stored in Sitecore database (version 9.2).
Subscribe list
Unsubscribe list
I have checked in the Sitecore92_EXM.Masterdatabase. But I was unable to find it. ...
1
vote
1answer
50 views
How to programmatically trigger a goal to contact and then retrieve it in the same visit and in later visits
I want to trigger a goal programmatically to the website visitor/contact and retrieve this triggered goal during the contact's current visit and in his future visits. I could trigger the goal of using ...
-1
votes
1answer
58 views
Media library images not displaying - Invalid URI: The URI is empty
I'm on Sitecore 9.0. Sporadically after a build, the Media Library images all display as broken and when I try to browse to an image directly (e.g. mysite.com/-/media/images/logo.png) I see a server ...
0
votes
1answer
60 views
Sitecore 9.1 custom facets
I am upgrading my Sitecore 8.2 code to work with Sitecore 9.1
WE have custom facets and few custom facets have collection field like below code.
public IElementCollection<IJobPreferenceElement&...
1
vote
2answers
46 views
Create the contact in XDB without Session.Abandon and save Engagement, behavior ,Interaction facets
What would be the best practice to save the Contact in XDB,
At present if "Contact" not exists in XDB (validating by phone + email) and it submit the "Contact-us-Form" then I am using
Session....
0
votes
0answers
49 views
Sitecore Tracking Formbuilder and Field-tracking URL instated of Actual URL in Page Event
I have enabled the Sitecore Analytics and Saving the Contact in XDB.
Whenever a contact Visit the Site and Submit the forms then their Details are tracked in Experience Profile but the URL is ...
0
votes
1answer
46 views
Unable to create xDB contact on CM server
I am unable to create a contact in xDB in a scaled CM server with the below code, whereas the same code is working on the dev Server.
I believe Sitecore.Analytics.Tracker.Current.Session.IdentifyAs ...
1
vote
0answers
62 views
Weird experience with Analytics with Sitecore 9.0.1 on Azure PaaS
We are having a weird experience with Analytics with Sitecore 9.0.1 on Azure PaaS. Looks like the data is being processed on a single date hence we are seeing more than 20K visits on Nov-21. Whereas ...
0
votes
1answer
72 views
xDB Data Migration Tool Error
I'm using xDB Data Migration Tool 2.0 to migrate data from MongoDB (Sitecore 8.2) to xconnect (Sitecore 9.0.2). The tool runs without errors for around 60k records. Then it breaks with Errors like ...
1
vote
3answers
120 views
Assign Goals & Events to XDB contact on Submit of Contact-US Form in SItecore 9.1
In my website I have "contact us form" and 1 goal is trigger after custom-save-action executes.
When a contact fill the form I am saving its details into XDB by using email-id as identity, if record ...
2
votes
1answer
240 views
Use Sitecore Analytics to show most viewed pages
I have a requirement to track the most viewed pages in last month in our Sitecore 9.0.1. I have followed the answer here https://theroks.com/use-sitecore-analytics-show-number-pageviews/ and tried to ...
