Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2018-01-05 05:39:20 GMT <Alfresco> Hi

2018-01-05 05:39:41 GMT <Alfresco> I want to check that alfresco and citrix integration

2018-01-05 05:39:44 GMT <Alfresco> Check whether Alfresco complies to the following requirement. Solution must be Citrix certified and / or Citrix ready and officially support the following technical specifications: 1 - Citrix XenApp 7.6 or above on Windows Server 2008 R2 2 - Citrix XenDesktop 7.6 or above with Windows 7 Enterprise 3 - HP T520 Thin Client with Windows 7 Embedded Standard

2018-01-05 05:46:22 GMT <qwebirc41075> JOIN

2018-01-05 05:46:27 GMT <qwebirc41075> hi

2018-01-05 05:47:03 GMT <qwebirc41075> need help to verify that alfresco support integration of citrix

2018-01-05 06:03:42 GMT <qwebirc41075> hi

2018-01-05 06:03:55 GMT <qwebirc41075> hi

2018-01-05 07:28:31 GMT <Joyson> Hi

2018-01-05 07:28:40 GMT <Joyson> has anyone ever worked with this add on ? https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting

2018-01-05 07:28:41 GMT <alfbot> Title: GitHub - Alfresco-Business-Reporting/alfresco-business-reporting: Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. The second feature is to generate reports against these reporting database and store the reports back into Alfresco. Reports can be designed using Pentaho Reporting. But feel free to use any BusinessObjects, Cognos, Clickview. (at github.com)

2018-01-05 08:57:16 GMT <hi-ko> good morning happy new year!

2018-01-05 09:10:01 GMT <Joyson> Has anyone faced issues with deploying custom mime type with latest version of alfresco community ?

2018-01-05 09:10:20 GMT <Joyson> 201707

2018-01-05 09:11:51 GMT <Joyson> The same mimetypes works fine with 201605

2018-01-05 09:30:56 GMT <AFaust> Joyson: Not 201707 specifically, but with an earlier 2017 GA release I did not find any issues. Of course it may depend on "how" you deployed a custom mimetype. If you could provide your configuration files for this it would give people here an opportunity to try with your files on their environments..

2018-01-05 09:45:14 GMT <Joyson> Thanks for the reply AFaust

2018-01-05 09:45:19 GMT <Joyson> I have created mimetypes-extension-map.xml under tomcat/shared/classes/alfresco/extension/mimetype/

2018-01-05 09:45:27 GMT <Joyson> and the file contents are here --> https://pastebin.com/k1sDVLPb

2018-01-05 09:45:28 GMT <alfbot> Title: <alfresco-config area="mimetype-map"> <config evaluator="string-compare - Pastebin.com (at pastebin.com)

2018-01-05 09:46:01 GMT <Joyson> I have followed this documentation https://docs.alfresco.com/5.1/concepts/dev-extensions-share-custom-mimetype.html

2018-01-05 09:46:03 GMT <alfbot> Title: Adding Custom MIME types | Alfresco Documentation (at docs.alfresco.com)

2018-01-05 09:52:35 GMT <AFaust> Ok, that file / way will still work. I am using it at a customer with Alfresco Enterprise 5.2.1

2018-01-05 09:54:11 GMT <AFaust> Wait a second. The file for the customer is in a different place actually..

2018-01-05 09:54:41 GMT <AFaust> Looking at the inclusion pattern, the documented file path is not used (anymore?)

2018-01-05 09:54:44 GMT <AFaust> Valid paths are:

2018-01-05 09:55:02 GMT <AFaust> alfresco/mimetype/mimetype-map.xml (out-of-the-box)

2018-01-05 09:55:11 GMT <AFaust> alfresco/mimetype/mimetype-map-openoffice.xml (out-of-the-box)

2018-01-05 09:55:19 GMT <AFaust> alfresco/module/*/mimetype-map*.xml (addons)

2018-01-05 09:55:29 GMT <AFaust> alfresco/extension/mimetype/*-map.xml

2018-01-05 09:55:59 GMT <Joyson> It seems like the problem was with https://github.com/Alfresco-Business-Reporting/alfresco-business-reporting addon and after removing this addon I can see the custom mimetypes and preview are working fine

2018-01-05 09:56:00 GMT <alfbot> Title: GitHub - Alfresco-Business-Reporting/alfresco-business-reporting: Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. The second feature is to generate reports against these reporting database and store the reports back into Alfresco. Reports can be designed using Pentaho Reporting. But feel free to use any BusinessObjects, Cognos, Clickview. (at github.com)

2018-01-05 09:56:08 GMT <AFaust> I have to correct myself - that last pattern should match the documented file path just fine (it just did not turn up in my search, which is why I exclaimed at first it is not supported)

2018-01-05 09:56:40 GMT <AFaust> Yeah - if any addon is behaving badly and providing a file in that extension path, the customer / end-user can no longer customise it

2018-01-05 09:57:13 GMT <Joyson> Thank you for sharing your knowledge

2018-01-05 09:57:14 GMT <AFaust> This is why I always argue that addons should NEVER EVER ship files in the extension path unless end-user / customer still has ways to override them.

2018-01-05 09:57:55 GMT <AFaust> Too bad that Alfresco has been giving out the extension path as the "wholy truth for customisation" for too long...

2018-01-05 10:00:38 GMT <AFaust> Ahh - that addon is a very old addon and migrated from Google Code. Too bad it is not maintained actively, so such issues won't get addressed...

2018-01-05 10:04:52 GMT <Joyson> too bad, need to look for something else then

2018-01-05 11:29:21 GMT <douglascrp> morning

2018-01-05 11:48:14 GMT <Hiten> Hi Guys, I am trying to override OOTB email templates. So far I have come to know that there are two ways to bootstrap the content one is thorugh bootstrap one is through ACP model I believe that the first approach is for new content and it runs only ones, second approach seems the one that I can use as I can see the UUID-Binding attribute(REPLACE_EXISTING or UPDATE_EXISTING) which can help me in either removing or updating the OOTB

2018-01-05 11:49:05 GMT <Hiten> asking for <sys:node-uuid>b7c6b88a-e5fd-4ccf-b134-69a2460c3b89</sys:node-uuid> e.g. in acp file and how will I get to know the uuid beforehand for OOTB email_templates I am bit confused myself right now and not sure if my understanding is correct Please help me

2018-01-05 11:56:17 GMT <AFaust> Hiten: You should never rely on specific UUIDs for content bootstrap / updating. Bootstrap / ACP in my opinion is only useful for first-time setup of a content structure. For updates, I prefer to use a custom module component that looks up nodes by XPath / metadata-query, updates them if found or creates them if non-existing

2018-01-05 11:57:54 GMT <AFaust> Such a module component can be standardised to a degree, using a set of properties to define "expected XPath" and/or "metadata query", as well as URL to the new file.

2018-01-05 12:04:11 GMT <Hiten> Thanks AFaust. I am not clear about custom module component

2018-01-05 12:04:16 GMT <Hiten> Any resources that might help

2018-01-05 12:04:19 GMT <Hiten> ??

2018-01-05 12:04:42 GMT <AFaust> http://dev.alfresco.com/resource/AlfrescoOne/5.2/PublicAPI/org/alfresco/repo/module/AbstractModuleComponent.html

2018-01-05 12:04:43 GMT <alfbot> Title: AbstractModuleComponent (Alfresco 5.2.2 Public Java API) (at dev.alfresco.com)

2018-01-05 12:06:57 GMT <AFaust> http://docs.alfresco.com/5.2/references/dev-extension-points-module-component.html

2018-01-05 12:06:58 GMT <alfbot> Title: Module Components | Alfresco Documentation (at docs.alfresco.com)

2018-01-05 12:14:25 GMT <Hiten> Thanks Axel. So, I should search for the OOTB templates and delete them and then import my version of OOTB templets

2018-01-05 12:14:55 GMT <Hiten> using Module Components

2018-01-05 12:25:38 GMT <AFaust> That's what I would do, yes

2018-01-05 12:29:34 GMT <Hiten> Thanks a lot Axel for your input

2018-01-05 12:35:21 GMT *** yreg is now known as Guest30083

2018-01-05 12:35:52 GMT *** Guest30083 is now known as yregaieg

2018-01-05 13:46:50 GMT <hi-ko_> I just took a look to alfresco-business-reporting module. It is outdated but I like the way how it is implemented. not the overkill like the pentaho or solr approach

2018-01-05 13:50:11 GMT <hi-ko_> Q: has anybody seen that the OrphanedContentCleaner removes full hierarchies in case of symlinks?

2018-01-05 13:53:26 GMT <hi-ko_> the class org.alfresco.repo.content.filestore.FileContentStore supports the boolean deleteEmptyDirs and as a work around we expose that boolean by with custom spring config to avoid removing "empty" directories

2018-01-05 13:53:47 GMT <hi-ko_> alfresco: a symlink is not an empty directory!

2018-01-05 14:16:25 GMT <AFaust> hi-ko: Well, they use what the Java File API provides

2018-01-05 14:17:14 GMT <AFaust> And if that says "X is a directory" and it contains no files, then what can they do other than delete it (if configured that way)...

2018-01-05 14:19:07 GMT <AFaust> Support for handling symbolic links was only added via the NIO package in Java 1.7 I believe...

2018-01-05 14:22:23 GMT * AFaust makes a note for himself: https://github.com/Acosix/alfresco-simple-content-stores/issues/10

2018-01-05 14:28:57 GMT <hi-ko_> <AFaust

2018-01-05 14:29:17 GMT <hi-ko_> AFaust: does alfresco-simple-content-stores

2018-01-05 14:29:18 GMT <hi-ko_> support alfresco 5.2?

2018-01-05 14:30:50 GMT <hi-ko_> AFaust: sorry - rtfm: "is built to be compatible with Alfresco 5.2 and above"

2018-01-05 14:41:10 GMT <jelte> I'm trying to use FTS using TMQs on an upgraded Alfresco (upgraded from 4.0 to 4.2 to 5.1f). However I'll get timeouts when trying to use the OR clause in the queries. I have executed both patches as instructed in the Alfresco docs. When setting the solr.query.fts.queryConsistency to EVENTUAL the queries will work, but then obviously TMQ isn't used. There are NO errors in the logs, until the FTS query is executed. Does anyone have a

2018-01-05 14:47:14 GMT <AFaust> jelte: How selective is your FTS query? (How many results to you expect should match in the database?)

2018-01-05 14:47:45 GMT <AFaust> ^^ I mean before permission checks are applied...

2018-01-05 14:48:10 GMT <AFaust> It would also help if you could provide the FTS query for reference

2018-01-05 14:48:22 GMT <jelte> It should have 2 results, it's using PARENT.. That folder only contains 7 files in total

2018-01-05 14:50:05 GMT <AFaust> Is it only using PARENT or are there other sections in the query? What are you OR-ing then?

2018-01-05 14:50:59 GMT <jelte> ASPECT:op\:customAspect AND PARENT:workspace\://SpacesStore/1c96da81-8b4d-4bd7-87f0-f921fd1879c7 AND (=op:customPropOne:admin OR =op:customPropTwo:GROUP_CreatedUserGroup )

2018-01-05 14:51:16 GMT <jelte> That's the query I'm using

2018-01-05 14:52:21 GMT <MTielemans> jelte, are those d:text type props?

2018-01-05 14:52:25 GMT <AFaust> How many value instances for your customPropOne / customPropTwo exist in the database? How much is that in relative terms (to other properties)?

2018-01-05 14:53:15 GMT <AFaust> TMQ is somewhat susceptible to performance degredation due to data distribution skewage

2018-01-05 14:54:07 GMT <AFaust> Most of what I am asking for is sourced from / mentioned in one of my talks: http://beecon.buzz/2017/assets/files/E10/Making%20proper%20use%20of%20transactional%20metadata%20queries.pdf

2018-01-05 14:55:37 GMT <AFaust> I assume you are using either MySQL, MariaDB or PostgreSQL, since this is a community install...

2018-01-05 14:57:48 GMT <jelte> I'm using PostgreSQL yeah, and I also skimmed through your slides.

2018-01-05 14:58:48 GMT <jelte> And yeah they are type d:text

2018-01-05 15:01:33 GMT <jelte> I'm currently counting how many value instances there are for proptwo, for propone there are 278112 instances.

2018-01-05 15:04:51 GMT <jelte> PropTwo value count is 277282, and there are 1,1 million node records in DB...

2018-01-05 15:11:11 GMT <jelte> I have to go now, I'll be back in about half an hour

2018-01-05 15:15:17 GMT <AFaust> Ok - that is (relatively speaking) quite a lot. Would be interesting too how the value distribution is across those properties, e.g. large chunks of nodes with similar values or very distinctive ones...

2018-01-05 15:15:53 GMT <AFaust> But in general, this looks (at first, very rough glance given your data) like a potential DB statistics / query planning issue.

2018-01-05 15:16:19 GMT <MTielemans> The properties store usernames and groups, so there´s a good chance they´re relatively similar values.

2018-01-05 15:16:40 GMT <AFaust> Yeah - and if there are too many identical values, DB tends to opt for table scan...

2018-01-05 15:17:50 GMT <AFaust> as going through the index and fetching all the pages with nodes that have the same value may be more expensive then to just go through all pages and save the index lookup "overhead"

2018-01-05 15:18:26 GMT <AFaust> Of course depends quite a lot on the memory assigned to PostgreSQL, i.e. if it can hold index data in memory or not...

2018-01-05 15:19:04 GMT <MTielemans> Would PG´s choice between table scanning vs use of index change based on the available memory/memory settings?

2018-01-05 15:19:33 GMT <AFaust> Of course, since access to index on disk vs. index in memory has different cost estimates

2018-01-05 15:28:17 GMT <AFaust> And if estimates (based on statistics) are off in a way that PG has to assume the index can't help cut down on the number of disk accesses or requires too many disk accesses to process by itself, the query planner may "think" table scan is cheaper

2018-01-05 15:29:17 GMT <AFaust> Since Alfresco write all properties in one table and they are written in groups based on the node instead of the property, the data for such property queries is extremely fragmented across many data pages.

2018-01-05 15:51:13 GMT <jelte> I'm back

2018-01-05 16:53:21 GMT <yreg> ~since

2018-01-05 16:53:22 GMT <alfbot> yreg: <Tuxpan_> hello everyone, <Tuxpan_> how can i clear files that have been deleted i.e they are in the archive spacestore, <Alfresco> Hi, <Alfresco> I want to check that alfresco and citrix integration, <Alfresco> Check whether Alfresco complies to the following requirement. Solution must be Citrix certified and / or Citrix ready and officially support the following technical specifications: 1 - Citrix (24 more messages)

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco