We’re rewarding the question askers & reputations are being recalculated! Read more.

Hot answers tagged

16

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, then change it to have id of your page (change XML that contains inpublish instructions), and copy it into incoming folder of deployer. Deployer will pick it up ...


15

I wouldn't query it directly at all: You already said you don't have a clue about the structure, so image you would finally be able to write your queries, you'd probably have to change it when a new version comes out. I'd try out the following options: Use BrokerQueries. Robert Curlette has some articles on his blog (e.g. http://www.curlette.com/?p=383), ...


13

Yes - it does and it is mentioned in the documentation [Login required] Do something like (C#) //Get the second set of 10 results (eg 11-20) PagingFilter filter = new PagingFilter(11, 10); query.SetResultFilter(filter);


13

As far as I know since Tridion 2013 the encoding in database for content field has changed for mssql. You no longer will be able to do select on database to see the content anymore. I have seen around floating somewhere a query which can decode it for human readable view. Will try to look it up. However, even if the content cannot be seen properly in ...


13

As @Likhan is mentioning in his answer, it seems that the information is saved in Unicode/UTF16 so it needs to be decoded using other Encoding like iso-8859-1. I developed a workaround for it developing a SQL CLR Stored Procedure SQL CLR STORED PROCEDURE public partial class StoredProcedures { [SqlProcedure] public static void ...


13

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)) FROM COMPONENT_PRESENTATIONS WHERE <where_clause>


12

You can use “Cross Copier” feature of Power Tool to copy items across publications. For more see the URL http://sdltridionworld.com/community/extension_overview/powertools.aspx Below URL have some great thought by Bart which certainly be beneficial for you - How to move items from one publication to other


12

From your description, I suspect you may have cache enabled on your app servers, but not using (or not correctly configured) the Cache Channel Service. There's some info on the Tridion object Cache on Tridion World and also on SDL Live Content (login required) Update The configuration seems OK as far as I can remember the 2009 config... can you double ...


12

You need two DB Broker DB - It is configured in httpUpload and your Delivery website Session Preview DB - it will be used by Session preview service and this service is consumed by XPM. No separate db for XPM. This db will also configured in storage config of your website. HttpUpload and Odata.svc would be separate websites


12

The setup is correct, and the rendered output is correct as well. However, you will need to create some code to handle images stored in the DB by your webserver. Your webserver is not able to do this by default, and Tridion also doesn't have something like that out of the box. I'm not sure if you are using DD4T or not. DD4T does have a module that takes ...


12

When you use the broker API, you can add all sorts of criteria to filter One of the available criteria is the CustomMetaValueCriteria class, which allows filtering for a custom metadata string value. It takes a couple of parameters the key of the custom metadata field the value it should filter on an operator like greater than, equal, not equal,... I ...


11

It is not possible to publish Taxonomies to the file system so the storage type mapping you describe is not viable. If you have a broker database storage element in your storage conf file, map the Taxonomy type to this (eg storageId="defaultDB")


11

Despite popular belief, the Cache Channel Service itself does not handle caching, it only handles propagation of what items should be taken out of the cache. The cache itself is part of the Broker and it is enabled or disabled in the storage conf. The Cache Channel Service is there because the Deployer and Broker(s) can run in a separate memory space or JVM,...


11

You can use the ComponentMetaFactory class to interrogate the metadata of your component. Criteria c1 = new ItemTitleCriteria("MC%", Criteria.Like); //Create query Query myQuery = new Query(c1); String[] itemURIs = myQuery.ExecuteQuery(); ComponentPresentationAssembler cpAssembler = new ComponentPresentationAssembler(); ComponentMetaFactory cmFactory = ...


10

We have worked on a Platform (very much famous and has been featured in many of SDL Tridion Shows as a case study) where we had more than 80 websites sharing data from same broker. And this has been implemented in SDL Tridion 2009. The approach was as below: Any data that needs to be fetched from broker is fetched by using a WCF service based on a specific ...


10

Looking closely at your problem, it seems that the findTaxonomyKeyword method from the CachedTaxonomyHome class caches your result but when the whole taxonomy is reDeployed, the cache invalidation does not happen. To fix this you have two options: You contact Tridion Customer Support, explain the problem, explain why this would be a ShowStopper for your ...


10

You can try this to enable debug level log at Hibernate. <logger name="org.hibernate" level=”debug”> <appender-ref ref="rollingHibernateLog"/> </logger> rollingHibernateLog –must be also defined in logback.xml


9

There are - as usual with Tridion - about as many solutions as you may think of. My preferred solutions: If you're using a model that can get all data from the Database (CWA, DD4T, WebService), then, by all means, please use this. Single database for delivery, caching properly set up on delivery servers and you're good to go. In a CWA customer environment ...


9

+1 for a question that comes up frequently, though everyone say not to query SDL Tridion databases. It's easy to query "content" from the storage broker (hints below). Some clarifications: Content Manager vs. Content Delivery The Content Management System (CMS) and its database stores component and pages as well as their history. In CMS, can "inspect ...


9

Tridion uses the Hibernate framework for it's database persistence, so Hibernate's logging is what needs to be set up. In logback.xml define the following: 1) Define an appender to put the DB log statements into a separate file. Simply paste this into your logback.xml: <appender name="rollingHibernateLog" class="ch.qos.logback.core.rolling....


