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,863
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))
...
- 305
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
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
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
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
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
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
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
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
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
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,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 ...
- 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
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 ...
- 3,789
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 ...
- 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 ...
- 4,074
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
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 ...
- 15.9k
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).
- 1,899
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 ...
- 1,090
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
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 ...
- 7,950
Only top scored, non community-wiki answers of a minimum length are eligible