9 votes
Accepted

Supported modification on Tridion Broker database

Changing (or adding) an index may not seem like a big deal (and I would agree with this view) except that it will very likely break the database upgrade scripts whenever you decide to move to a future ...
Nuno Linhares's user avatar
  • 29.1k
7 votes

Supported modification on Tridion Broker database

The best way forward is to contact SDL Customer Support, propose the changes and see what their thoughts are. Indices are not changing the structure of the data, but you don't want future product ...
Jan H's user avatar
  • 8,836
6 votes

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

There is no 'out of the box' way to get this information, I'm afraid. If this is a big concern then you could consider: Locking-down access to the Publication Properties using security (removing ...
Jonathan Williams's user avatar
6 votes
Accepted

Multiple publishes failing with while executing Stored Procedure "EDA_ITEMS_GETPUBLISHITEMS"

We never included the work required to maintain SQL Server, because the scripts you need to run are standard SQL Server stuff rather the Oracle ones, which we provide. Basically, your team needs to ...
Nuno Linhares's user avatar
  • 29.1k
6 votes
Accepted

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

Organizational Items don't have version history, Publications and Structure Groups are Organizational Items, so there is no history for them. Understand probably it is too late, but next time you ...
Hao Peng's user avatar
  • 378
6 votes

A database error occurred while executing Stored Procedure "EDA_PUBLICATIONS_GETITEMSOFTYPE_83"

This looks like a typical timeout issue and there are a lot of similar question on this topic. The first thing to check is whether you have regular database maintenance performed? If not, do one (and ...
Atila Sos's user avatar
  • 6,290
5 votes

Clean the ghost published records

Actually, this situation is possible. We had a situation where there where "orphan" component presentations in broker database for already deleted components. We contacted SDL customer support and ...
Marko Milic's user avatar
  • 8,863
5 votes
Accepted

Upgrading to cloud database - MSDTC

According to the Improved Cloud support page on the online docs: Such types of implementations include, but are not limited to: Implementations that still use the Legacy Pack ...
Jonathan Williams's user avatar
5 votes

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

As Nuno has already commented that you can definitely use the same user for both MTS User and Default Administrator. Further, this is not mandatory to have your MTS User to have Admin rights. You may ...
Pankaj Gaur's user avatar
  • 15.9k
5 votes
Accepted

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

Your signalrBackplaneHub config is not valid. Use one described in documentation https://docs.sdl.com/LiveContent/content/en-US/SDL%20Tridion%20Sites-v1/GUID-8B1C96F2-464E-442F-9727-3F4E7B21AF23
Stefan Klasnic's user avatar
5 votes
Accepted

DB Reports for Deletions

I agree that all of these data are needed, and even I would like to have them, but please make note that they are not available in the database. This is because Tridion CM database is transactional ...
Marko Milic's user avatar
  • 8,863
4 votes

Content Delivery DCP DB Decoding Issue

We've sorted it out. The issue ended up being with the WSTL JDBC driver which we had installed in our local WebLogic. We compared it against the development box and noticed the discrepancy, so I ...
Josh Hebb's user avatar
  • 2,920
4 votes
Accepted

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

Database connection string of Topology Manager is part of encrypted section in web.config of "SDL Web Topology Manager" project. You have to decry-pt it, update and again encrypt on your server. ...
Raj Kumar's user avatar
  • 5,867
4 votes

Issue connection with Tridion_cm

Have you restarted the machine after Tridion installation? Looking at the error, Tridion CM is not able to establish the connection to database. Try to login to database using the username TCMDBUser....
Rajesh's user avatar
  • 1,231
4 votes
Accepted

Checking publish status of items in Tridion Content Manager database

I was able to get all published items from broker as: SELECT distinct COMPONENT_ID, PUBLICATION_ID FROM COMPONENT_PRESENTATIONS order by COMPONENT_ID, PUBLICATION_ID Also, i got all published items ...
Marko Milic's user avatar
  • 8,863
4 votes

I want to create new database for the Discovery Service

As mentioned in the documentation (http://docs.sdl.com/LiveContent/content/en-US/SDL%20Web-v1/GUID-654563D2-F38B-43C9-851C-0C1104FBA2AA), you can use PowerShell, and depending on your database ...
Bart Koopman's user avatar
  • 29.6k
4 votes

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

Tridion.ContentManager.Config contains this information. The database info is encrypted, follow the steps outlined here to read it. From the linked article: To decrypt the configuration file, ...
Nuno Linhares's user avatar
  • 29.1k
4 votes

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

With regards to part 3: There is some information stored in the Content Manager database. For example, most items (Components, Pages, etc.) store a version history of who updated them, at what time ...
Jonathan Williams's user avatar
4 votes

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

Does it requires DB Admin account? I think no, but it requires user which must be able to execute all SQL scripts. These scripts require rights like create/update/delete over both your newly created ...
Marko Milic's user avatar
  • 8,863
4 votes
Accepted

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

Are they compatible? Most probably yes. The bigger question is are they supported? and the answer is No. I've had the same idea, to run Tridion databases on newer versions of SQL server in ...
Marko Milic's user avatar
  • 8,863
3 votes

Web 8 New Topology Manager publishing to wrong Database

Details are a little bit vague but I would start in your Deployer's config. Go to your Deployers root directory and then inside the config and open the cd_storage_conf. Confirm the details of your ...
Richard Hamlyn's user avatar
3 votes
Accepted

CM database stricture change list after upgrade to Web 8

The CM database schema is officially not public and direct connections to the database are not supported by SDL. Therefore, it is not in SDL's interest to officially publish a list of changes to the ...
Rick Pannekoek's user avatar
3 votes

Issue connection with Tridion_cm

If TCMDBUser only sees two tables, there's your problem. The user needs to have rights for all of the tables (and Stored Procedures etc.) This is all set up by the database scripts, so either ...
Peter Kjaer's user avatar
  • 19.8k
3 votes
Accepted

Broker database lock during mass publishing

We face the similar challenge at our PROD environment and want to share a bit thoughts here. Each time when we publish mass files, if each file need time to rendering, then depends on the files ...
qchen01's user avatar
  • 1,060
3 votes

SDL Web8 database restore from Production to QA

As Nuno mentioned, one of the reasons for putting infrastructure related info in a separate DB (Topology Manager) was to facilitate synchronizing/porting the CM DB across DTAP environments. The idea ...
Rick Pannekoek's user avatar
3 votes

Clean the ghost published records

If you want to delete old publications from the Content Manager, you should consider first decommissioning the legacy publication targets. This effectively means telling the Content Manager to "forget"...
Dominic Cronin's user avatar
3 votes

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

The message states that you are violating a uniqueness constraint. This means that something has happened to cause your database to contain a record which conflicts with the one that is being saved. ...
Dominic Cronin's user avatar
3 votes

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

For both operations TOTAL==DONE, and both operations have skipOnError="true", so it might be that bulk operations were executed with errors. You can examine OPERATIONS XML to see that. In this case ...
AntonM's user avatar
  • 571
3 votes

Tridion CM Usage reporting

The Alchemy Webstore of Tridion plug-ins has a plug-in that does just this. It captures this event data into Google Analytics which provides the reporting visualization. Here is the link: http://...
Nickoli Roussakov's user avatar
3 votes

Tridion CM Usage reporting

As per support - there's nothing out of the box and I don't recall seeing any recent CM-Side extensions to store this data. I guess the 3 starting points you have are: you could analyse the IIS log ...
Dylan .. Mark Saunders's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible