Questions tagged [broker]

For questions related to the Content Broker, Storage Layer or Content Data Store.

Filter by
Sorted by
Tagged with
13
votes
4answers
1k views

SQLs directly to the Broker

I need to do a SQL directly to the broker to get some data from a component and I don't really know how. I mean, I don't know the table structure to be able to from a tcm get all the component data ...
13
votes
3answers
517 views

How to enable Content Delivery API/Broker DB logging to show raw SQL

We'd like to delve a bit deeper into the Content Delivery API to see some of the raw SQL queries that are being built and executed when using the API. We've got the standard Content Delivery logging ...
13
votes
1answer
501 views

Broker Query with sort criteria over optional field

I'm obtaining a list of 5 components from the broker using a simple Query: Query myQuery = new Query(); Criteria myCriteria = null; PublicationCriteria pubRelCriteria = new PublicationCriteria(...
12
votes
3answers
1k views

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

I'm publishing Component Presentations to the Content Delivery DB and it shows up as a different encoding only in the content field of the COMPONENT_PRESENTATIONS table. The content field in the ...
11
votes
4answers
490 views

Implementing Multiple deployers/Broker databases vs. replication

I am currently working in a Tridion 2009 SP1 environment where are trying to set-up a fail-over situation by using two deployers which are deploying content to two different file servers and two ...
10
votes
3answers
346 views

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

I'll upgrade Tridion 2013 SP1 to SDL Web 8.5. Then Broker API will be changed to RESTfull API (Java) from in-process API. I'm concerned about Content Service's performance on SDL Web 8.5. On Tridion ...
10
votes
3answers
332 views

Multiple Publications - One broker database

I've always gone with the rule of 1 Broker per website, the main reasons being for most efficient CCS, cleaner deploying set up, separation of concerns if one 'goes down' etc We have a new ...
10
votes
2answers
76 views

Supported modification on Tridion Broker database

We have suggestions from our DB team to add some indexes on broker database. I know that in general database modifications should be off limits (not supported), but it looks to me that adding indexes ...
10
votes
2answers
300 views

Dynamic links taking time to be reflected : Tridion 2009

We are facing an issue with dynamic component linking in our prod server, as the component is showing but the corresponding link is taking time to be active. It is showing as 'dead link' though data ...
9
votes
2answers
234 views

Is there anyway to let Query Support pagination?

We want to search a list of published News component based on Content Delivery API. The components number is huge. So we want to use pagination. Do you know whether the Content Delivery's search API ...
9
votes
2answers
510 views

Can a broker query have a “contains” condition?

I would like to get all DCP's in which components have metadata City that contains word "New". This should return "New York", "New Mexico", "New Hampshire" ... With OData, this is easy: odata.svc/...
9
votes
1answer
220 views

Obtaining component title from the Tridion broker

This code works to get content from the broker for all components whos name begins with "MC": Criteria c1 = new ItemTitleCriteria("MC%", Criteria.Like); //Create query Query myQuery = ...
8
votes
2answers
418 views

Website displays outdated content when using Object Cache

We have an application that uses DD4T and it saves few files to Broker DB. We have observed under settings cd_storage.xml Object Cache is enabled(code below). <ObjectCache Enabled="true"> &...
8
votes
2answers
462 views

Taxonomy Broker cache issue in Tridion 2009

This is a Tridion 2009-SP1 Java environment with an Oracle Broker. Both the deployer and the website are running on the same server. We have the CD_2009.1.71453 roll up hotfix installed as well We ...
8
votes
1answer
319 views

Storage config setting for XML files to DB quesiton

We're using SDL Tridion 2011 SP1 HR1, DD4T 1.25.0.0 (.Net website with IIS) We wanted to load a (navigation) XML file from the filestore if it existed (as a debug override) and get it from the ...
8
votes
1answer
154 views

Broker query criteria to search all multimedia components in a folder

I was wondering if broker query has any criteria which can work for Location/Folder path to search components inside a folder. I am intended to search all the binary components based inside a folder(...
7
votes
4answers
162 views

Removing the broker

We would like to get rid of the Tridion Broker as part of a project and publish content directly to a repository as part of a Storage Extension. My question is, is there any deep dependency that ...
7
votes
2answers
280 views

Copying components across publication in Tridion 2009 SP1

I am using SDL Tridion 2009. We use VBScript and JSP. I have a requirement to copy components across publications. How is this possible? Please suggest some ideas.
7
votes
2answers
215 views

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

We have 2 CDA websites (publication targets), Preview and Live. While setting up the environment, the databases were created for both of these sites through Create Content Delivery DB scripts. Do we ...
7
votes
1answer
174 views

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

I unpublished a Page from CME and after successful unpublish from publishing queue, deleted the page. But when I checked the DB, I still see the entry of the page. Now there is no way for me to try ...
7
votes
2answers
105 views

In Tridion 5.3 if we use unique Content Delivery instances can we configure different binding targets on a per publication basis?

We are using Tridion 5.3 and are wondering if we use unique Content Delivery instances can we specify different binding targets for the broker depending on the target publication. We want to use the ...
7
votes
3answers
326 views

Tridion Object Caching for Clustered Enviornment

I'm having two Sql server 2012 DB servers in clustered environment. I have enabled Tridion Object caching. I have 2 scenarios where need help in understanding: When Both servers are in Active/Active ...
7
votes
3answers
203 views

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

I have a use case where I need to get a list of all the component links for a given component on the CD side. The reason for this is that I need to track all the pages that the component is on. My ...
7
votes
1answer
1k views

Error -Type mismatch: cannot convert from void to Criteria

I have below two Criteria - Criteria searchCriteria = CriteriaFactory.And(ItemSchemaCriteria, PublicationCriteria); finalCriteria = CriteriaFactory.And(andCriteria); here andCriteria is an array of ...
7
votes
1answer
247 views

Hybrid approach for CMS and CDS databases

In near future we are planning to move both CMS and CDS databases from Oracle to SQL server. As a first step we want to migrate Content Data Store (Broker DB) from Oracle to SQL Server. CMS database ...
7
votes
2answers
180 views

Relevance in broker queries

Is there any way to obtain the results of a Broker Query with something similar to a relevance value? I'm doing a query of components with 3 categories, and the query may be a combination of 3 ...
7
votes
3answers
209 views

Not able to get list of schema names when I pass publication ID and with ItemTypeCriteria schema by using Broker API

int iPubId = Integer.parseInt(publicationId); CriteriaFactory criteriaFactory = new CriteriaFactory(); PublicationCriteria pubCriteria = new PublicationCriteria(iPubId); ItemTypeCriteria IsSchema = ...
7
votes
1answer
5k views

An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) (System.BadImageFormatException)

I'm trying to deploy our .NET web application using Tridion Delivery API to a local dev server. The machine is x64 and has a proper cd_licenses.xml file and the cd_*_config.xmls are all pointing to ...
7
votes
1answer
351 views

performance- odata vs content delivery api

Is there any difference in the underlying approach of retrieving content from broker by using odata service vs using content delivery api? Does Odata service internally use content delivery api to ...
7
votes
1answer
162 views

Multiple NotInCriteria producing incorrect results

Might be doing something stupid but basically I am not getting the results I would expect when using multiple NotInCriteria in a query. I only ever seem to have the one of the criteria excluded. The ...
7
votes
1answer
122 views

Tridion 2011 SP1 HR1 - PageContentAssembler

Observing some strange behaviour in our code thats is pulling back published page content from broker. This is DD4T (except we use WCFs a DD4T providers to get stuff out of broker) - when we query ...
7
votes
1answer
310 views

SchemaTitleCriteria yield no results in SDL Tridion Broker Query

I have a simple SDL Tridion 2011 SP1 Broker Query to retrieve a list of Component URIs. All of my Components are embedded on Pages, and not using Dynamic Component Templates. The following code ...
6
votes
2answers
421 views

Publishing Taxonomy to broker database

Further to my recent post Tridion Core Service endpoint with regard to querying the Core Service Client to retrieve a list of keywords for a given category Id, I've realized it might not be the best ...
6
votes
1answer
252 views

Storing images in broker DB

