Hot answers tagged

16 votes

Page unpublished and deleted from CME, but page entry still exists in DB. How to clean the entry in DB?

Actually there is a better and far safer solution than the one @Nuno proposes. What you can do is "mock unpublish process". You can capture undeploy transport package on CD side of some other page, ...
user avatar
  • 8,446
13 votes

Component Presentations in SQL 2012 DB shows up as a different encoding with 2013

You can get readable content from the COMPONENT_PRESENTATION table directly in sql by double converting the content field like this: SELECT CONVERT(varchar(max),CONVERT(varbinary(max),content)) ...
user avatar
12 votes
Accepted

Storing images in broker DB

The setup is correct, and the rendered output is correct as well. However, you will need to create some code to handle images stored in the DB by your webserver. Your webserver is not able to do this ...
user avatar
12 votes
Accepted

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

You need two DB Broker DB - It is configured in httpUpload and your Delivery website Session Preview DB - it will be used by Session preview service and this service is consumed by XPM. No separate ...
user avatar
  • 5,857
12 votes
Accepted

Can a broker query have a "contains" condition?

When you use the broker API, you can add all sorts of criteria to filter One of the available criteria is the CustomMetaValueCriteria class, which allows filtering for a custom metadata string value. ...
user avatar
9 votes

Is Content Service's performance no problem compared with in-process API?

Doesn't Content Service become bottleneck on SDL Web 8.5? Yes and no. You're indeed in fact moving the processes, libraries and dependencies which fetch data from the Broker DB from the web app to a ...
user avatar
  • 7,253
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 ...
user avatar
  • 28.9k
8 votes
Accepted

Hybrid approach for CMS and CDS databases

There is no dependency between your CM and CD database other than the version of SDL Tridion, so provided you are using a supported database and client version, you are good to go. The only ...
user avatar
  • 29.6k
7 votes
Accepted

What version of Tridion was broker page storage introduced?

I don't like quoting myself, but... who are we kidding: I love quoting myself. From over on StackOverflow: Tridion 5.3 was the first version where you got the option to store pages and binaries ...
user avatar
7 votes
Accepted

Broker query based on component field

Regular component fields cannot be queried in the content delivery system, as only system metadata, component metadata fields and taxonomy fields are stored there with the templates output. If you're ...
user avatar
7 votes

What are the TCDBroker, TCDLink, and TCDWAI in Tridion 2013 SP1? I am getting event log errors on startup

TCDBroker, TCDLink and TCDWAI are Windows services which serve Tridion Content Delivery capability to your web applications. Your issue is probably got to do with that no valid JDK runtime is ...
user avatar
  • 7,253
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 ...
user avatar
  • 8,826
6 votes

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

Session Preview is a feature of Experience Manager that allows editors to make, and then view, updates to content across multiple pages without having to continually check-in and republish the content....
user avatar
6 votes

Intermittent ClassNotFoundException

Following Nuno's advice on this question, you may want to check that your website application pool is set to not recycle. It may also be worth checking the version of Java that you are using. Only ...
user avatar
6 votes

Unable to get specific field value from component

When you publish a ComponentPresentation, Tridion renders the data from the component using the component template. The structure of the component as stored in the content manager is not available to ...
user avatar
  • 18.5k
6 votes

Using multiple custom meta data keyword Criteria in a single query as LIKE operators

@Kris, I am assuming you have custom meta value as a comma separated string. You can use SQL like pattern %% to match the value. So your custom meta value criteria should be like: ...
user avatar
  • 4,054
5 votes

Broker DB, Get component content

Only System Metadata is published for Components, while content is actually published in it's rendered form as a Component Presentation. If the component in question is published as a Dynamic ...
user avatar
5 votes

What version of Tridion was broker page storage introduced?

The ability to store pages in the Broker database was introduced in Tridion 2009. CWA was already something developed way before that, as it was already working on Tridion 5.2 Update See Frank's ...
user avatar
  • 7,253
5 votes

How to get a list of all the Component Links for a given Component Presentation with Content Delivery

It does look like the getLinkInfo method might work, so all we need to do is overcome the protected access modifier. One approach is to create a custom class in the com.tridion.linking package and ...
user avatar
5 votes
Accepted

Multiple NotInCriteria producing incorrect results

Thought I would post this as it may help someone else if you run into this problem. Have received the following response from SDL support who solved the issue. I have investigated further and ...
user avatar
  • 677
5 votes

Can a broker query have a "contains" condition?

Harald answers your question. I just want to throw another option in: you could use a NuGet package for this: (Warning: it's beta and it's written by me) Install it: Install-Package Tridion.Broker....
user avatar
5 votes
Accepted

How to retrieve KEY_STRING_VALUE from KEY_NAME or ITEM_ID based on custom meta data ?

The custom metadata is present in the broker only to allow filtering and not as pure "model" data; as such the APIs do not provide you with a method to directly lookup this data via a normal API call ...
user avatar
5 votes

Unable to get specific field value from component

In broker final content (xml or html as per your architecture) is published. individual field values (as key values) are not published, so You can not directly fetch any component value. you have to ...
user avatar
  • 5,857
5 votes

performance- odata vs content delivery api

--Update based on Nuno's comment below -- OData does not internally use the CD API. It has a different implementation, but like the CD API, is also based on the JPA standard. --end update-- OData ...
user avatar
5 votes
Accepted

JSP Statements Not Interpreted in a DCP

If you're publishing to the filesystem, then you'll need to set the Component Template to output JSP, use the ComponentPresentationAssembler class and ensure that the DCPs are being published to a sub-...
user avatar
5 votes

What is the best approach for Mapping Broker and Web-Applications

To be honest, I much rather prefer option 2 for: Management simplicity Flexibility in growth Given how CD environments can grow (yes, including database here) nowadays, you'd really be needing to ...
user avatar
  • 28.9k
5 votes

Can we use same OData Webservice instance to serve content from different Brokers

In short: no. You can only bind one database to each service. May I ask why you're using 3 different brokers?
user avatar
  • 28.9k
5 votes
Accepted

Content Broker database - Using non relational database with DXA

SDL doesn't currently support any non-relational database for the broker, so the answer is "it depends". If you want to you can use a different storage layer altogether by extending the deployer to ...
user avatar
  • 28.9k
5 votes

Is Content Service's performance no problem compared with in-process API?

This isn't just your concern, this topic was discussed a lot when the change in architecture was suggested. Now while all (architecture) changes will have their pros and cons, once the decision was ...
user avatar
  • 29.6k
5 votes
Accepted

How can I have two different PAGE_ID values for the same URL in LINK_INFO

Actually, broker database can contain few pages with same URL. Please check my answer to similar question here. Same URL is not result of corrupt broker, but issues with CM-CD where unique name/url ...
user avatar
  • 8,446

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