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-05-23 06:29:31 GMT <twen> hello

2017-05-23 06:39:46 GMT *** ChanServ sets mode: +o fcorti

2017-05-23 06:40:23 GMT *** fcorti changes topic to "Alfresco discussion and collaboration. Stick around a few hours after asking a question. Logs: http://chat.alfresco.com Channel help: https://community.alfresco.com/ Official support for Enterprise subscribers: http://support.alfresco.com. Next event is Tech Talk Live #106, the 14th of June."

2017-05-23 06:44:11 GMT <fcorti> morning twen

2017-05-23 06:44:15 GMT <fcorti> morning Loftux: about Alfresco AOS new release, I can anticipate there aren't "big anhancements" but some bugfixes. For further details, please raise a question on the community portal asking directly to resplin (and me so I can track it) and he will be happy to share details. Does it work for you?

2017-05-23 07:10:28 GMT <yreg> fwu, you need to re-add some models that were used in your repo to your alfresco, that message is usually the result of residual models

2017-05-23 07:11:36 GMT <yreg> if you must solve it without reinstalling original models, I can give you few queries to track down residual types/aspects/assocs/props

2017-05-23 07:12:13 GMT <yreg> you can then swap them with current models

2017-05-23 07:13:03 GMT <yreg> but be careful, it can mess up with your system really hard, so you need to have a backup of your Database first, and then turn alfresco off & on to clear the caches

2017-05-23 07:13:24 GMT <yreg> (not sure if the clear cache action from ootb support tools would be enough)

2017-05-23 07:23:33 GMT <twen> hey fcorti :)

2017-05-23 08:47:00 GMT <jebla> Hi, we are seeing a masive amount of [alfresco.propval.select_PropValueByStringValue] queries in (debug) log putting our MSSql server to a halt after upgrading from 4.1 to 5.1 enterprise. The query is hitting alf_prop_value join alf_prop_string_value. The indexes seems fine and the statistics are uptodate. I know this is a long shot, does anybody experienced something similar?

2017-05-23 09:01:31 GMT <erib> Just got a cut and paste requirement from a customer and remember that that functionality was present in the old Explorer GUI. Anyone tried to (or seen) any implementation of anything like this in Share? My thought is cut-and paste actions where the nodeRefs are stored in user cookies or something

2017-05-23 09:01:44 GMT <erib> Just got a cut and paste requirement from a customer and remember that that functionality was present in the old Explorer GUI. Anyone tried to (or seen) any implementation of anything like this in Share? My thought is cut-and paste actions where the nodeRefs are stored in user cookies or something? Sounds implementable?

2017-05-23 09:16:36 GMT <AFaust> jebla: How much data do you have in the alf_prop_* tables? Do you have auditing enabled / configured? That type of query is quite common when doing audit queries without audit data already having been cached (or with cache not having been enabled / configured)

2017-05-23 09:18:45 GMT <AFaust> erib: There was a hackathon project once about a pastebin functionality in Alfresco Share (I think around 2014)

2017-05-23 09:20:34 GMT <erib> AFaust: ok, thanks I have not googled hard enough or the traces of that project is gone... *googling some more*

2017-05-23 09:22:31 GMT <jebla> AFoust: We have about 14 millon in alf_prop_value and 20+ milion entries in alf_prop_value. We have auditing enabled, I'll need to check up on how the caching is setup

2017-05-23 09:50:08 GMT <AFaust> jebla: I assume you have never run cleanup on the audit data? Are all entries still relevant? In Alfresco 5.x there is a scheduled job that cleans up unused entries in alf_prop_* tables but it is not enabled by default

2017-05-23 09:50:28 GMT <AFaust> That job was actually added in 4.2

2017-05-23 09:50:52 GMT <AFaust> Though I believe it was added in one of the Enterprise Service Packs, not the general Community code line

2017-05-23 10:04:56 GMT <fwu> yreg, I believe my way is to try your queries. I need to have a clear process of deleting models because in Dev environment we need to change things a lot.