Current setup: I have a image stored in multimedia component. Multimedia component is linked from component A. Component A is published with dynamic CT (Language REL) to broker DB. Storage ...
6
votes
1answer
139 views

Installing CM and Broker databases on separate servers

Currently, we have CM and Broker database on the same database server. Now, we want to separate these two to balance the load on the database server itself. I found we need to change the broker.conf ...
6
votes
2answers
145 views

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

We have a component having below fields in the metadata: ID (Single Line Text Field) Expire Date (Date Field) Message (Single Line Text Field) With this when we publish this component, the values ...
6
votes
2answers
288 views

Tridion 2011 SP1 broker database resource max out and tokens timesout on mass publishing

Please be kind as this is my first question on stack exchange. When we are mass publishing to our broker databases, especially on mass publishing, the server resource max's out and then starts ...
6
votes
1answer
95 views

Why does the Component Presentation Assembler not execute JSP code?

We're busy upgrading to Web 8.5, and I'm having some problems with JSP Dynamic Component Presentations. These are correctly deployed to disk, and the ComponentPresentationFactory is able to locate my ...
6
votes
1answer
171 views

Invalid TCM ID returned when getting a keyword from a keyword's meta using Broker

I have a keyword taxonomy that I'm retrieving from the Broker DB, and the keywords have a metadata schema that includes a link to another keyword. When I use (pseudocode): taxonomy = taxonomyFactory....
6
votes
1answer
121 views

How do I Fetch a Component Presentation From the Content Service Using Odata Based on Keyword

We are running web 8.5 with the latest content delivery setup. We have a component X which has two fields (both are regular content fields and not metadata): Key, and Value The key is a keyword from ...
6
votes
2answers
95 views

How to setup auto failover for broker database clusters

Our production environment has two redundant data centers. Within each data center we have multiple web servers talking to a single SQL cluster which has multiple broker DB servers. The clustering ...
6
votes
1answer
180 views

Publishing page on CME is different from that on XPM about default publishing rules for pages. Is it design?

I'm trying to confirm a page publishing behavior on XPM and CME. Setup: Dummy Schema (which have no schema fields.) News Schema News Summary Component Template (CT) with both set: Published as a ...
6
votes
1answer
127 views

Retrieving binary titles from the Broker DB

I am currently writing an indexer to put SDL Tridion Content into a search engine. The content includes Component Presentations, Pages and Binary Variants. I need to retrieve a Title for each of these....
6
votes
0answers
222 views

query the Broker database on SDL Web 8.5

I'm querying the Broker DB on SDL Web 8.5: CustomMetaValueCriteria index = new CustomMetaValueCriteria( new CustomMetaKeyCriteria("index"), ...
5
votes
3answers
242 views

Missing com.tridion.dynamiccontent.PageContentAssembler

I have some WCF services that have been implemented against the Tridion 2013 SP1 Content Delivery / DD4T Provider. When executing a query, I receive the following error: <JavaException> <...
5
votes
2answers
239 views

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

I have a DXA 2.0 webapp with Web 8.5 working without issues. I am trying to build a REST API in DXA to spit out JSON content of a DCP. I'm able to use the Broker API (ComponentPresentationFactory) to ...
5
votes
2answers
562 views

Broker caching issues with custom DD4T extension

I'm working on a DD4T content delivery application utilizing grails. The app is fully functioning with the exception of caching. The app is using all of the out-of-the-box dd4t libraries unaltered and ...
5
votes
1answer
159 views

Broker Database failover using default JDBC

For months we have been facing issues with our load balancing technique for the Broker DB having a primary and secondary database server. Recently we got to know from SDL that we can use the old ...
5
votes
1answer
111 views

Performance gains from storing LinkInfo in DB v/s File System

We are running SDL Tridion 2011 SP1 for publishing a Java (JSP) based website (IIS 7.5 & Tomcat 7). The website does not use Dynamic Content Broker and rather uses local file system for storing ...
5
votes
1answer
89 views

JSP Statements Not Interpreted in a DCP

I've a DCP that renders a JSP statement <% out.println("Hello"); %>. I'm trying to execute the JSP statement by using the CD API on a static JSP page. I've tried all possible scenarios - making ...