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.
2017-08-31 00:43:14 GMT <qwebirc60238> Hello
2017-08-31 00:44:01 GMT <qwebirc60238> Could you help me please ?
2017-08-31 00:48:36 GMT <neath> Hello
2017-08-31 02:46:45 GMT <resplin> neath: hello
2017-08-31 06:38:17 GMT <chandu> Hello All,
2017-08-31 06:49:57 GMT <chandu> I m using alfresco 5.2.e. Can you please suggest me that how to generate the alfresco reports except Alflytics.
2017-08-31 06:50:21 GMT <Tichodroma> what are "the alfresco reports"?
2017-08-31 06:51:14 GMT <chandu> Like AAAR reports
2017-08-31 06:54:13 GMT <chandu> Tichodroma: audit analysis reports.
2017-08-31 07:04:25 GMT <chandu> I m using alfresco 5.2.e. Can you please suggest me that how to generate the alfresco reports except Alflytics.
2017-08-31 07:56:58 GMT <DarkStar1> 'morning everyone
2017-08-31 08:04:16 GMT <chandu> DarkStar1: Morning! Can you please suggest me that if any documentation of reports for alfresco.
2017-08-31 08:04:27 GMT <chandu> except Alflytics
2017-08-31 08:04:39 GMT <chandu> i am using alfresco 5.2.e
2017-08-31 08:05:27 GMT <chandu> using windows platform
2017-08-31 08:11:30 GMT <DarkStar1> chandu: To be honest that area isn't my forte so to speak. If you're very much aware or versed in that area ("data science" I believe it's called) you could use other tools to do your reporting. fcorti_ 's initial AAAR project (http://fcorti.com/alfresco-audit-analysis-reporting/) is a brilliant start for this or you could try developing something using Grafana: http://docs.grafana.org/plugins/developing/development/. In any case, fcorti_
2017-08-31 08:11:30 GMT <DarkStar1> is the best :) and only authority I know of in this area when it comes to Alfresco.
2017-08-31 08:11:31 GMT <alfbot> Title: A.A.A.R. - Alfresco Audit Analysis and Reporting - F. Corti (at fcorti.com)
2017-08-31 08:12:04 GMT <DarkStar1> Sorry I can't help you any further.
2017-08-31 08:12:19 GMT <fcorti_> Thank you DarkStar1 for the feedback.
2017-08-31 08:12:30 GMT <fcorti_> chandu as alternative you can use a "manual approach"
2017-08-31 08:13:11 GMT <fcorti_> You can: develop a webscript on Alfresco side creating a PDF with the content you'd require.
2017-08-31 08:13:22 GMT <DarkStar1> fcorti_: Just stating the obvious buddy. No thanks is required :)
2017-08-31 08:13:31 GMT <fcorti_> Then you could invoke the webscript from Share or any other tool
2017-08-31 08:13:37 GMT <fcorti_> DarkStar1 :-)
2017-08-31 08:14:13 GMT <fcorti_> chandu I'm aware also on few legacy solutions but they are not Open Source, as I know.
2017-08-31 08:20:28 GMT <chandu> fcorti: thank you and DarkStar1 :-)
2017-08-31 08:21:13 GMT <fcorti_> chandu: now I ask you something back :-)
2017-08-31 08:21:35 GMT <DarkStar1> Has anyone noticed their localhost_access logs are really huge in alfresco 5.2? This is the second time I've come across this symptom
2017-08-31 08:21:36 GMT <fcorti_> Please share (with any limit, please) why not Alflytics
2017-08-31 08:22:08 GMT <fcorti_> This is a feedback for me and I would like to know the truth ;-)
2017-08-31 08:26:50 GMT <chandu> i tried Alflytics couple of days back. As you said previously that there is bug on windows, so i did not try again in windows. But my colleagues are trying in linux.
2017-08-31 08:27:17 GMT <chandu> if any i will let you know.
2017-08-31 08:28:07 GMT <chandu> fcorti: Really thank you very much for your support.
2017-08-31 08:28:10 GMT <fcorti_> chandu: thank you for the honest feedback, but don't feel "forced" to use it. I continue to think it is still the best solution today, but I don't want everyone to think the same. :-)
2017-08-31 08:28:40 GMT <fcorti_> In any case, the bug on win are limited (and I'm pretty sure today only one exists)
2017-08-31 08:29:01 GMT <fcorti_> I'm working with one use case to solve it
2017-08-31 08:29:19 GMT <fcorti_> I'm aware on few cases of success on Win
2017-08-31 08:29:21 GMT <fcorti_> FYI
2017-08-31 08:34:45 GMT <chandu> fcorti: We were stuck at the extraction step but after changing the port to 8080 as suggested by you we could able to complete the extraction process. We would now carry on from there as we want to develop some custom reports out from alfresco.
2017-08-31 08:35:10 GMT <chandu> we are trying in linux.
2017-08-31 08:35:28 GMT <fcorti_> In the latest artifact, this issue is solved (new bugs apart, of course)
2017-08-31 10:31:07 GMT <hi-ko> does anybody know if index.subsystem.name=noindex should work with db-afts/exact db search? I don't get it running. We have a huge system where we try to avoid solr at all since we only need special metadata search
2017-08-31 10:34:18 GMT <hi-ko> I found https://issues.alfresco.com/jira/browse/MNT-16625 but don't understand if subsystem noindex should find anything. I don't get any return on exact search ("=custom:field:1234")"
2017-08-31 11:40:18 GMT <AFaust> hi-ko: db-fts is defined in the common-search-context.xml which gets imported by noindex subsystem, so I would assume it is supported.
2017-08-31 11:41:09 GMT <AFaust> MNT-16625 just deals with the node DB ID that can currently not be queried via TMQs
2017-08-31 11:41:59 GMT <AFaust> But the ticket does implicitly confirm that noindex + db-fts work
2017-08-31 11:42:24 GMT <AFaust> The reported stated that he got 0 results when running =sys:node-dbid:"18455" - if db-fts was not supported then it should have thrown an error
2017-08-31 11:43:11 GMT <AFaust> But the rewritten SQL simply looks at the wrong column - it tries to find a match in alf_node_properties since sys:node-dbid is lacking special handling to check alf_node.id
2017-08-31 11:46:52 GMT <AFaust> i.e. there already is a special support for the UUID
2017-08-31 11:47:38 GMT <AFaust> Though that is primarily designed for CMIS query support (cmis:objectId)
2017-08-31 11:53:46 GMT <bleudemer> hello all, where can i find my current namespace ? where is it stored ?
2017-08-31 12:13:08 GMT <hi-ko> AFaust: Thanks for your feedback. In the meantime we have a testsystem set up where this works more or less. The difference I can see is the configured db: mysql vs. postgres. Maybe mysql is not working ... ?
2017-08-31 12:14:08 GMT <AFaust> In what way does MySQL behave differently? Generally there is no special support for any DB and I have never noticed any differences. I have customers both on MySQL/MariaDB and PostgreSQL using TMQ
2017-08-31 12:14:57 GMT <AFaust> Though MySQL does have a special Ibatis SQL mapping for TMQ
2017-08-31 12:15:15 GMT <AFaust> Currently checking the difference(s) to the base dialect
2017-08-31 12:16:11 GMT <AFaust> Only difference is the fetchSize for informing the DB how to handle results cursor
2017-08-31 12:16:48 GMT <hi-ko> we try remote debugging to see what's going on at all. do you know log4j classes for debug?
2017-08-31 12:19:46 GMT <AFaust> org.alfresco.repo.search.impl.querymodel.impl.db.DBQueryEngine is the main class but does not have a Log4J logger
2017-08-31 12:20:38 GMT <AFaust> The most low-level logger is usually the one for org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage - but that should not be active in noindex
2017-08-31 12:21:12 GMT <hi-ko> agree ;-)
2017-08-31 12:21:35 GMT <AFaust> Though - it actually is active
2017-08-31 12:21:52 GMT <AFaust> Since fts-alfresco is defined in common-search-context.xml and noindex includes it, it is using that class
2017-08-31 12:22:04 GMT <AFaust> It just does not have an index to fallback onto
2017-08-31 12:23:05 GMT <AFaust> Though technically it has an index searcher factory - the org.alfresco.repo.search.impl.noindex.NoIndexIndexerAndSearcherFactory
2017-08-31 12:23:44 GMT <AFaust> So yeah - use the DbOrIndex-thingy
2017-08-31 12:26:51 GMT <fwu> hi all
2017-08-31 12:34:27 GMT <hi-ko> AFaust: we found the reason be remote debugging: SchemaUpgradeScriptPatch not applied. Looks like a previous Upgrade was not successful ...
2017-08-31 12:35:07 GMT <AFaust> Well - that patch is optional, so it must be explicitly enabled
2017-08-31 12:37:21 GMT <hi-ko> wtf - how?
2017-08-31 12:48:58 GMT <Tichodroma> id = 'patch.db-V5.1-metadata-query-indexes'
2017-08-31 12:58:18 GMT <hi-ko> AFaust: your mean: system.metadata-query-indexes.ignored=false
2017-08-31 12:58:47 GMT <AFaust> correct
2017-08-31 12:59:02 GMT <AFaust> And if you have 5.1 and above there is a second one
2017-08-31 12:59:13 GMT <AFaust> system.metadata-query-indexes-more.ignored=false
2017-08-31 13:00:10 GMT <hi-ko> just found it - thanks.
2017-08-31 13:00:35 GMT <hi-ko> should be added to the release notes ...
2017-08-31 13:00:47 GMT <hi-ko> or enabled by default ;-)
2017-08-31 13:01:10 GMT <AFaust> It is included in the documentation and was included in some upgrade guides with 4.2 (AFAIK)
2017-08-31 13:01:43 GMT <AFaust> And it is not enabled by default since it can take a long time on large repositories / DBs, and customer / user may not need it if they don't plan to use TMQ
2017-08-31 13:01:52 GMT <AFaust> It is enabled by default in all new installations of 5.1 and above
2017-08-31 13:02:01 GMT <AFaust> Since the patch is part of the schema bootstrap
2017-08-31 13:03:19 GMT <AFaust> It was definitely included in my BeeCon talk that condensed a lot of the information on TMQs...
2017-08-31 13:03:55 GMT <hi-ko> hehe - so I have to watch it ;-)
2017-08-31 13:04:04 GMT <fwu> ppl, Im trying to display a document preview in my task form
2017-08-31 13:04:04 GMT <AFaust> Or download the slides...
2017-08-31 13:04:52 GMT <fwu> im adding a region to the ftl and a component to the xml file. shoudnt this be enought in 5.2?
2017-08-31 13:05:29 GMT <AFaust> "enough" for what? Enough for the region to show or enough for the region/component to actually work?
2017-08-31 13:06:11 GMT <AFaust> Also you should mention to what specific FTL and XML files you have added stuff..
2017-08-31 13:06:25 GMT <fwu> AFaust, good point. The component Im using I beleive is the default one
2017-08-31 13:06:43 GMT <fwu> so it should work as soon as I set a region, or not?
2017-08-31 13:06:45 GMT <AFaust> Because "the ftl" can be the wrong one and we might assume a different one than you touched
2017-08-31 13:07:03 GMT <fwu> I can test that, give me 2 minutes
2017-08-31 13:08:32 GMT <AFaust> I wanted you to give use file names / paths so we can actually work with your question, not necessarily for you to test "something" (don't know what from my responses you are testing now, to be honest)
2017-08-31 13:09:52 GMT <fwu> AFaust, Im just testing that Im changing the file Im looking at
2017-08-31 13:10:06 GMT <fwu> but I can paste the code, of course
2017-08-31 13:11:47 GMT <hi-ko> AFaust (akna Mr. TQM): Is there any chance to get search working in Share with noindex / TQM? It doesn't look like.
2017-08-31 13:11:59 GMT <fwu> Im not changing the default files. Im changing files from an addon
2017-08-31 13:12:43 GMT <fwu> ftl file: I add the web preview region: http://www.heypasteit.com/clip/0IIRXP
2017-08-31 13:12:44 GMT <alfbot> Title: Clip #0IIRXP (at www.heypasteit.com)
2017-08-31 13:14:10 GMT <fwu> xml file. I added the web-preview component: http://www.heypasteit.com/clip/0IIRXQ
2017-08-31 13:14:11 GMT <alfbot> Title: Clip #0IIRXQ (at www.heypasteit.com)
2017-08-31 13:16:26 GMT <AFaust> hi-ko: For one, I would not recommend Share search using TMQ for performance reasons (see my slides regarding "keeping result set low" and "Lucene-like permission check overhead")
2017-08-31 13:17:55 GMT <AFaust> hi-ko: But it should be possible by modifying the default query template to remove TEXT, TAG and all the ml:text properties...
2017-08-31 13:18:31 GMT <AFaust> Though it would only work for the global search - site-specific search will never work
2017-08-31 13:19:05 GMT <hi-ko> AFaust: just watching ... - I just want to avoid this very expensive solr instance with a 200g index (without full text) just to search for 2 props.
2017-08-31 13:19:19 GMT <AFaust> Ah - damnit... ok, it will NEVER work, since the query.lib.js adds a PATH filter query even for global searches
2017-08-31 13:21:15 GMT <hi-ko> actually we are now discussing to add/replace the quick search to avoid the whole solr stuff since the ct doesn't like the poor support for metadata search
2017-08-31 13:25:47 GMT <fwu> hi-ko I actually hide the quick search. Users have a direct link to advance search
2017-08-31 13:30:22 GMT <hi-ko> fwu: we already added a (hard coded) selector for some metadata properties but need to make this more configurable
2017-08-31 13:33:23 GMT <fwu> AFaust, Im getting this now:
2017-08-31 13:33:27 GMT <fwu> Error Code Information: 500 - An error inside the HTTP server which prevented it from fulfilling the request. Error Message: 07310010 Failed to execute script 'classpath*:alfresco/site-webscripts/org/alfresco/components/preview/web-preview.get.js': 07310009 Error: Parameter "nodeRef" is missing. (file:/C:/alf5.2_201707/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/preview/web-preview.get.js#1228)
2017-08-31 13:33:48 GMT <fwu> even if I have a document. the noderef is not set to the previewer.
2017-08-31 13:35:28 GMT <AFaust> fwu: Of course it isn't, since the task-edit page is never called with a nodeRef URL parameter (unless you did a customisation for that somewhere)
2017-08-31 13:35:54 GMT <AFaust> And also, what is supposed to happen for a task with more than one document attached in the workflow? Which node should then be previewed?
2017-08-31 13:36:02 GMT <fwu> ah, ok. let me see that
2017-08-31 13:41:07 GMT <fwu> AFaust, it was not me. Nevertheless, I will limit the scope for the first document on the list
2017-08-31 13:46:02 GMT <fwu> it is working adding a nodref. thank you. I now need to display it on the right side of the form, and not on the bottom and add the noderef dynamically.
2017-08-31 13:46:14 GMT <fwu> for testing I added to the url manually
2017-08-31 14:34:43 GMT *** angelborroy_ is now known as angelborroy
2017-08-31 14:42:28 GMT <bleudemer> where can i find the namespace for my Content ? where is it stored ?
2017-08-31 14:42:57 GMT <douglascrp> bleudemer, what do you mean?
2017-08-31 14:43:42 GMT *** angelborroy_ is now known as angelborroy
2017-08-31 14:47:39 GMT <bleudemer> When i defined a new model, or if y try to use an existing tuto model, i have to change the file customModel.xml with my own namespace
2017-08-31 15:00:08 GMT <resplin> bleudemer: You pick any one you want, and define it in your model.
2017-08-31 19:36:38 GMT <fwu> back
The other logs are at http://esplins.org/hash_alfresco