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-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
The other logs are at http://esplins.org/hash_alfresco