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, ...
- 8,942
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 ...
- 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 ...
- 29.1k
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 ...
- 7,961
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 ...
- 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 ...
- 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:
...
- 4,074
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 ...
- 29.6k
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-...
- 14.5k
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 ...
- 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?
- 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 ...
- 29.1k
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 ...
- 8,942
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 ...
- 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, ...
- 1,485
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&...
- 3,789
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 ...
- 175
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. ...
- 14.5k
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 ...
- 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-...
- 2,154
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 ...
- 7,961
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 ...
- 14.5k
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-...
- 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 ...
- 8,215
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
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 ...
- 6,797
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 ...
- 2,518
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 ...
- 8,942
3
votes
Accepted
Tridion Total Content Size
From your comments, I am gathering that you are not looking for the number of items in the CM, but rather the disk space the Tridion items occupy. You can't get this using the Core Service API. This ...
- 2,518
2
votes
Dynamic component publish issue in tridion 2013
The issue is because "The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption."
It looks like your DB connection parameters need looking over. ...
- 18.4k
Only top scored, non community-wiki answers of a minimum length are eligible