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.
475
questions
0
votes
0answers
12 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
57 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
34 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
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
24 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
34 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
23 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
25 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
52 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
39 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
37 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
45 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
48 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
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
52 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
32 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
27 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
95 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
75 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
148 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
82 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
102 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
20 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
40 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
233 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
99 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
37 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
60 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
113 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
52 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
63 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
48 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
50 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
47 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 ...