2017-05-23 10:05:35 GMT <fwu> I once delete active and completed wf in the database with success. I actually lost the queries then... :(

2017-05-23 10:05:54 GMT <fwu> but this is a little differeent: I need to delete the references to a workflow type

2017-05-23 10:17:28 GMT <yreg> fwu I do not have clean version of the scripts

2017-05-23 10:17:33 GMT <yreg> use at your own risk

2017-05-23 10:17:35 GMT <yreg> https://pastebin.com/Di8cTmPY

2017-05-23 10:17:36 GMT <alfbot> Title: [PL/SQL] Clean residual namespaces - Pastebin.com (at pastebin.com)

2017-05-23 10:18:08 GMT <fwu> yreg, I take the risk, dont worry :)

2017-05-23 10:33:19 GMT <fwu> yreg, why updates?

2017-05-23 10:33:31 GMT <fwu> cant I just delete them?

2017-05-23 11:15:20 GMT <yreg> fwu it dependends

2017-05-23 11:15:27 GMT <yreg> depends*

2017-05-23 11:15:40 GMT <yreg> if you would like to preserve/delete affected nodes

2017-05-23 11:15:55 GMT <yreg> (having residual types/aspects/props/assocs)

2017-05-23 11:36:58 GMT <fwu> ok yreg, thank you

2017-05-23 11:38:02 GMT <douglascrp> morning guys

2017-05-23 12:01:37 GMT <fwu> douglascrp, hi!

2017-05-23 12:07:08 GMT <douglascrp> fwu, hi

2017-05-23 12:07:11 GMT <cesarcapi> hi community! one question, do you know some addon for creating a logical year-month-day based "folderized structure" (yyyy/MM/dd) in Alfresco repository, for content added to an inbox folder ? With an inbox folder, I mean an entry point for uploading documents via CMIS, Share or webdav.

2017-05-23 12:07:56 GMT <douglascrp> cesarcapi, I don't know, but I am interested to know if you find one

2017-05-23 12:08:14 GMT <douglascrp> if I am not wrong, there was a talk at beecon on the topic

2017-05-23 12:11:30 GMT <cesarcapi> douglascrp, yes... more or less, I saw a talk related. We are trying to develope one addon for this purpose, but we found problems when doing jmeter tests (like in the Beecon talk)

2017-05-23 12:11:50 GMT <douglascrp> this one, right? https://www.youtube.com/watch?v=cJTrDI5EQFo&index=53&list=PLsgPx5pOHDtU7rXqh28jlMpvUU0iw1EoO

2017-05-23 12:13:36 GMT <cesarcapi> Nope, douglascrp, this one --> https://www.youtube.com/watch?v=S7r_1V-riq8&list=PLsgPx5pOHDtU7rXqh28jlMpvUU0iw1EoO&index=14

2017-05-23 12:14:52 GMT <douglascrp> are you sure? [BeeCon 2017] Lightning talks #1 - Alexey Vasyukov - Alfresco repo under concurrent write load

2017-05-23 12:14:55 GMT <douglascrp> this is the title

2017-05-23 12:15:41 GMT <cesarcapi> OMG!, my sessions torturing Shakespeare mother-language are also there :'(

2017-05-23 12:16:33 GMT <cesarcapi> yes, Alfresco repo under concurrent write load

2017-05-23 12:19:13 GMT <cesarcapi> basically he is trying to create a folder if exists, with many concurrent users

2017-05-23 12:22:11 GMT <douglascrp> ah, so there are two talks on the same subject

2017-05-23 12:24:11 GMT <douglascrp> cesarcapi, I have just watched the one I shared with you... he is only talking about metadata inheritance, so, really, it is not what you are looking for

2017-05-23 12:24:23 GMT <douglascrp> but it is ok, because at least I watched one more :D

2017-05-23 12:24:31 GMT <douglascrp> I am wathing yours now

2017-05-23 12:24:43 GMT <douglascrp> cesarcapi, OMG!, my sessions torturing Shakespeare mother-language are also there :'(

