Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Warner Soditus's user avatar
15 votes
2 answers
560 views

Timeout in the TridionUploadAssembly

I have a timeout (around 30 secs) when using the TcmUploadAssembly tool. Which timeout setting can I change to increase this? Specifying a longer timeout in the command line of the TcmUploadAssembly ...
robrtc's user avatar
  • 10.2k
12 votes
2 answers
876 views

Oracle Content Delivery CreateTridionSYSUser.sql errors

I have an Oracle 12.1.0.2 DB running on RHEL 7. As I understand it, the first step of setting up a CD delivery database is to create the TRIDION_SYS user. When I log in to the db via sqlplus with "...
Mark Williams's user avatar
11 votes
2 answers
196 views

Workflow Process Histories

In the database, there is a table WFL_PROCESS_HISTORIES - Does the part of the Purge Tool to clear the workflow process histories simply clear down this table, or are other changes made to the ...
Stef Robinson's user avatar
11 votes
1 answer
496 views

Tridion 2013 SP1 and PaaS databases - Azure SQL & Amazon RDS

Looking at prerquisites etc. for installing Tridion Content Manager "in the cloud" and would like to double check a conclusion regarding Platform as a Service (PaaS) database options such as Windows ...
Neil's user avatar
  • 6,698
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 ...
Marko Milic's user avatar
  • 8,930
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\...
johnwinter's user avatar
  • 14.3k
10 votes
2 answers
354 views

Creating a new Publication throws: Unable to save new item The transaction has aborted

This is a brand new installation of Tridion 2013 SP1 on WS12 with SQL 2012. The interface loads with no issue. I can add user favorites and create publication targets and target types. However, when I ...
Trevor Bartlett's user avatar
9 votes
4 answers
440 views

Cannot delete publication error: The transaction log for database 'tridion_cm' is full

While trying to delete an old publication, I get the error: The transaction log for database 'tridion_cm' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc ...
Will Price's user avatar
  • 16.4k
8 votes
2 answers
159 views

How to create components from an external data source in Tridion 2011

How to create components based on an external data source (SQL Server or Excel) in Tridion 2011? In 5.3, I used to use Content Porter. Apparently the feature no longer exists in Content Porter 2009 ...
Merry Zhong's user avatar
8 votes
3 answers
693 views

Run how often sp_updatestats (SQL)

I wonder if there is some 'best practice' how many times a day the sp_updatestats (SQL db Content Manager) should run. Of course it 'depends' on certain things... but like what? Imports by the ...
Harmen's user avatar
  • 598
7 votes
2 answers
225 views

Can we have one DB for both Preview Site and XPM?

We have 2 CDA websites (publication targets), Preview and Live. While setting up the environment, the databases were created for both of these sites through Create Content Delivery DB scripts. Do we ...
Saurabh Mehndiratta's user avatar
7 votes
1 answer
256 views

Hybrid approach for CMS and CDS databases

In near future we are planning to move both CMS and CDS databases from Oracle to SQL server. As a first step we want to migrate Content Data Store (Broker DB) from Oracle to SQL Server. CMS database ...
k951's user avatar
  • 163
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, ...
James C's user avatar
  • 71
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 ...
robrtc's user avatar
  • 10.2k
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 ...
user36299's user avatar
  • 543
6 votes
3 answers
137 views

Tridion 2009 CM and CD Database Segregation in Different Machines: Reasons

It is recommended by SDL Tridion to have two separate database in two different machines for Tridion CM (Content Manager) and CD (Content Delivery). One reason could be, problem/issues of one ...
Anupam Baksi's user avatar
  • 1,690
6 votes
4 answers
326 views

Can we take backup of tridion user?

I have a requirement where i need to do DB restore from one CMS environment to other. CM DB 1 to CM DB 2 Broker DB 1 to Broker DB 2 CM DB 1 and CM DB 2 are having different tridion users though ...
Jitender sharma's user avatar
6 votes
2 answers
260 views

Database Permissions Required in SQL Server for Tridion Users

Do I need to give sys_admin privilege to any users in the database? It does not seems to be required, please suggest. Also, apart from the MTSUser (COM user), is there any other user for which I ...
Anupam Baksi's user avatar
  • 1,690
6 votes
1 answer
240 views

Timeout Expired for DecommissionPublicationTarget

While running the DecommissionPublicationTarget Core Service method on a well-used Publication Target I received the following error. The same code worked fine on a less-used Publication Target. I ...
robrtc's user avatar
  • 10.2k
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> ...
Marko Milic's user avatar
  • 8,930
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 ...
Brandon Mahoney's user avatar
5 votes
1 answer
158 views

