Alfresco discussion and collaboration. Stick around a few hours after asking a question.
Official support for Enterprise subscribers: support.alfresco.com.
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.
More help is available in this list of resources.
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)
The other logs are at http://esplins.org/hash_alfresco