Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
92 views

Update New Databases on Upgrading Tridion Sites 9.6

we are Upgrading CM & CD to Tridion Sites 9.6 from 9.1. As per Upgradation Process, CM/Topology/translation - We are Providing New Database Names on the time of Exe installation process and ...
1 vote
0 answers
33 views

Tridion content service generate a massive amount of small database queries

This is a follow up question from Tridion content services has alot of open sessions with database. Original question was about dropped spans and unclosed Hibernate sessions. But the data comes out of ...
10 votes
4 answers
23k views

'Import-Module : Could not load file or assembly' when running 2013 sp1 DB upgrade scripts

I'm running the SDL Tridion 2013 Sp1 database upgrade scripts but running into the following error : Import-Module : Could not load file or assembly 'file:///C:\Tridion 2013 SP1\database\Scripts\...
3 votes
1 answer
75 views

DB Reports for Deletions

wondering if there is a way to get the below reports from DB (8.5) Edits made by a user in CMS for a period of time (Advanced search can help here, but wondering if i can get more details from DB) ...
3 votes
4 answers
793 views

A database error occurred while executing Stored Procedure "EDA_PUBLICATIONS_GETITEMSOFTYPE_83"

I have been trying to publish a Dynamic Component Presentation but for some reason it keeps on failing with the following error: When I preview the same component in the CMS getting below error: ...
0 votes
1 answer
55 views

How to use existing Topology when re-importing (and upgrading) the CM database from 2013 to Web 8.5

We have done an upgrade of development CM database (oracle) from Tridion 2013 SP1 (in a copy of the CM database) to SDL Web 8.5. Web 8.5 CME is installed and pointed to the upgraded CM database, ...
3 votes
2 answers
78 views

Does Web8.5 Database Script require Database Admin Account to run?

Our DBAs are not allowed to have full DB Admin accounts in production (Company policy). Does the Web 8.5 scripts absolutely need full DB Admin to run? Is there a list somewhere of the specific ...
1 vote
1 answer
68 views

Getting error while running PowerShell scripts for Tridion DB creation

I am getting below error on running PowerShell scripts for Tridion Content Manager Database creation: I can see there is error on Line Number 147 in Content Manager Data Base PowerShell script, on ...
4 votes
1 answer
549 views

The SQL Server edition of the target server is unsupported, e.g. SQL Azure

Having performed a fresh installation of Sites 9, I keep getting the following error: The SQL Server edition of the target server is unsupported, e.g. SQL Azure. This is shown when I confirm the ...
0 votes
2 answers
102 views

How to publish metadata-binary to Broker database?