2017-05-23 12:24:56 GMT <douglascrp> come one... those were also useful

2017-05-23 12:25:11 GMT <douglascrp> don't torture yourself with that

2017-05-23 12:25:34 GMT <douglascrp> cesarcapi, I wish I could speak in public like you did

2017-05-23 12:41:05 GMT <erib> cesarcapi: well at least we have the functionality in one of our customer projects. Its not a generic addon though. Not so many lines of code...

2017-05-23 12:44:41 GMT <cesarcapi> erib, thanks, it does not seem very complicated indeed.. but when we tested we found many problems. This is why I asked if someone knows about an addon with this functionality.

2017-05-23 12:45:31 GMT <douglascrp> cesarcapi, I have just watched the talk you shared

2017-05-23 12:45:48 GMT <douglascrp> indeed, it does not affer a solution for the problem you have

2017-05-23 12:49:03 GMT <fwu> yreg, I searched for the namespace prefix verywhere in the database and I was not able to find it...

2017-05-23 12:49:16 GMT <fwu> so the error:Namespace prefix myPrefix is not mapped to a namespace URI

2017-05-23 12:49:45 GMT <douglascrp> cesarcapi, have you tried to find something in the alvex project source code?

2017-05-23 12:49:48 GMT <fwu> From where Alfresco is getting that prefix?

2017-05-23 12:49:57 GMT <douglascrp> I am not wrong, there must be something on that

2017-05-23 12:50:05 GMT <fwu> is not in my code now. And I cant see it in the database.

2017-05-23 12:50:34 GMT <douglascrp> cesarcapi, * if I am not wrong, there must be something on that

2017-05-23 12:58:04 GMT <erib> ceasarcapi: That functionality should be in the RM module, but a more generic one based on rules

2017-05-23 12:58:49 GMT <douglascrp> cesarcapi, no, it doesn's seem to be alvex

2017-05-23 13:03:03 GMT <douglascrp> cesarcapi, I found this one on beCPG https://www.becpg.fr/redmine/projects/becpg-community/repository/entry/becpg-core/src/main/amp/config/alfresco/module/becpg-core/context/action-context.xml#L32

2017-05-23 13:03:05 GMT <alfbot> Title: /becpg-core/src/main/amp/config/alfresco/module/becpg-core/context/action-context.xml - beCPG PLM Community - Forge beCPG (at www.becpg.fr)

2017-05-23 13:04:48 GMT <douglascrp> cesarcapi, and this https://www.becpg.fr/redmine/projects/becpg-community/repository/revisions/c363c3910aef/entry/becpg-core/src/main/java/fr/becpg/repo/hierarchy/impl/HierarchyServiceImpl.java#L105

2017-05-23 13:04:51 GMT <alfbot> Title: /becpg-core/src/main/java/fr/becpg/repo/hierarchy/impl/HierarchyServiceImpl.java - beCPG PLM Community - Forge beCPG (at www.becpg.fr)

2017-05-23 13:29:40 GMT <douglascrp> I am trying to provide a repository action execution through Share actions menu

2017-05-23 13:30:03 GMT <douglascrp> the problem is that this action may take some time to finish, more than the default timeout configured for share

2017-05-23 13:30:24 GMT <douglascrp> how could I execute this action in background, and tell to share not to wait for an answer?

2017-05-23 13:31:05 GMT <douglascrp> I mean, is it possible to simply start the action execution, make share show a message like "wait for notification by email", and let the user keep working on other things?

2017-05-23 13:31:28 GMT <douglascrp> what I could not find so far is how to make this action to be executed in behind the scenes

2017-05-23 13:32:24 GMT <douglascrp> angelborroy, any idea? I was trying to follow your example on the ocr addon, which uses a new transaction for the process

2017-05-23 13:32:40 GMT <douglascrp> but even with that, the action still does not return anything until it really finishes the processing

2017-05-23 13:33:13 GMT <angelborroy> which sample, douglascrp?

