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, ...
Marko Milic's user avatar
  • 8,863
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

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

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

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

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,863
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

Broker Query takes time to execute for large data (Tridion 2013)

i think your are loading too much content from the broker. Can't you do just some optimization. As mentioned by @Tanner Object Cache with CCS is indeed very good option check if it helps Nothing ...
Raj Kumar's user avatar
  • 5,867
4 votes

Broker Query takes time to execute for large data (Tridion 2013)

@Shatadru, How you are invalidating your application level cached result to reflect published data? To improve the performance of you query execution you can check the below options: Broker ...
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
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

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

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

Component Metadata values becomes Null/Empty in Broker after re-publishing it dynamically

We found an answer, but it's very much a workaround. We determined that all of the field values are saved when you select a value from a single value metadata field that is linked to a category with ...
Paul Russell's user avatar
  • 1,090
3 votes

Broker Query takes time to execute for large data (Tridion 2013)

You may try following option: Keep the Maintenance Plan for SDL Tridion in effect and quite frequent - for extensive broker queries, I guess it was recommended to run the SDL Tridion Maintenance Plan ...
Pankaj Gaur's user avatar
  • 15.9k
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,075
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

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