How to take Tridion CM data base back up

I am planning to take content manager Tridion_CM database backup. I am using SDL Tridion 2011 SP1 and my database is MS SQL. Can some one point me the links to do it.
Patan's user avatar
  • 2,051
5 votes
1 answer
390 views

Configuring Content manager to use new database running in different machine

Currently we have both Tridion and Content Manager database running on same machine. We have a plan of creating a new database on another machine and linking the current Tridion CM to use new ...
Patan's user avatar
  • 2,051
5 votes
3 answers
689 views

Transaction timeout when publishing multiple pages

When I'm publishing a small amount of pages in my Tridion 2011 SP1 dev environment, I do not have any problem, but when I start publishing around 15 pages simultaneously, I receive the following error....
Niels V's user avatar
  • 191
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 ...
qchen01's user avatar
  • 1,060
5 votes
1 answer
425 views

Cannot insert the value NULL into column error

We keep getting the below error repeatedly in the production environment of our application. Error: No data found. [ETA_ITEMS, U] Cannot insert the value NULL into column 'ITEM_ID', table '...
Keirthana's user avatar
  • 861
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 ...
Neil's user avatar
  • 6,698
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.
kaiser1871's user avatar
5 votes
2 answers
184 views

Tridion 2011 SP1 Recommended Oracle Patch Set Update

Loving this move to StackExchange! I have a question that's probably better suited for Support. But I haven't received a response to my ticket yet, so I'll give it a go here. I'm getting a new ...
Mike Pryma's user avatar
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 ...
Josh Hebb's user avatar
  • 2,920
5 votes
1 answer
109 views

Database permissions for DB User in cd_storage_config.xml

In an SDL Tridion 2011 SP1 HR1 implementation, what are the minimum/recommended rights that the #DB_USER# must have. In the documentation (login required) I can see the name of a user who can ...
Dylan .. Mark Saunders's user avatar
5 votes
1 answer
180 views

Broker Database - Unable to retrieve htm files from DB

I have the following configuration to save files to the broker Database. <Item typeMapping="Page" cached="false" storageId="defaultDataFile"/> <Item typeMapping="Page" itemExtension="....
Ajo Mathew's user avatar
  • 1,063
4 votes
3 answers
299 views

Conversion of Tridion CMS from MS SQL Server to Oracle

Is it possible to convert the Tridion CMS database from MS SQL Server to Oracle, without afresh installation of Tridion? On an existing DB we have steps provided to upgrade but what will be the steps ...
Anusha's user avatar
  • 41
4 votes
2 answers
134 views

Getting a database error when publishing a DCP

I have been trying to publish a Dynamic Component Presentation but for some reason it keeps on failing with the following error: A database error occurred while executing Stored Procedure "...
Kunal's user avatar
  • 1,485
4 votes
1 answer
60 views

Clear-down UGC databases

After some initial tests to make sure everything was OK with a UGC installation I want to clear down all test comments/rating/stats before we hand it over. Is there a "supported" way to does this ...
Neil's user avatar
  • 6,698
4 votes
2 answers
219 views

Upgrading CMS database from 2009 to 2013 SP1

We are in the middle of upgrading our system from 2009 to 2013 SP1. We have already run the upgrade content data store script successfully. Now we want to upgrade content manager database, which is ...
P.Muralikrishna's user avatar
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 ...
Yash's user avatar
  • 916
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 ...
Atila Sos's user avatar
  • 6,290
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 ...
Marko Milic's user avatar
  • 8,930
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%...
Harald Greve's user avatar
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 ...
Sarang Deshmukh's user avatar
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 ...
Abdul Qadir's user avatar
  • 2,495
4 votes
3 answers
634 views

Random LockAcquisitionException errors when publishing large number of pages

In our development env, we have a single Tridion 2013 installation, with only 2 threads for rendering and 2 threads for deploying configured. Storage is a SQL Server 2008R2 database. Our Deployer runs ...
Para Jaco's user avatar
  • 685
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 ...
Chris Mills's user avatar
  • 2,221
3 votes
5 answers
490 views

Unpublishing pages through database

Could some some please help me with the steps/script to directly unpublish pages from the Tridion database, not from the CM explorer. We have a requirement to unpublish about 16000 different pages in ...
user901's user avatar
  • 41
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 ...
BryanD's user avatar
  • 1,075
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 ...
Saurabh Mehndiratta's user avatar
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 ...
mackie1908's user avatar
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: ...
k951's user avatar
  • 326