2017-05-23 13:33:44 GMT <erib> douglascrp: if you just configure it as async that should work out of the box I think?

2017-05-23 13:33:59 GMT <angelborroy> +1

2017-05-23 13:34:11 GMT <douglascrp> angelborroy, this one https://github.com/keensoft/alfresco-simple-ocr/blob/master/simple-ocr-repo/src/main/java/es/keensoft/alfresco/ocr/OCRExtractAction.java#L83

2017-05-23 13:34:12 GMT <alfbot> Title: alfresco-simple-ocr/OCRExtractAction.java at master · keensoft/alfresco-simple-ocr · GitHub (at github.com)

2017-05-23 13:34:24 GMT <douglascrp> erib angelborroy how can I do that in code?

2017-05-23 13:34:33 GMT <douglascrp> I know how it works when setting up a rule, for example

2017-05-23 13:34:38 GMT <angelborroy> you cannot

2017-05-23 13:34:39 GMT <douglascrp> but in this case, I have no idea

2017-05-23 13:34:42 GMT <angelborroy> right

2017-05-23 13:35:03 GMT <douglascrp> I guess this is a "Java" problem, and not Alfresco

2017-05-23 13:35:10 GMT <douglascrp> how to start a sub process and let it running

2017-05-23 13:35:12 GMT <angelborroy> you have to do make somethingl ike this https://angelborroy.wordpress.com/2015/05/22/alfresco-implementing-delete-behavior/

2017-05-23 13:35:13 GMT <alfbot> Title: Alfresco – Implementing delete behavior | Programming and So (at angelborroy.wordpress.com)

2017-05-23 13:35:18 GMT <erib> douglascrp: just call actionService with the last boolean asyn set to true

2017-05-23 13:35:28 GMT <erib> *async*

2017-05-23 13:35:37 GMT <douglascrp> hmmm, let me check

2017-05-23 13:35:43 GMT <erib> void executeAction(Action action, NodeRef actionedUponNodeRef, boolean checkConditions, boolean executeAsynchronously);

2017-05-23 13:44:04 GMT <douglascrp> ah, wait... I have a different situation here

2017-05-23 13:44:18 GMT <douglascrp> now I have just remembered that I have a webscript, and not a "action"

2017-05-23 13:44:55 GMT <douglascrp> I was away from this project for more than a week, and I forgot about that detail

2017-05-23 13:45:35 GMT <douglascrp> so, is there a way to execute the webscript in background? Or should I convert it into an action and use the async parameter?

2017-05-23 13:46:25 GMT <erib> if you operate on a NodeRef I think maybe it will be easier to convert it to an action and execute it asynchronously

2017-05-23 13:46:40 GMT <douglascrp> erib, it is a list of nodes actually

2017-05-23 13:47:16 GMT <douglascrp> this is the long story

2017-05-23 13:47:58 GMT <douglascrp> I am working an a action where the user selects a bunch of PDF files

2017-05-23 13:47:58 GMT <douglascrp> the action steps are

2017-05-23 13:47:58 GMT <douglascrp> split all the pdfs in individual pages

2017-05-23 13:47:58 GMT <douglascrp> then start merging them, never letting the final PDFs to get bigger than 1,4 MB

2017-05-23 13:47:58 GMT <douglascrp> that's because they have to send such pdfs to the court, for legal reasons

2017-05-23 13:47:58 GMT <douglascrp> the they do not accept anything bigger than that

2017-05-23 13:48:00 GMT <douglascrp> I am using ghostscript to do all the processing, like te split, the compress and the merge

2017-05-23 13:48:02 GMT <douglascrp> in the end, I zip the content and put it inside the user's home folder, and then send an email letting the user know the file is ready

2017-05-23 13:50:06 GMT <douglascrp> I am going to review my code and try to adopt the idea shown here https://nathanmcminn.com/2017/04/19/a-simple-pattern-for-alfresco-extensions-2/

2017-05-23 13:50:07 GMT <alfbot> Title: A Simple Pattern for Alfresco Extensions | (at nathanmcminn.com)

