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

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:37:27 GMT <AFaust> I sort of remember having mentioned to someone (maybe you) in this channel weeks ago, that you cannot simply include the web-previewer component in task-edit and expect it to work. You will always need to have some JavaScript client-side glue code to handle selection in the list of documents in the workflow and dynamic display / loading of the web preview

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 13:49:43 GMT <fwu> is it possible to use only css or regionids to display the viewer on the right side or I will need to use javascript?

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

End of Daily Log

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