Questions tagged [sql-database]

Question about the Sitecore SQL databases - content, reporting, sessions, ...

Filter by
Sorted by
Tagged with
0 votes
1 answer
60 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 ...
user avatar
0 votes
1 answer
45 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 ?
user avatar
  • 485
2 votes
1 answer
31 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 ...
user avatar
  • 4,691
0 votes
2 answers
38 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,...
user avatar
  • 33
0 votes
0 answers
68 views

Restore Sitecore database backups into docker mssql container instead of default Sitecore 10.2 database?

Is there any way to configure existing on-premise Sitecore database using sql backups into docker containers instead of default Sitecore 10.2 database? We want to use our own on-premise 10.2 database ...
user avatar
  • 499
1 vote
0 answers
121 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 be using this to deploy to an Azure SQL server. I ...
user avatar
0 votes
1 answer
36 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 ...
user avatar
0 votes
0 answers
118 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 ...
user avatar
1 vote
1 answer
53 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 ...
user avatar
2 votes
1 answer
44 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 ...
user avatar
0 votes
1 answer
39 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 ...
user avatar
0 votes
1 answer
161 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 ...
user avatar
  • 33
1 vote
0 answers
56 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 ...
user avatar
3 votes
3 answers
330 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 ...
user avatar
1 vote
1 answer
237 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:\...
user avatar
2 votes
3 answers
250 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. ...
user avatar
0 votes
1 answer
100 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’...
user avatar
1 vote
1 answer
107 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]....
user avatar
0 votes
0 answers
203 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. ...
user avatar
  • 345
1 vote
1 answer
200 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 ...
user avatar
1 vote
0 answers
58 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 ...
user avatar
  • 186
2 votes
0 answers
108 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....
user avatar
  • 71
1 vote
0 answers
118 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 ...
user avatar
  • 12.9k
3 votes
3 answers
2k 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 ...
user avatar
  • 421
1 vote
1 answer
67 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 ...
user avatar
  • 480
2 votes
1 answer
118 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 ...
user avatar
  • 123
1 vote
5 answers
854 views

Access Custom SQL Database in Sitecore context

I'm using Sitecore 9.1.1. I have created a local custom database that have some tables with some records on SQL server. I need to programmatically insert and retrieve some records from this database ...
user avatar
  • 577
2 votes
0 answers
137 views

Migrate SQL Database to xConnect

Environment: Sitecore 9.2.0 and Data Exchange Framework 3.0 I want to import the data from SQL Database to xConnect using the Data Exchange Framework. SQL DB has a table called Users which contains ...
user avatar
  • 543
1 vote
2 answers
498 views

Cannot open database error every time

I have a local Sitecore 8.2 instance. Whenever, I browse this instance for the first time in a day or each time I deploy a dll, it throws this error: Cannot open database "MySiteSitecore_Web" ...
user avatar
  • 2,573
1 vote
0 answers
151 views

How to execute stored procedure using Sitecore.Data.DataProviders.Sql.SqlDataApi

I am trying to execute SQL stored procedure from C# code using Sitecore data providers. I am using the SqlDataApi class from Sitecore.Data.DataProviders.Sql but not finding any method which accepts a ...
user avatar
5 votes
0 answers
50 views

Is the Session DB Performance Boost still necessary?

I see that the section on optimizing SQL Session DB Performance that existed in the Sitecore 8.1 documentation no longer exists in the documentation for 9.1. Is this because the step is no longer ...
user avatar
  • 96
0 votes
1 answer
97 views

Access Rights required for Session database

I configured private and shared session using SQL Provider, following this link After I deployed the Sitecore.Sessions.dacpac file, I tried to create a user for the database but it was failing with ...
user avatar
  • 443
1 vote
2 answers
190 views

Best practices - Sitecore website in Prod - local or remote Sitecore databases?

Judging by how SIM works, and how pervasive SIM is... I assume the most common practice for QA and Prod, is the Database is local/on the same machine as the website. Is this indeed the suggested/...
user avatar
2 votes
1 answer
305 views

Where does SIM install the databases when installing a new Sitecore instance?

This must be documented somewhere but I'm not finding any good documentation on what SIM does when you install Sitecore 8.2 with it. I understand it creates a new web root folder on your local ...
user avatar
4 votes
1 answer
384 views

How To: Refresh environment A(QA) from environment B(Prod) after they're out of sync

I'm sure you've been in this spot. Client has a QA and a Prod environment, but over time they stopped using best practices, and they have only been authoring content/template changes in Prod, nothing ...
user avatar
2 votes
3 answers
1k views

