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
1answer
38 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 ...
3
votes
2answers
198 views
What does this Experience Profile error mean?
I have a Sitecore 9.1.1 distributed instance. I am seeing this in the CMS site log files a lot. Not sure at all what it means.
10360 15:50:06 ERROR [Sitecore Services]: HTTP POST
URL https://...
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.
...
2
votes
2answers
373 views
GeoIP Location data not coming in database and interaction object?
I am trying to implement geo-location-based personalization for my website and for this, I would like to test the data locally.
I have enabled geolocation services from app-center and tested with the ...
1
vote
1answer
97 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
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....
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
0answers
20 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 ...
1
vote
0answers
24 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 ...
4
votes
1answer
3k views
The certificate was not found. Source: Sitecore.Xdb.Common.Web
This is a follow up on this question Experience Analytics fails on Sitecore 9.0.1 that does not appear to have a solution.
The issue at hand is:
Exception: System.InvalidOperationException
...
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
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 ...
0
votes
1answer
354 views
Errors while installing xdb in remote server
Recently upgraded 8.1 to 9.1 and installed Xconnect in a remote server, moved the certificates to the cm server, and added the connectionstrings as well, but facing an issue
Exception: System.Data....
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 ...
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 ...
7
votes
1answer
1k views
Sitecore 9 Separate CD server - ERROR Cannot start analytics Tracker
I Installed Sitecore 9 XP1 with Separate CD and CM servers.
I am getting the below error in CD:
Unexpected character encountered while parsing value: <. Path '', line 0, position 0
31260 12:55:...
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
167 views
Sitecore 9.1 xDB Data Migration Tool 2.1 multi threads issue
When I start "MongoDB Contacts to xConnect Migration" pipeline with 1 thread all works fine. But when start with more then 1. I have an error after random count of processed contacts.
24104 14:15:53 ...
2
votes
2answers
56 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 ...
3
votes
1answer
2k views
Getting Error while creating contact through xConnect in Sitecore9
I am getting an exception/error while I am creating contact though xConnect Code,
below is my code:
using (var client = CreateClient())
{
try
{
...
0
votes
0answers
19 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 ...
3
votes
1answer
134 views
Capturing the close of a modal as an xDB event
I'm working on a scenario where I have a modal on a page, and if/when the user dismisses it, I want to make it such that the modal doesn't come back up for the user. The ideal scenario is to have this ...
3
votes
1answer
353 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 ...
3
votes
1answer
101 views
Check personalization views on a component without AB tests
What should be done in order for one to check how many views a personalized view of a component has x the default version of that same component?
This component is on a homepage of a website and ...
1
vote
1answer
49 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
0answers
74 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
39 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]....
2
votes
1answer
43 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 ...
1
vote
1answer
113 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
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 ...
0
votes
1answer
77 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 ...
4
votes
2answers
456 views
What is the proper troubleshooting technique for a “No known predicate type could be determined” error message?
As the question title suggests, I am looking for proper troubleshooting techniques in order to solve an error currently being experienced in a Sitecore 9.0.2 XP1 Topology Processing Role Server.
The ...
10
votes
5answers
1k views
Is it possible to associate goal triggering on button click without code?
In sitecore DMS is there any way to associate goal triggering on button click without code , i read some blogs which are giving info regarding how to associate item or pdf to trigger goal . So is it ...
23
votes
2answers
3k views
Is it possible to use any personalisation rules without xDB
Is it possible to make use of any of the component personalisation rules without xDB being enabled? e.g. to swap/hide a component depending on the current date? I'm not interested in tracking the ...
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
76 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
79 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
45 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 ...
3
votes
1answer
517 views
Experience Analytics dashboard gives errors
My Logs shows this error
2428 23:47:09 ERROR [Sitecore Services]: HTTP GET
URL http://ffg.local/sitecore/api/ao/aggregates/all/786FBA3A4573445EA74504E3CA5E48C1/all?&dateGrouping=by-week&&dateFrom=23-...