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, ...
Marko Milic's user avatar
  • 8,930
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 ...
Raimond's 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 ...
Nuno Linhares's user avatar
  • 29.1k
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 ...
Raimond's user avatar
  • 7,253
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 ...
David Forster's user avatar
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

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: ...
Mukesh Kumar's user avatar
  • 4,074
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 ...
Nuno Linhares's user avatar
  • 29.1k
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?
Nuno Linhares's user avatar
  • 29.1k
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 ...
Nuno Linhares's user avatar
  • 29.1k
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-...
Jonathan Williams's user avatar
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 ...
Bart Koopman's 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 ...
Marko Milic's user avatar
  • 8,930
5 votes
Accepted

DXA 2.0 API to Retrieve DCPs as Entity Models in a REST API

ContentProvider getEntityModel developed to work with MVC data. So it require registering view model. You can use dummy view to register your model. In case you need full data which is returned by ...
Mukesh Kumar's user avatar
  • 4,074
4 votes

unable to get dynamic content in web 8

The exception seems to be self explanatory. You are passing an invalid tcm uri. A tcm uri is of the following format: tcm:publicationId-itemId-itemType Examples: Publication, tcm:0-1-1 Component, ...
Kunal's user avatar
  • 1,485
4 votes
Accepted

How to get the list of TCM ID of a page from all the publications at content delivery?

It's not clear what you want to achieve with the queries, but taking into account the information that you provide, if you want to obtain the list of pages with same id (in this example is 46, change ...
Raúl Escudero's user avatar
4 votes

Why OData is missing some components with Filter criteria whereas it works fine if also provide the component Id in Query?

Maybe the problem is the number of results of the query. By default the number of results are limited to 25, as it is configured in the cd_webservice_conf.xml <OData> <DefaultTop>25&...
Raúl Escudero's user avatar
4 votes

Content Broker database - Using non relational database with DXA

Basically, you break the 'chain' from CMS->BROKER DB->ContentDelivery(DXA) when replacing the middle storage layer with a custom storage solution. NoSql may perform better on its own, but the total ...
Guus Beltman's user avatar
4 votes

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

This is a great question. We’ve had initial performance concerns (problems!) with the Content Service on a couple of projects that I’ve worked on. These have manifested in high CPU usage mainly. ...
Jonathan Williams's user avatar
4 votes
Accepted

From static pages (with DWT) to broker database

The short answer is yes, with a large but. Your application needs to deal with: Fetching the page content from the database Storing it in the file system if your app server requires files to be ...
Nuno Linhares's user avatar
  • 29.1k
4 votes
Accepted

Web service that queries Broker Database outside of SDL Web 8.5?

You need to connect to Content svc via CIL. Here are a couple links: https://shahideqamuddin.blogspot.com/2017/11/getting-started-with-tridion-cil.html https://community.sdl.com/product-groups/sdl-...
Andrew William Ross's user avatar
3 votes

Broker Query for Metadata Date Fields

Your question doesn't specify version or whether you're using .Net or Java but the API is similar. I quickly wrote this example to show you how I'd use the 2013 SP1 .Net Content Delivery API for a ...
David Forster's user avatar
3 votes

Content Broker database - Using non relational database with DXA

DXA is just an implementation of Tridion and therefore is bound to the prerequisites of it, see https://docs.sdl.com/LiveContent/content/en-US/SDL%20DXA-v7.1.1/GUID-DD402008-D5C5-4DCA-A74F-...
Bart Koopman's user avatar
  • 29.6k
3 votes
Accepted

Web 8.5 - How to implement and configure custom TCDL on Web site with RESTful Broker API?

Implementation requires the following steps: To start to create your own custom TCDL tags jar using Maven + IntelliJ IDEA Java development tools to create a Java class that implements the interface ...
Velmurugan's user avatar
  • 8,125
3 votes
Accepted

Why does the Component Presentation Assembler not execute JSP code?

The ComponentPresentationAssembler needs access to your page context to work, so the constructor overload that accepts just the publication id won't work. You need to instantiate a JSPPage with the ...
3 votes

Resolving TCDL tags from dynamic component presentations

A hotfix is now available from Support for this setup, CM_2013.1.1.1832.zip for rendering in the context of a dynamic component presentation (without a page).
Elena Serghie's user avatar
3 votes
Accepted

Is there recommended Tomcat version for In Process Broker API?

Tomcat version: Looking at the Content Delivery presentation environment Web application server support history page in the online docs, it appears that only Apache Tomcat 7.0 is supported for SDL Web ...
Jonathan Williams's user avatar
3 votes

Web8.5- Can content-tags.tld be used instead of cd_tags.tld?

For the REST api you have to use the taglib content-tags.tld. You need to include the files in Content Delivery\roles\api\rest\java\lib in your web application's WEB-INF/lib folder. The classes that ...
Quirijn's user avatar
  • 6,787
3 votes

DXA 2.0 API to Retrieve DCPs as Entity Models in a REST API

I got this to work following Mukesh's suggestion. I updated the Component Template with a dummy Entity View Name 'Promo' as shown below. In the SpringInitializer in the custom DXA module having the ...
Sabarish Senthilnathan's user avatar
3 votes

Tridion Total Content Size

Well, there is easy way and a hard way. Easy way is to check Tridion CM database, check number of items in ITEMS database (exclude versions and just check latest versions). Also exclude if you want ...
Marko Milic's user avatar
  • 8,930

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