2017-05-23 13:50:07 GMT <erib> Then you could write an async method in the java webscript instead, and if you need to catch the execution result you should make us of FutureTask in java

2017-05-23 13:50:23 GMT <douglascrp> then I will try the async method

2017-05-23 13:50:51 GMT <erib> http://javarevisited.blogspot.se/2015/01/how-to-use-future-and-futuretask-in-Java.html

2017-05-23 13:50:52 GMT <alfbot> Title: How to use Future and FutureTask in Java Concurrency with Example (at javarevisited.blogspot.se)

2017-05-23 13:51:51 GMT <douglascrp> erib, interesting... thanks for that

2017-05-23 13:52:32 GMT <erib> Thats acutally how Alfresco themselves implements the async part in the ActionService

2017-05-23 13:53:11 GMT <douglascrp> I see

2017-05-23 13:57:12 GMT <douglascrp> erib, as I said before, it is a Java question, not Alfresco

2017-05-23 13:57:17 GMT <douglascrp> I'm going to try it

2017-05-23 13:57:31 GMT <erib> douglascrp: good luck :)

2017-05-23 13:57:36 GMT <douglascrp> tks

2017-05-23 14:17:23 GMT <jebla_> AFaust: A huge thank you, we managed to resolve our issues with your hint.

2017-05-23 14:22:16 GMT <douglascrp> jebla_, AFaust will not receive your message, as he is not online right now

2017-05-23 14:22:24 GMT <douglascrp> send it using this

2017-05-23 14:22:40 GMT <douglascrp> ~later tell jebla_ your message

2017-05-23 14:22:40 GMT <alfbot> douglascrp: The operation succeeded.

2017-05-23 14:22:50 GMT <douglascrp> replace jebla_ by AFaust

2017-05-23 14:24:34 GMT <douglascrp> jebla_, he will receive your thank you message when he is online again

2017-05-23 14:35:13 GMT <jebla_> ~later tell AFaust A huge thank you, we managed to resolve our issues with your hint.

2017-05-23 14:35:13 GMT <alfbot> jebla_: The operation succeeded.

2017-05-23 14:35:14 GMT <alfbot> jebla_: Sent 12 minutes ago: <douglascrp> your message

2017-05-23 14:35:28 GMT <jebla_> douglascrp: Thank you

2017-05-23 14:43:31 GMT <alfbot> AFaust: Sent 8 minutes ago: <jebla_> A huge thank you, we managed to resolve our issues with your hint.

2017-05-23 15:55:55 GMT <fwu> ppl, why Im getting a constraint violation trying to delete rows in the act_ru_task due to the act_ru_identitylink?

2017-05-23 15:56:07 GMT <fwu> i already deleted the rows from act_ru_identitylink

2017-05-23 15:56:33 GMT <fwu> *I deleted the referenced rows*

2017-05-23 16:19:11 GMT <fwu> ok, I solve my problem of the prefix references with truncate cascade ...

2017-05-23 16:19:41 GMT <fwu> for the dev environment its fine, because i want to be able to test without problems

2017-05-23 16:19:43 GMT <fwu> but

2017-05-23 16:20:18 GMT <fwu> i really need to solve this kind of problems. it is a huge alfresco potential problem in my opinion

2017-05-23 16:20:49 GMT <fwu> yreg, it seems the problem about the prefix was in the activiti tables

2017-05-23 16:21:40 GMT <fwu> only I truncate them the problem was solved. However in some tables im not able to delete rows as needed even if I had understood the problematic rows in each table

2017-05-23 16:27:49 GMT <fwu> actually I believe I can do that now setting this:

2017-05-23 16:28:00 GMT <fwu> SET CONSTRAINTS ALL DEFERRED;

2017-05-23 16:36:59 GMT <AFaust> yreg: is the problem of fwu something that could have been supported better if OOTBee Support Tools contains the Activiti cleanup tools we added as an issue / idea ?

2017-05-23 17:14:31 GMT <fwu> back

End of Daily Log

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