Questions tagged [xconnect]
For questions related to xConnect, the API service layer abstracting the storage architecture of xDB from those accessing xDB data.
395
questions
0
votes
0answers
23 views
Personalization based on datetime field in Contact data
I am using sitecore 10 update 1, I am saving the birth date of the contact in Xprofile. The data saved in database is UTC time, for example if the birth date is "12 April 2021" the saved ...
2
votes
1answer
50 views
Retrieve all email campaigns in a non-Sitecore context
Sitecore Version: 9.1 Update 1
I am trying to retrieve all email campaigns in a non-Sitecore context. To do that, First I Constructed the definition manager in a non-Sitecore context:
private static ...
0
votes
1answer
26 views
Configuration options for xConnect when installing Sitecore 10 XP1 using Sitecore Installation Framework (SIF)
My question is related to the configuration of SIF installation scripts for the xConnect component.
There are some options within the example XP1 topology scripts for which I need some additional ...
1
vote
1answer
42 views
Birthdate in XProfile shows in UTC time rather than server/localtime in sitecore 10
I'm using Sitecore 10.
Values stored in sitecore are always stored in UTC, is there a way to show the values that appear in XProfile for a contact (i.e. Birthdate) in server time instead of UTC?
Edit: ...
1
vote
1answer
26 views
MongoDB 4.0.6 setup in Sitecore 9.3
I'm trying to setup mongoDB 4.0.6 analytics in Sitecore 9.3 instead of Default SQL analytics.
Are there any detailed guides on setting up mongo db for sitecore 9.3 ? I can't seem to find any ...
2
votes
0answers
28 views
How to import Sitecore XConnect (analytics) data from Sitecore 9.1.1 to Sitecore 10.01
First some context. We are currently upgrading from Sitecore 9.1.1 and JSS 11 to Sitecore 10.01 and JSS 15. We do this by recreating the Azure PAAS infra using the ARM templates and custom Powershell ...
0
votes
0answers
14 views
List Manager throwing an error while creating new contact [duplicate]
I am trying to create a new contact in List Manager . However, Getting the below error:
5476 15:37:38 ERROR [Sitecore Services]: HTTP POST
URL https://{websiteName}/sitecore/api/lists/2366950a-a5c2-...
3
votes
0answers
64 views
Sitecore 10.1 xConnect collection database multi-region scaling read-only performance
I have a multi-region Sitecore deployment with CDs in the US and the UK using Sitecore 8.2 with MongoDb as the xDb, like this:
UK US
CD1 ...
1
vote
1answer
42 views
Load Contact by ID in XConnect Automation Engine Context
I have created an Automation Plan and its enrollment is based on Custom Page Event.
The Plan is working as expected, but the contacts are not multiple-enrolled. Meaning that if the contact already in ...
1
vote
2answers
44 views
Experience Analytics Graphs are not loading in Sitecore 9.3
We are working on Sitecore 9.3 with SXA and having a scaled setup, 2 CMs, 4 CDs,1 Xconnect server, 1 Solr server, and initially, there were some errors on the Experience analytics tab, and that we ...
0
votes
0answers
42 views
Experience Analytic graphs (API Status code 500) after upgrade
I upgraded an instance from Sitecore 9.1.1 to 10.0
after the upgrade when I enter the experience analytics the graphs don't show
and I got those errors
The TopTenCampaignsByValue graph cannot be ...
0
votes
0answers
27 views
xConnect Custom Facet is throwing an error while getting the facet
xConnect Custom Facet is throwing an error while getting the contact contact.GetFacet call. We had followed all the steps from this article https://sitecoreamateurs.wordpress.com/2020/08/31/sitecore-...
3
votes
2answers
27 views
xConnect Identify user after Federated Auth login
I am trying to run some xConnect facet/identification code after a user logs in with Federated Auth. But it seems like all the Owin pipelines have no tracker available. And none of the Sitecore ...
2
votes
0answers
30 views
How to get EXM Campign data from x-connect odata service
My requirement is to get
triggered email campaign report data from x-connect odata api (https://xccollect/odata)
wanted to get data like : email open and click rate , bounce email,spam complain, ...
1
vote
1answer
23 views
fetch interaction from xConnect based on custom values
I'm using sitecore 9.1.1
I'm trying to get interaction which having key "PlanMemberId" in CustomValues and value is "test123" against this key.
I'm able to get interaction based on ...
0
votes
0answers
18 views
Unique contacts aren't identified when same user logged in
I'm using sitecore 9.1.1, when I was creating interaction programmatically using Sitecore.Analytics.Tracker.Current.Session.IdentifyAs("testsource", "usertest"); it was creating ...
1
vote
2answers
34 views
fetch contact from xConnect based on contact facet
I'm using sitecore 9.1.1
I'm trying to get contact who's first name is "myfirstnametest" but I'm getting count zero in result for contacts even I have record with this contact facet.
using (...
2
votes
2answers
55 views
need to add custom contact and interaction facets into xConnect using ConvertToXConnectInteractionPipelineArgs
I'm using sitecore 9.1.1.
I need to insert custom contact facet and custom interaction facet using below pipeline processor.
I have already added custom values successfully in the same processor.
...
1
vote
0answers
40 views
No contacts tracking in XConnect, anonymous or know, on standalone XP 9.2
I have a standalone Sitecore XP 9.2 instance running (on prem) that has no contacts tracking in XConnect, anonymous or known. I've checked off all the normal culprits I can think of but they all seem ...
2
votes
1answer
37 views
custom code written for ConvertToXConnectInteractionProcessor not being hit all the time
I'm using sitecore 9.1.1 and SQL server is used for xDB.
in below code I'm adding custom values and this gets executed when I close the browser and interaction is being added into xConnect by default ...
1
vote
1answer
40 views
Add custom key/value pair into CustomValues dictionary object
I'm using sitecore 9.1.1 and SQL server is used for xDB.
my concern is that sitecore also adding interaction for every page visit and instead of adding interaction using below code I just want to ...
1
vote
1answer
33 views
How to show custom data of custom page event in the experience profile instead of current page url while tracking external links using FXM?
We are using FXM to track the clicks on the external links and the data is stored in the xdb Shard Interactions table > Event Column but in the experience profile, the url shows the curent item ...
0
votes
1answer
21 views
How to get engagement points[Goals] for the logged in user [duplicate]
I have created 2 goals for each page. Now, I want to retrieve the engagement points against the contact[logged in user] from the xDB. Any solution or input would be of great help.
-2
votes
2answers
50 views
how do we configure processing server in sitecore 9.3 [closed]
I know below link but if any link for sitecore 9.3 version?
https://doc.sitecore.com/developers/82/sitecore-experience-platform/en/configure-a-processing-server.html
0
votes
1answer
38 views
Getting assembly error in search contacts and interactions
I'm using sitecore 9.1.1
I am getting error in below code:
//Total contacts
var results0 = client.Contacts.ToEnumerable().Count();
//Contacts with interactions
...
1
vote
1answer
49 views
Failed to start the Marketing Automation Engine service - installation sitecore 10
I am trying to install sitecore 10 using garphic setup but i get error.
I checked the logs of xconnect-log-MarketingAutomation and i found the below error, also i sarched about the error and i did ...
0
votes
1answer
53 views
How to identify contacts using Reactjs
I have LoginComponent in ReactJs with username and password. How can I store the logged in user details in xDB through ReactJs ?
In case if I am creating an webapi to store the details using Sitecore....
0
votes
1answer
38 views
error when builds a client configuration object for connecting to xConnect
I'm getting below error in this code:
var cfg = new XConnectClientConfiguration(
new XdbRuntimeModel(CollectionModel.Model), collectionClient, searchClient, configurationClient);
in below ...
1
vote
0answers
28 views
Sitecore List Manager default Email related rules not working
Sitecore version: 9.1 Update 1 on Azure PAAS
We are trying to create a segmented list based on OOTB rule where the contact clicked any email but after selecting this rule in rule editor window while ...
1
vote
1answer
44 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.
...
4
votes
2answers
59 views
Where to place Custom XConnect Model file in Azure
I had a custom Model JSON file in on Premise environment under the XConnect Project/App_Data/Models folder.
Now we are moving to Azure. I see there are more roles in the Azure environment like xc-...
1
vote
4answers
459 views
Sitecore 9.3 Installation failing - 'Failed to start the Marketing Automation Engine service
I am trying to set up Sitecore 9.3 XP0 locally in a VM using SIA and it is failing at Step 67 of 92 with an error failed to start the marketing Automation Engine Service.
System....
0
votes
0answers
121 views
ERROR: Exception when executing agent aggregation/aggregator( Execution Timeout Expired)
I'm getting Execution Timeout Expired I tried below with no chance :
increase the time out on the connection string.
Set ping enabled to false.
Set the Ping Maximum Response Time (seconds) to a large ...
0
votes
1answer
42 views
problem trying to install sitecore commerce experience 9.0.2
I got the following error and search online looks like it's something to do with xconnect remoting? I have disabled the xconnect site and also the
Go to C:\inetpub\wwwroot\fsni.sc\App_Config\Sitecore\...
0
votes
0answers
45 views
New Interaction doesn't show after 2nd: using IdentifyAs
I am developing a function to support tracking user behavior through a mobile app.
Below is the current scenario:
Case 1: Anonymous User 1 - Working fine:
Anonymous user visits the page, then these ...
3
votes
1answer
47 views
How to mock XConnectClient
I'm writing unit tests for a class that uses XConnectClient, which means I need to mock an XConnectClient.
I've tried the following using Moq and RandomTestValues packages:
Mock<XConnectClient> ...
0
votes
1answer
53 views
Sitecore Xconnect lock time expire issue
I am using sitecore 9.3 and facing an issue with xconnect when using identifyas in the code to identify the user using the email i got the below exception
Exception: Sitecore.Analytics.DataAccess....
0
votes
0answers
19 views
Is support for IVisitAggregationContext Interface removed in Sitecore 10 XP
In Sitecore 8.2 we used to have a reference of IVisitAggregationContext interface in AggregationPipelineArgs class which we were using in the custom processor to grab visit-related data. But when I am ...
1
vote
2answers
63 views
how to add contact to the opt-out list programmatically?
We are using Sitecore 9.1 (Update-1). We have a third-party email management system. One of our requirements is if anyone unsubscribes from the third-party email system, we have to consider their ...
1
vote
1answer
95 views
Error when deleting item: Ensure definition type did not complete successfully. ReasonPhrase: 'Forbidden', [duplicate]
I'm running SC10 XP single. I started getting the following error when deleting an item:
193784 08:17:10 ERROR Exception when executing agent aggregation/aggregator
Exception: Sitecore.XConnect....
1
vote
0answers
37 views
USE statement is not supported to switch between databases. Use a new connection to connect to a different database
I'm attempting to install xConnect OnPrem with Azure SQL.
I've updated the create user scripts with the following -
GO
CREATE USER [PlaceHolderForUser] WITH PASSWORD = 'PlaceHolderForPassword';
GO
...
0
votes
0answers
83 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
42 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
39 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 ...
2
votes
1answer
70 views
Experience Analytics doesn't display contact's interaction data created using xConnect Client API
We're migrating Google Analytics data and storing it in xDB. So, I'm creating some contacts through the xConnect client API and assigning those interaction data (that was tracked in Google Analytics) ...
1
vote
1answer
99 views
How can we add contact with custom fields to a contact list programmatically in Sitecore 9.3
I want to use sitecore 9.3 form for creating a new contact in a contact list.
The contact list should consist of below custom fields:
Email Id,
Mobile number,
Full Name
The values of these fields ...
1
vote
1answer
69 views
What are the expected behaviors for the xConnect Pools Databases?
I am looking at the xdb pools database on a 9.0.1 instance. I see 3 tables with data in them:
GenericProcessingPools
GenericProcessingPoolDefinitions
InteractionLiveProcessingPool
The ...
0
votes
0answers
57 views
Get most recently viewed pages by template
Using Sitecore 9.2, I have a scenario where I need to get the most recently viewed items for certain types of content (like author pages for example). There are no logins to this system, so all ...
0
votes
0answers
229 views
“XdbContextLoggingPlugin” XdbContext Batch Execution Exception
I am getting an SQL exception in the XConnect application.
Error:
["XdbContextLoggingPlugin"] XdbContext Batch Execution Exception
XdbContextLoggingPlugin
MessageTemplate: [{0}] XdbContext ...
0
votes
0answers
4 views
Sync token for the [InteractionFacets] table is no longer valid [duplicate]
I am getting an SQL exception in the XConnect application suddenly. ANd I am getting the error in Application insight in every minute. I have searched on the internet but didn't get any particular ...