msdeploy.exe : Error: .Net SqlClient Data Provider: Invalid object name 'Blobs'

I'm trying to install Sitecore Commerce v9.2. I had a few issues that I solved earlier. However, right now I'm getting a database error. When I check the database I can see two new Commerce ...
user avatar
0 votes
0 answers
239 views

Application Insights sql dependency error on History_GetTaskStateById

When looking into application insights a see most of the errors coming from: SQL: [xdb_processing_tasks].[History_GetTaskStateById] Returning error 50000 running Sitecore 9.0.2. The stored procedure ...
user avatar
  • 365
1 vote
3 answers
617 views

What is the purpose of Reference Database and Share Databases in Sitecore 9.x?

Sitecore 9.2 Once we installed Sitecore 9.x we can find reference database (sitecoreInsatnceName_ReferenceData) and share databases (sitecoreInsatnceName__Xdb.Collection.Shared0,...
user avatar
1 vote
2 answers
962 views

How to remove media item from both blobs table and items table at the same time from sitecore master db?

I have added some images in sitecore media library. Those images are getting added in both dbo.Blobs and dbo.Items tables. I wanted to delete the image data from both the tables.But I don't know how ...
user avatar
0 votes
2 answers
860 views

Installation Sqlcmd: Error - The client cannot connect to the server because the requested instance was not available [duplicate]

I'm trying to install Sitecore 9.1 Update 1 on my local machine. The script actually installs 7 databases like (MarketingAutomation, Messaging, Reporting), however when it comes to Sitecore databases ...
user avatar
1 vote
0 answers
71 views

Error setting up mirroring on SQL databases after Sitecore upgrade

We have upgrade our website from Sitecore 8.2 to 9.1.1. As per sitecore upgrade guide I installed the XConnect separately and also restored Messaging, Processing Pools databases using dacpac files. I ...
user avatar
2 votes
1 answer
146 views

Sitecore Desktop database selection shows non-existent database

On my instance of Sitecore 8.2 Update 7, the database selection list in the lower right hand corner show two webs: There is only one web in publishing targets: And my connection strings only have ...
user avatar
0 votes
1 answer
111 views

What is the significance of end of Mainstream Support on SQL 2014 SP2 for Sitecore 8.x

According to Microsoft SQL 2014 SP2 loses Mainstream Support from Microsoft in July 2019. (https://support.microsoft.com/en-us/lifecycle/search/17645) Many Sitecore environments utilize this version ...
user avatar
  • 105
1 vote
0 answers
42 views

Sitecore 8.2 update 3 mongodb conversion into sql server reporting db

We are using the Sitecore 8.2 update 3 version with MongoDB. The data is being captured in the MongoDB but Fact_Conversions table has no data. What actually is to be done to have data in this table....
user avatar
  • 183
0 votes
3 answers
571 views

Core and Master databases keep falling under recovery_pending state

We are on an upgraded instance and restoring Core and Master databases from an already running environment to a new one we are building. After the DB restore as soon as we start the app pool and ...
user avatar
  • 2,534
2 votes
2 answers
231 views

Should TransientRetryer be enabled for SQL Azure?

In Sitecore.config for Sitecore 9.0.2 I see the following comment: <!-- RETRYER Example transient retryer: <retryer disabled="false" type="Sitecore.Data.DataProviders....
user avatar
  • 317
0 votes
0 answers
81 views

Eventqueue query crashing the CD site

I have a single CD CM 8.2 instance of sitecore. We have a job that is running at a particular time everyday which publishes around a 1000 items. Our CD server crashes everytime the job runs and the ...
user avatar
3 votes
2 answers
602 views

Secure Azure SQL database connection using a managed identity

We are currently hosting our Sitecore 9.1 initial release on premises, but want to move the complete solution into Azure. We want to use public services and not put our solution in an ASE. To secure ...
user avatar
2 votes
1 answer
234 views

YSOD When trying to open the login page - "No process is on the other end of the pipe" [closed]

I have 12 different instances (test purpose only) using this same SQL Server. All of the sudden, one of those (which was working fine until yesterday) started giving me this error when I try to open ...
user avatar
  • 2,211
1 vote
3 answers
699 views

Can SC_TICKET* keys be purged from the Properties table, and have tickets been moved elsewhere?

I'm troubleshooting an issue with slow logins on a Sitecore instance. As part of that investigation I've found a number of posts - such as Sitecore client and logon is very slow (properties table ...
user avatar
  • 1,398