Questions tagged [sql-database]
Question about the Sitecore SQL databases - content, reporting, sessions, ...
0
votes
1answer
26 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 ...
0
votes
0answers
25 views
Mapping tables for Mongo Db “Interactions” Collections in sitecore reporting DB
We have the requirement like build the custom dashboard for page visits & clicks using sql reporting database, how to map the existing mongo db collection called "interactions" with reporting db ...
1
vote
0answers
29 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
97 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
48 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
38 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
vote
1answer
58 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
57 views
YSOD When trying to open the login page - “No process is on the other end of the pipe”
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
1answer
58 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 Env and which are all tables being used from CD Env? Do we really need core DB for the below scenario ?
sites are only marketing sites , no ...
0
votes
1answer
31 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
80 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) ?
7
votes
2answers
254 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
0answers
18 views
No read/write support with on prem Always On Availability Groups?
I have an on-prem install of SC 9.0.2 with an Always-On AG setup. Whenever I fail the primary, I notice it takes a few minutes for Sitecore to pick it up. In those few minutes, I get a yellow screen ...
0
votes
1answer
163 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 ...
2
votes
1answer
99 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
86 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
77 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
219 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
172 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
62 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 ...
4
votes
2answers
380 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
182 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).
7
votes
1answer
344 views
Why Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection.ShardMapManager databases in Sitecore 9 are not Partially Contained?
I am wondering what are the reasons or maybe technical limitations all of Sitecore 9 databases to be Partially Contained except Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection....
2
votes
1answer
184 views
Rundown of Sitecore 9 XP SQL databases?
Could someone provide a rundown of Sitecore 9 XP SQL Server databases and their purpose? For example "Xdb.Processing.Pools"?
5
votes
1answer
144 views
Migrate SQL DB to Azure SQL
We are facing issues while moving an existing Sitecore master db from an on premise SQL Server instance to an Azure SQL Server. The BACPAC file is almost 5 GB.
The above error appears on
- Enabling ...
18
votes
2answers
2k views
Mongo vs SQL Server with Sitecore 9 Update 2
Sitecore recently launched the version 9.0.2 which supports the MongoDB for xConnect.
Now, for a greenfield project which needs to kickoff on Sitecore 9.0.2, we have a choice between MS SQL Server or ...
3
votes
2answers
186 views
Which databases does Sitecore 9.0.2 need for CMS only mode?
We are looking to roll out a deployment of Sitecore 9.0.2 in CMS only mode. Does it need all databases to run or can it work off:
Core
Master
Web
I'm happy we can run session inProc (provided thats ...
0
votes
1answer
44 views
Delete old records from WFFM 2.4 configured with Sitecore 7.2
We are using WFFM 2.4 with Sitecore 7.2 and have "save to database" action in many forms.As WFFM database size is more then 21 GB now, I am looking a script to remove old records. Please share if same ...
1
vote
0answers
57 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
2
votes
1answer
125 views
Why Sitecore 9 Azure installation having 5 different database ? Not able to connect to these database using local SQL MS (Sitecore PaaS)
When sitecore 9 using new Azure setup has been installed there are 5 different database servers. I want to know why we have different database for Forms and individual database servers.
Also I am ...
1
vote
2answers
62 views
Can I have/install 2 sets of Sitecore databases on the same database server (SQL)?
I am planning to share the same AWS RDS (SQL) for 2 different sets of Sitecore databases. So I will have 2 Webs, 2 Cores and 2 Masters DB. Could anyone confirm if this is possible? Why or why not? The ...
3
votes
1answer
187 views
How to find out how many items are in media folder by querying the db
Is there a quick way of checking how many child items there are by querying the sitecore master db?
8
votes
1answer
255 views
Sitecore Site using custom database on custom site
Sitecore 9.0.1
I've tried to create a new site definition that's associated with a custom publishing target database.
I have the database registered, publishing targets built, content completely ...
2
votes
1answer
390 views
Sitecore Custom Databases for user generated content
I need to store a set of information (for example, poll results, article comments, etc,).
I would like to use the Sitecore pattern to manage information (templates, items and content tree) in order ...
0
votes
1answer
138 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 ...
0
votes
1answer
115 views
SQL migration while upgrading Sitecore 8.1 to Sitecore 9 [duplicate]
I have a some instances running on Sitecore 8.1 .I want to upgrade these instances to Sitecore 9.1.
I know that I should use MS-SQL-2016 to support XDB.
I want to install Sitecore-9.1 directly and ...
1
vote
2answers
267 views
Sitecore Core database User table restoration
We have upgraded the application from 7.2 to 8.2 Post restoration we were not able to connect to Sitecore admin console. For accessing executed a query to update the admin account password but somehow ...
2
votes
2answers
1k views
Setting up multiple publishing targets
I have a newly setup XP1 Sitecore 9.0 environment.
It has single core, master and web databases currently.
I’m looking to create a new publishing target/CD server for staging/UAT.
I’ve seen various ...
5
votes
2answers
847 views
'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step
I'm trying to install Sitecore 9 Update 1 XP0 topology and everything looks great until the step
CreateShardApplicationDatabaseServerLoginSqlCmd
The server I am running the installation was ...
1
vote
2answers
203 views
SqlShardingDeploymentTool causes Sitecore 9.0 update 1 installation to fail during SIF installation
I'm trying to setup a Sitecore 9.0 update 1 installation on my local machine using
windows 10
Solr 6.6.2
SQL Server 2016 SP1 Sql Express 2017
SIF-less 0.6.0.0
Despite a couple of annoying hickups I ...
4
votes
1answer
246 views
EXM databases setup - minimal rights
I am upgrading my Sitecore isntance from 9.0 initial to update-1. In this process I had to deploy the databases for EXM (exm.master and messaging) as that is new in this version. I used the dacpac's ...
4
votes
1answer
100 views
Can I restore the Recycle Bin from a backup after using the Express Migration Tool? [duplicate]
We recently discovered that our Recycle Bin no longer contained items before November 2017, when we performed a Sitecore upgrade using the Sitecore Express Migration Tool (version 2.0 at the time).
...
2
votes
1answer
749 views
Sitecore CMS - Timeout expired error
I have a Sitecore instance Version 8.2 Update 3 in my local PC. When the CMS or live is not visited or idle for a while and I browse it again, the page doesn't load and shows this error:
Cannot ...
1
vote
1answer
200 views
Which sql database contains the item's display name?
Please help me know which sql database contains the Sitecore's item display name?
6
votes
2answers
2k views
What version of SQL Server can I use on Sitecore 9
I was wondering what version of SQL Server is best used (or allowed to be used) with Sitecore 9: SQL Web or Standard?
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-...
4
votes
1answer
287 views
Database Server version while upgrading to Sitecore 9
I have a few Sitecore instances running on Sitecore 8.2/8.1 with databases on MS SQL 2012 and MongoDB for the xDB.
I want to upgrade this instance to Sitecore 9. As I need MS SQL 2016 for the xDB I ...
5
votes
0answers
154 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 ...
1
vote
0answers
247 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 '...
2
votes
1answer
1k views
Synonym 'Applications' refers to an invalid object
After adding SQL Server private sessions storage I get this error:
Synonym 'Applications' refers to an invalid object
Here is the relevant web.config section:
<sessionState mode="Custom" ...