We have a Page Metadata Schema where editors can embed a Multimedia Component. When we publish the Page to the Broker database, it seems that the binary is not published to the database (TCM id is ...
4 votes
1 answer
69 views

Is Tridion 2013 SP1 compatible with later versions of SQL Server in compatibility mode?

We found this documentation, which suggests that the latest version SDL Tridion 2013 SP1 is compatible with is SQL Server 2012 SP1: https://docs.sdl.com/LiveContent/content/en-US/SDL%20Tridion%20full%...
3 votes
2 answers
271 views

SQL Query versus CoreService

Anyone know of any issues with directly querying the Tridion CM database? I have used both direct queries and the core service. I like direct queries better because it seems to be faster and much ...
4 votes
1 answer
132 views

Timeout Expired for DecommissionPublicationTarget Tridion 8.5

The Problem with Decommissioning Publication Targets has returned in Tridion 8.5, see original Tridion 2013 Question at Timeout Expired for DecommissionPublicationTarget Any suggestions on how to ...
7 votes
4 answers
118 views

Tridion CM Usage reporting

My client would like to pull together some metrics regarding our Tridion CM usage. We're interested in the following information. Create – New (Images, Pages, Components) Edit/Update (Images, ...
10 votes
2 answers
81 views

Supported modification on Tridion Broker database

We have suggestions from our DB team to add some indexes on broker database. I know that in general database modifications should be off limits (not supported), but it looks to me that adding indexes ...
3 votes
1 answer
367 views

Multiple publishes failing with while executing Stored Procedure "EDA_ITEMS_GETPUBLISHITEMS"

We have a - typically intermittent but becoming more common - issue with Tridion publishing. The error appears to be around resolving items and that a stored procedure, EDA_ITEMS_GETPUBLISHITEMS is ...
4 votes
2 answers
48 views

Does Web 8.5 provide detailed information about CM users activities/session?

I want to generate a report on individual User’s activities like: Logged-in Information How long they remain connected to system Activities they performed or browsing details I can pull out the ...
3 votes
1 answer
114 views

Warning about multiple operations with CM database upgrade to SDL Web 8.5

We are currently doing an upgrade of a Tridion CMS to SDL Web 8.5. We took a back up of the old CMS DB, restored it in our new SQL server, and we're now running the upgrade script. However, this ...
4 votes
1 answer
147 views

Loading a list of Keywords is very slow in SDL Web 8 CME

We are using SDL Web 8.1 and we are facing a issue while accessing Keywords inside a Category which takes more then 2 min but before upgrading to Web 8 from 2013 SP1 HR1 it was quite fast. The ...
4 votes
1 answer
199 views

SDL Web8 database restore from Production to QA

We have recently upgraded to Web8.1 from 2011, we have been following the process of taking the database backup of CM and restore to lower environments periodically to have the latest data to perform ...
3 votes
2 answers
276 views

How to find out who modified publication properties like Publication URL etc.?

Is there a way to find out who has modified Publication properties fields and when? We have found that publication url was modified and pages published to wrong URL, and fixed it when we noticed. But ...
3 votes
3 answers
202 views

Issue connection with Tridion_cm

I have just installed SDL Tridion 2013 SP1 and I have found a problem when I have started the application. I get the following errors: Probably, this error comes from a problem with the connection ...
2 votes
3 answers
241 views

Tridion publishing report query

I'm working on building a report to help us audit all publishing changes over the last day. From the Tridion_CM database I've got the following: SELECT ID,ITEM_TYPE,ITEM_REFERENCE_ID,PUBLICATION_ID,...
2 votes
2 answers
293 views

Where to check the underlying database details in Tridion 2013 SP1 CMS server

For existing Tridion (2013 SP1) CMS installation is there any configuration file under the installation directory that stores the underlying database details for CMS like we have cd_storage_conf.xml ...
3 votes
1 answer
68 views

Web 8 New Topology Manager publishing to wrong Database

I've created a new Topology manager, new Discovery, Content and Deploy service as in the docs for a new site (in web 8). I had an other site already set up on the same servers. Everything seemed fine ...
2 votes
1 answer
43 views

CM database stricture change list after upgrade to Web 8

I was wondering if there is a list of all changes done on CM database after upgrade to web 8. The changes I am interested are added/removed tables and fields, store procedure updates and etc. I know ...
1 vote
2 answers
301 views

How to configure connection string for CMS database for failover DB in MSSQL server 2014

Can you please help me to configure a CMS for failover db( MS SQL 2014 ), where do I need to setup CMS db for failover DB. I tried to change under Database settings but it works only with manual ...
2 votes
1 answer
126 views

I want to create new database for the Discovery Service

I want to create a new database for the Discovery Service, can anyone tell me if there is a script provided for this in the SDL Web 8 installation media?
4 votes
2 answers
353 views

Checking publish status of items in Tridion Content Manager database

Is there an easy way to check the publish status of all items from ITEMS table in the Content Manager database? I am thinking of creating SQL query to list them all, but am not able to find Publish ...
6 votes
2 answers
99 views

How to setup auto failover for broker database clusters

Our production environment has two redundant data centers. Within each data center we have multiple web servers talking to a single SQL cluster which has multiple broker DB servers. The clustering ...
5 votes
1 answer
88 views

Upgrading to cloud database - MSDTC

Just reading the docs on upgrading to SDL Web 8.5, specifically Content Manager database support history. For cloud options like AWS & Azure, the docs mention only if your implementation does not ...
6 votes
1 answer
116 views

Broker database lock during mass publishing

We have issue where our database transactions get locked during mass publishing on live. We are running broker db in mssql. We have following configuration in cd_deployer_conf.xml file: <Queue> ...
2 votes
1 answer
59 views

Can I use same domain user "DOMAIN\USER1" for both MTS User and Default SDL Web Administrator during CMS Database installation

Can I use same domain user "DOMAIN\USER1" for both MTSUser and Default SDL Web Administrator during CMS Database installation. Reason being I only have one domain user which has admin rights and i am ...
7 votes
1 answer
77 views

Moving to new DB server on Web 8 with TopologyManager and CMS

On a Web 8 instance, the TopologyManager and CMS Databases are installed on the same DB server. The DB server will change and we will move the Databases to the new server. For the CMS, we can ...
2 votes
4 answers
365 views

Correct steps when changing CM database

So for reasons I won't go into, we recently had to re-configure our clients Tridion 2013 SP1 CM to use a new SQL Server. After the usual planning and content freeze, it basically went like this: ...
5 votes
2 answers
360 views

Clean the ghost published records

We found more than 15,000 records in table dbo.ITEMS, at broker DB, which belongs to around 10 publications. But the records related component already be deleted from CMS long time ago. So there is no ...
1 vote
1 answer
60 views

Web 8 Audience Manager Installation

While I am trying to Upgrade Audience Manager Database using the "Upgrade Extended Details in Audience Manager database.ps1" I am getting the following error."cannot bind argument to parameter 'Path' ...
0 votes
1 answer
303 views

Dynamic component publish issue in tridion 2013

We are facing an issue while publishing dynamic component from Tridion CME. Error Description : Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC ...
2 votes
1 answer
127 views

unexpected WAI Presentation_id

The following is configuration is done for WAI on the content delivery <Presentations> <Presentation Id="1"> <Host Domain="www.mysite.com" Port="80" Protocol="http" ...
2 votes
3 answers
556 views

A database error occurred while executing Stored Procedure "EDA_ITEMS.CHECKOUT"

When I am trying to check out some of the Pages in SDL Tridion 2013 SP1, I am getting below error message details. Can anyone help in resolving this issue? Just for information, We are facing this ...
2 votes
1 answer
26 views

Can I use the same Archive Manager database to archive historical versions of the same publication published to two different publication targets?

I am in the process of creating the Archive Manager DB to setup Archive Manager for a website. This website can be published to two publication targets and I was wondering if archive manager makes any ...
2 votes
2 answers
49 views

Required Database Permissions for Tridion 2013

I am providing a SQL Server for Tridion 2013. I don't have the installation media yet, but I understand this will create the database logins and users. Could anyone tell me the minimum permissions ...
5 votes
1 answer
111 views

Content Delivery DCP DB Decoding Issue

I'm working on a client project & am having some issues pulling DCPs from the broker database. I noticed an error in the deserialization process regarding malformed input (DD4T), but upon ...
3 votes
3 answers
273 views

2011 CME Database Connection Issue

OK we have recently migrated a client DEV machine from the our internal domain to the clients domain and the Tridion instance needed some re-configuration (to be expected) however I have now got the ...
-1 votes
1 answer
53 views

Getting error when updating the membership scope for each group

Created user in the Tridion 2013 sp1 and adding groups for the user and updating the membership scope for the user. While saving the user getting error :- A database error occurred while updating ...
19 votes
1 answer
512 views

explanation of QUEUE_CONSUMERS and QUEUE_FILTERS tables

Aside from these blog postings: http://yatb.mitza.net/2012/10/slow-db-performance-on-content-manager.html and http://www.mrgn.co/2012/10/tridion-error-unable-to-notify-server/ I can't find details on ...
1 vote
1 answer
59 views

Connector to Tridion Data bases

As I know there are three DB's are used in tridion. Tridion LOG DB, Tridion CM DB, Tridion Broker. I am looking if is there way to exctract data e.g. using some connector apart from using API. And ...
7 votes
3 answers
214 views

Facing issue with our Tridion eventing module on component save and close with multiple user

I am facing some issue with our Tridion eventing module. Please let me explain the issue. Background: We have approx. 70-80 users who create content via CMS where it’s expected that more than 70% of ...
5 votes
1 answer
238 views

Unable to retrieve item with id

We have this problem when we open some pages in Tridion and to publish them. Does anyone know what might be the cause? Thanks a lot.
0 votes
2 answers
337 views

Database issue after taking TCM backup

we have taken offline DB backup for the TCM and after hitting the tcm getting the DB issue the error is :- A database error occurred while executing Stored Procedure "EDA_TRUSTEES_GETTRUSTEETOKEN". ...