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.
461
questions
0
votes
0answers
20 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
29 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
26 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
24 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
18 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
19 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
28 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
27 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
25 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
28 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
58 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 ...
0
votes
1answer
27 views
How to track component wise user views
We have a video component on the page. I just want to know how many users have viewed the component and how many users clicked the video. How can we achieve it?
Any ideas?
2
votes
2answers
62 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
56 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
89 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
59 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
88 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
39 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
17 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
146 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
71 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
32 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
33 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
50 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
81 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
42 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
52 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
51 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
38 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
46 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
40 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
48 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
59 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
91 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
185 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 ...
0
votes
0answers
39 views
MongoDB database lock caused the website to freeze? Does that even make sense?
We had a customer's website (Sitecore 8.2 on Azure) go down last week for about 20 minutes. The site was so locked up that there were no Sitecore log messages. However, there were a bunch of ...
0
votes
0answers
78 views
Sitecore XConnect, Index Worker, XdbSearchUnavailableException
I am trying to search Xdb contacts on the basis of email id.
using this code :
var queryable = client.Contacts.Where(c => c.GetFacet<EmailAddressList>(EmailAddressList.DefaultFacetKey)....
1
vote
2answers
78 views
Problems sending “change of email address” email using EXM
I'm writing some code that will send 2 emails (using EXM) when a user updates their email address. 1 email goes to the original email address, and the other goes to the new email address.
The ...
1
vote
0answers
38 views
XConnect custom predicate: XdbSearchUnavailableException after call is being made
I'm trying to create a custom predicate to search a particular profile in a contact's profile using Sitecore 9.0.1.
Here's the code:
public class ContactProfilMatches : ICondition, ...
1
vote
1answer
20 views
XconnectCollection Service Throwing shard connection errors after migrating dbs to high availability cluster
We had originally configured our XP1 instance to communicate directly to a single SQL server and everything was working correctly. Before going live we update the SQL server to be part of a high ...
3
votes
2answers
75 views
How to get Exm Messages(Message Id, subject, status) sent to each individual XDb contact programatically?
I m sending mails to each individual contact programmatically using EXM with the help of EXM client API
Now I need to get the list of emails sent to each individual user without customization
In ...
0
votes
0answers
27 views
Personalization pattern card rules for anonymous contacts only works on active browser session
We are trying to setup pattern matching personalization using sitecore XDB. We see anonymous contact being tracked into analytics database. I am trying to achieve below:
If pattern card A matches, we ...
0
votes
0answers
24 views
Can I rebuild of the Reporting Database for entries in a specific time interval?
Sitecore 8.1 with Mongo DB here.
Rebuilding the reporting database takes time, and even if there are ways pf improving the speed of the process, it's still a daunting task.
Is there a way too, say, ...
2
votes
0answers
39 views
Reset data for a pattern card
I have an issue where a content author incorrectly tagged a lot of content with a specific pattern card. Now we need to reset anyone's profile who has that pattern card assigned. Does anyone know of ...
1
vote
2answers
328 views
Azure WebApp XDB apps cannot find service 'KeyStoreProviders'
I'm upgrading from 9.0.2 (XM) to 9.2 (XP), so I got a fresh install of the XDB enviroments (Azure WebApps), but my xcollect, ma-ops, xc-search (Solr), and maybe other webapps give me the You do not ...
