Questions tagged [sql-database]

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

21 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
5
votes
0answers
196 views

Sitecore 8.2 using analytics data in code

I have followed the answer here But I get a null reference exception if I do not create an instance of the ReportDataProvider. And when I do create an instance I am getting an error in the ...
2
votes
0answers
124 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
1answer
48 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
39 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 ...
1
vote
0answers
79 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....
1
vote
0answers
66 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 ...
1
vote
0answers
47 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 ...
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....
1
vote
0answers
238 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 ...
1
vote
0answers
70 views

Sitecore 8.1 with SQL Always ON

I know Sitecore 8.1 is not compatible with SQL Always ON as per Sitecore documentation. That is a feature released with 8.2. But, would anybody know why specifically it wouldn`t work? Thank you
1
vote
0answers
341 views

Amazon RDS and SQL Session State

I am setting up an environment with the databases stored on Amazon RDS. I am running into a problem with using SQL Session State. I get the YSOD with this error: Parser Error Message: Synonym '...
0
votes
0answers
12 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
24 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
32 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. ...
0
votes
0answers
23 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
0answers
33 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
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 ...
0
votes
0answers
144 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 ...
0
votes
0answers
59 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 ...
-1
votes
1answer
211 views

Could not find file …\Temp\…\Sitecore.core.dacpac

I am trying to package a local instance of sitecore 9, and keep running into an error after running the script provided by Sitecore. The error is as follows System.IO.FileNotFoundException: Could ...