9

As hinted at by Nick, the Criteria.AddCriteria method doesn't return a Criteria object, so you can't assign it as you're trying to. What you probably want is something like this: searchCriteria.AddCriteria(finalCriteria); myCriteria = searchCriteria; Note that if you do this, searchCriteria and myCriteria will be the same object instance, so changes to one ...


9

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 separate server or service. The effect of this is, that processes surrounding requests are spread across different JVMs, which in total bring a more scalable ...


9

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 version. I have had this exact scenario recently where we had to remove the extra indices that were added before being able to successfully run the upgrade. ...


8

One nifty trick you can do is temporarily make your destination publication a child of the source by updating the Blueprint inheritance, such that all items in the source pub become inherited. Then select the items inside your new temporary child pub, right-click, copy/paste. The items copied will be local to your child pub. After this, go back to your ...


8

In 5.3 you were using .NET with Interop to COM with Interop to Java (and along with this you had a lot of other limitations like the COM calls being single-threaded and god knows what else). As from Tridion 2009 we removed the COM dependency, so your .NET API calls use in-process interops to Java, with a significant performance improvement - but the side-...


8

(Copied from StackOverflow, by Bart's request) How Tridion Content Delivery's Object Caching works Any Tridion Content Delivery module that accesses the storage (through the Broker or Storage layer) has a built-in ability to cache the items it retrieves. That caching is enabled by the setting you show above ObjectCache enabled="true". So by simple setting ...


8

I will assume that what you mean with the Broker is the Tridion Broker database. It is possible to publish everything to the file system, it includes, content, linking info, metadata and references, however this functionality is deprecated and will be removed in future releases, having said that, in future releases, linking, metadata and references will ...


8

It looks like cd_dynamic.jar is missing in the lib folder. Update: Needs to remember that cd_dynamic.jar and cd_dynamic_conf.xml are dependent on each other. Hence, cd_dynamic.jar should be placed in lib folder cd_dynamic_conf.xml should be placed in config folder


8

There is no dependency between your CM and CD database other than the version of SDL Tridion, so provided you are using a supported database and client version, you are good to go. The only differences between using Oracle and MS SQL server I have seen in the past was ordering of characters. I remember once that on a production server we were using Oracle ...


7

In R5.3, you cannot set bindings differently per publication in the same configuration file. As Pankaj pointed out you can set both file system and database bindings for the same publication BUT from the same configuration you cannot vary the bindings for different sites. If you want to do this, you'll need different CD instances with their own ...


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