Questions tagged [sql-database]
Question about the Sitecore SQL databases - content, reporting, sessions, ...
148
questions
2
votes
1
answer
128
views
Sitecore XP 10.3.1 content updates on remote (replicated) CD server are always one version behind
QUICK SUMMARY:
We are trying to set up a remote CD server near China using SQL Server Transactional Replication. We almost have it working but are noticing that when we update an item, the remote CD ...
- 121
2
votes
4
answers
102
views
Challenge in SQL JSON_VALUE to Query XDB.Shards: Assistance for the xdb_Collection.Intreactions.Events Column
I am currently endeavouring to query XDB.Shards in order to generate a custom analytics report tailored to meet the specific requirements of our clients.
My attempts to utilize JSON_VALUE for querying ...
- 398
1
vote
0
answers
59
views
Sitecore 10 ExperienceForms on Form Submit not inserting data into Database
I have built a Sitecore 10.1 form with multi page level which includes upload file and google captcha.
On submit Button I have attached the following action (Save Data, Send Email with Attachment, ...
- 21
0
votes
1
answer
57
views
Sitecore DR Database Question
Setup:
Hello I have a DB question regarding setting up Sitecore 10.3 in Azure app service in an active/active configuration for DR. The idea is for CD instances in site A and site B (different zones) ...
- 101
0
votes
0
answers
49
views
Azure recommends creating an index of [VersionedFields] table in SQL Database
I was recently checking a SQL Database in Azure and noticed this recommendation:
According to the Microsoft docs on "create index" recommendations, they do have mechanisms in place to ...
- 2,146
0
votes
0
answers
63
views
Identical Queries To Find Data Folder
After an upgrade to 10.3 we started to see identical SQL queries, which put a lot of stress on the SQL server. The query:
exec sp_executesql N' SELECT [ID] FROM [Items] WHERE [ParentID] = @parentId ...
- 335
0
votes
2
answers
194
views
How does Sitecore propagate events to the core database on CM and CD servers?
How does Sitecore propagate events to the core database on CM and CD servers?
I'm trying to understand the technical details of how Sitecore propagates events like item:added, item:published etc to ...
- 129
0
votes
2
answers
339
views
How the Sitecore item field values are stored in Sitecore content databases?
How the Sitecore item field values are stored in Sitecore content databases and which table we can see the data?
- 461
0
votes
1
answer
134
views
Docker cd service intermittently fails to start
I am running SQL from my host machine rather than via the OOTB mssql service. I did this by customizing the database query strings in my docker compose override file:
cd:
environment:
...
- 2,146
0
votes
1
answer
555
views
Sitecore 10.3 with Sql Server compatibility
Believe Sitecore 10.3 compatible with MS Sql 2022 considers upward compatibility? If yes, do we need to run the database upgrade scripts provided by Sitecore?
Note: Sitecore Compatibility table does ...
- 347
1
vote
0
answers
31
views
seeing this error after sitecore installtion ,local setup Could not find configuration node: databases/database[@id='web_am'], what could be the issue [duplicate]
I am facing issue on doing local setup for this sitecore, Could not find configuration node: databases/database[@id='web_am']
not sure why and where exactly this issue is occuring,and what could be ...
1
vote
3
answers
594
views
How to find recently published items in SQL table
Is there a way to find which items were recently published by querying the SQL server tables directly?
I have tried looking at the SQL server but could not figure out which table stores this ...
- 421
0
votes
1
answer
37
views
Am I wrong or the horizon-integration-xp1-assets:3.0.0-ltsc2022 is missing the module/db folder?
It looks that horizon-integration-xp1-assets:3.0.0-ltsc2022 is missing the module/db folder. Attached is LTSC2022 vs. 1809 Databases Deployment:
LTSC2022:
Step 8/13 : FROM ${...
2
votes
1
answer
638
views
Sitecore Docker Development Image for MS SQL Server 2019
The Sitecore container registry contains mssql-developer images for Windows OS targeting only MS SQL Server 2017 (see full list here).
The Microsoft Artifact Registry contains only MS SQL Server ...
- 2,624
2
votes
2
answers
507
views
New Publishing Target database not populating when published to
I've created a new Publishing Target and associated database, but I've run into an issue that I can't seem to solve. The new target, "review", is present but won't populate on Publish. On ...
- 41
1
vote
0
answers
611
views
mssql-init container not able to connect with mssql container
While trying to setup XMCloud in local, mssql-1 container is build and is healthy. mssql-init container throws the below error
2023-03-05 11:12:01 Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL ...
- 56
2
votes
1
answer
245
views
Creating custom database in Sitecore managed cloud using containers
we are using Sitecore 10.1 MCS using Containers. We have requirement to create custom DB.
In order to deploy this DB on SQL server, we have created a custom image containing a dacpac file. Below is ...
- 49
1
vote
1
answer
270
views
Unable to locate the uploaded document using Sitecore Forms
I have created a Sitecore form where I am added a File Upload button and uploaded a file. Also, I have used the Save Data option to save the data to the Database once I click submit button.
Now I can ...
1
vote
2
answers
55
views
Installing SPE to managed cloud
We are upgrading to 10.2 and are using Sitecore Managed cloud (aks) as our production host.
We would like to use the SPE module and have got this working fine locally in docker, however in aks our ...
- 488
2
votes
2
answers
896
views
Duplicate Content Items appearing during Sitecore Upgrade to 10.2
We are in process of upgrading Sitecore 8.2 to 10.2
Have ran the upgrade scripts on the existing databases as mentioned in the Upgrade guide. In the Sitecore Content Editor, its displaying duplicate ...
- 179
2
votes
2
answers
127
views
What is the meaning of some Tables in the Reporting database?
I am working with Sitecore Reporting Database to analyze the website, but I don't know the purpose of each tables and their relationship.
It would be great help if someone share some documents around ...
- 23
1
vote
1
answer
107
views
Commerce database size keep on drastically increased in every 3 months. i.e. 500GB
We have commerce in place for one of our project. On dev and UAT environment, commerce db file keep on drastically increased in every 3 months. i.e. 500GB in every 3rd month. I don't think, it is a ...
- 2,933
3
votes
1
answer
314
views
SC 10.2 Exception when trying to view xdb data on local installation, Invalid column name 'Converted'
I installed a local instance on Sitecore 10.2 using SIA, and I performed the upgrade scripts on the Core, master, and web databases, since it is a local instance I didn't really care about the ...
- 531
0
votes
1
answer
381
views
Input Validation on Sitecore Form Fields to prevent SQL Injection
We are using Sitecore 9.3 and the site is live.
We have forms on our site which have radio button and text fields.
The forms were created using Sitecore Forms.
We got few malicious submissions on our ...
- 629
0
votes
0
answers
82
views
How can I use Commerce API in order to add data to the Shared Environments database?
I made a Sitecore API and registered a Router, and after that, I called it through PostmanAPI. I write a command process to add data to the database but follow the default when inheriting from ...
0
votes
1
answer
738
views
Server Error in '/' application. Parameter name: sessionStateBehaviorResolver - Sitecore 9.3
I am having issues with the connection of Sitecore after I tried to connect VS Studio 2019. The Solr is running and my server seems fine. Sitecore was running just fine until I tried to build a ...
0
votes
1
answer
122
views
Is there any way to specify SQL server version in mssql image?
scr.sitecore.com/sxp/sitecore-xp1-mssql:10.0.1-ltsc2019 image is installing SQL server -v 2014. Is there any way to specify version 2016 or different image tag which will install 2016 ?
- 527
2
votes
1
answer
219
views
How to connect to MSSQL hosted in Sitecore AKS Infra
I am trying to find a way to run SQL queries in MSSQL that is hosted in a container as part of AKS. I did not perform the deployment, but I have access to the resources within Azure. It uses a mostly ...
- 4,971
0
votes
2
answers
128
views
Provision new Azure PaaS staging environment as a copy of Production
Our current production environment is XP 9.1.1 scaled on Azure App Services PaaS.
We need to quickly provision a new staging environment as an exact replica of current production one.
As you are aware,...
- 53
2
votes
0
answers
537
views
Hard Time Creating mssql-init image with Multiple Modules on XP1
I'm trying to create an mssql-init image for XP1 that will install the following components:
SPE module
CH connector
SXA module
Coveo
Coveo SXA
I'll use this to deploy to an Azure SQL server.
I ...
0
votes
1
answer
162
views
How can I import database from newer sqlserver version
I have a set of databases that is from SQLServer 2017 and I am trying to import the master and core databases into a SQLServer 2014. Also, it is on a Sitecore 8.2 U7 for both instances.
Not sure if ...
- 303
0
votes
0
answers
427
views
Login failure for collection user after migrating to Azure SQL
"login failed for collectionuser" errors appear after migrating our Sitecore 10.1.1 databases from self-hosted SQL Server on VM to Azure SQL Database. The site itself is working, but ...
- 127
1
vote
1
answer
107
views
Sitecore SQL Migration to Azure is Blocked
We have an on premises instance of Sitecore 10.1.1 and want to move the databases from SQL Server on VM to Azure SQL Database. We are leaving the Sitecore sites on VM for now.
A migration blocker in ...
- 127
3
votes
1
answer
83
views
Stopping Sitecore application for server fixes
We got recommendation from Infra team for disk host cache configuration change on Sitecore SQL database servers. Basically change is Disk host caching should be read\write for OS, read\only for data ...
- 851
0
votes
1
answer
158
views
Missing items from Sitecore, but when I try and import them via a package, wizard reports the item already exists
I'm trying to track down some content items that appear to have gone missing from a client's Master database. Luckily they still exist in a different publishing target, so I created a package that ...
0
votes
1
answer
376
views
How to resolve SQL Injection flaw in sitecore.logging.dll
We ran a Veracode scan on our Sitecore solution and it has identified that the sitecore.logging.dll has SQL injection vulnerabilities.
A full description here:
SQL injection vulnerabilities occur when ...
- 43
1
vote
0
answers
83
views
Not able to create Web DB on Separate Web SQL server
We are installing Sitecore 9.3 using XP scaled topology, and while setting up the CM server we have to install only the Web Database to the Web SQL server and other Databases (Master, Core, Experience ...
- 310
4
votes
3
answers
639
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 ...
- 125
1
vote
2
answers
895
views
"Execution Timeout Expired" exception while installing Sitecore 10.1
I was trying to install the latest Sitecore 10.1. While installing it, I got the below exception.
[-------------- XConnectXP0_InstallWDP : WebDeploy ---------------------------]
[WebDeploy]:[Path] C:\...
- 2,933
2
votes
3
answers
538
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.
...
- 193
1
vote
1
answer
250
views
Sitecore PaaS Web DB spikes
We’ve just migrated from Sitecore 8.2.5 on-prem to 9.3 Azure PaaS. Performance seems ok most of the time, but we’re seeing regular spikes to 100% DTU on the web db.
The db is standard S2 50 DTU and we’...
- 11
2
votes
1
answer
214
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
0
answers
361
views
Sitecore 9.3 EXM - SQL timeout issue
While doing Marketing automation in the send email step I am seeing below error in the logs. It is continuously attempting to send email and logging this error. It is able to send the email sometimes.
...
- 427
1
vote
1
answer
390
views
Is creating custom tables in the Sitecore content database bad?
We have a client that would like to create custom tables within one of the Sitecore content databases, either master or web. Is that a good or bad idea? My own opinion is that is a bad idea, for ...
- 314
1
vote
1
answer
89
views
Sitecore 9.1 Content tree gets wiped out
I am facing a weird issue in my local instance the content tree home node subitems are getting deleted in a random frequency. I am restoring the master database every time this happens.
I am running ...
- 320
2
votes
0
answers
194
views
Getting exception while running the reporting database rebuild tool
I am trying to rebuild the reporting database using the URL, https://abc.com/sitecore/admin/RebuildReportingDB.aspx but every time getting the below error.
The version of Sitecore we are using is 9.0....
- 71
2
votes
0
answers
283
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 ...
- 13.2k
4
votes
3
answers
4k
views
Login failed for user 'masteruser'
I was moving my Sitecore 9.2 QA database in UAT in Azure PaaS. I have moved the web & master database and renamed the databases to UAT's database name.
In connectionString.config we have changed ...
- 467
1
vote
1
answer
97
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 ...
- 520
2
votes
1
answer
154
views
Most cost effective way to add custom SQL server tables/database to Sitecore 9.1.1 PaaS installation
I'm looking for some guidance please, we have a small (~500Mb) custom SQL server database that we need to run alongside the standard Sitecore 9.1.1 databases.
I'm also new to Azure so I apologies if ...
- 153