Questions tagged [sql-database]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
14 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 ...
0
votes
0answers
27 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
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 ...
0
votes
0answers
38 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. ...
1
vote
1answer
51 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 ...
1
vote
0answers
40 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 ...
0
votes
0answers
24 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 ...
1
vote
0answers
80 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....
0
votes
0answers
34 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
2answers
444 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 ...
0
votes
1answer
34 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 ...
1
vote
1answer
66 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 ...
0
votes
5answers
266 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 ...
2
votes
0answers
127 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 ...
1
vote
2answers
260 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" ...
1
vote
0answers
71 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 ...
5
votes
0answers
40 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 ...
0
votes
1answer
52 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 ...
1
vote
2answers
129 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/...
2
votes
1answer
268 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 ...
4
votes
1answer
214 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 ...
2
votes
3answers
524 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 ...
0
votes
0answers
149 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 ...
1
vote
3answers
291 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,...
0
votes
2answers
501 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 ...
0
votes
2answers
512 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 ...
1
vote
0answers
49 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 ...
2
votes
1answer
86 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 ...
0
votes
1answer
69 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 ...
1
vote
0answers
40 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....
0
votes
3answers
369 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 ...
2
votes
2answers
158 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....
0
votes
0answers
60 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 ...
2
votes
2answers
392 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 ...
2
votes
1answer
152 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 ...
1
vote
3answers
430 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 ...
1
vote
1answer
210 views

Why is it important to have Core DB in Content Delivery Environment if i have static content sites?

What is the significance of having core database in CD Environment and which are all tables being used from CD Environment? Do we really need core DB for the below scenario? Sites are only ...
0
votes
1answer
46 views

Get WFFM values and transpose them into Pivot table

I have a situation where I am stuck to create a query for fetching data from Wffm DB as Pivot, so please help FieldName Value -------------------------------- FirstName Joe MiddleName S ...
0
votes
1answer
333 views

Does sitecore 9.0.2 supports Azure SQL managed instance(Azure SQL Paas)?

Does sitecore 9.0.2 supports Azure SQL managed instance(Azure SQL Paas) ?
8
votes
2answers
1k views

Move users / roles / passwords to new core database

We are migrating from Sitecore 8.2 to 9.0.2 and decided to start with "fresh" core, web, and master databases, migrating content on top of blank databases. What is the most efficient method to ...
0
votes
1answer
576 views

User Profile table in SQL

I am saving a user profile and one of the field is "UserLanguage" which is saving fine Context.User.Profile.Save(); The save method is working as expected but where the User Profile being saved in ...
4
votes
1answer
354 views

SQL Azure Master DB - masteruser password discrepancies

I have 2 Sitecore 9.02 Scaled Azure environments. They are PROD and UAT. All the databases are SQL Azure. The marketing team have been adding a lot of content on PROD and I want to take a bacpac of ...
1
vote
0answers
249 views

Rebuilds Links Database exception: This SqlTransaction has completed; it is no longer usable

When attempting to rebuild the links database on the master database I'm getting the following exception: Job started: RebuildLinkDatabasesIndex|System.InvalidOperationException: This SqlTransaction ...
0
votes
1answer
274 views

Where is the value “Item owner: sitecore\smith” from “Quick Info” living in back-end SQL tables?

I'm unable yet to locate a particular "Item owner: sitecore\smith" value I see well-and-alive in Content Editor "Quick Info" of an item, but not in the SQL Server backend tables. I often pull a ...
0
votes
1answer
21 views

Sitecore DB: Can't delete Preview DB table from SQL Server 13.0.400

I first duplicated the original Sitecore Web DB and just renamed to Sitecore Preview DB. Now that I noticed I accidentally copied the Sitecore Master DB instead of Web DB and I am trying to delete the ...
3
votes
1answer
624 views

xConnect cannot reach SQL Server

I noticed no data was being generated in the Experience Profile. I went to the site and tried to generate some test data by filling out a form and received an error "Updating Contact Failed". I ...
2
votes
1answer
357 views

Sitecore 9 Update 2 - Azure Database Type and Sizes

We are in process of designing the infrastructure architecture to host sitecore 9 update 2 in azure. This requires us to appropriately size all the databases for Sitecore 9. Also I can't find any ...
3
votes
0answers
148 views

Sitecore 9.0.2 Installation with SQL Windows Authentication [duplicate]

We need to install Xconnect Xp0 instance (Sitecore 9.0.2) with SQL Windows Authentication, We don't have access to the SQL Server with SQL Authentication enabled. Can you Please help what all changes ...
5
votes
2answers
556 views

Why Sitecore 9 xDB on SQL server 2016?

My curiosity is to know more about the features which Microsoft has provided in the SQL server 2016 version which also allows the Sitecore to implement the xDB on the SQL Server 2016 itself, which ...
0
votes
2answers
390 views

What are the databases Installed by Sitecore Experience Commerce 9.0.2?

My motive behind asking this is, trying to understand the roles and responsibilities of each databases and differentiate them from the other database(Sitecore Experience Platform).