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

2019-06-19 01:59:26 GMT <alfresco-discord> <kanat> server logs

2019-06-19 01:59:27 GMT <alfresco-discord> <kanat> https://cdn.discordapp.com/attachments/451644531323174914/590722270922801176/unknown.png

2019-06-19 02:00:01 GMT <alfresco-discord> <kanat> server logs2

2019-06-19 02:00:01 GMT <alfresco-discord> <kanat> https://cdn.discordapp.com/attachments/451644531323174914/590722408067891230/unknown.png

2019-06-19 05:28:31 GMT *** onu_ is now known as onu

2019-06-19 06:18:03 GMT <AFaust> kanat: screenshots of logs are quite awkward to handle - I advise you to provide text file attachments in the future

2019-06-19 06:24:59 GMT <AFaust> kanat: In any way, this has confirmed for me that you are using an old version of JS Console. The line numbers do not align with the most recent version(s). Please use the most recent release found via https://search.maven.org/search?q=g:de.fmaul

2019-06-19 06:29:32 GMT <AFaust> It also looks like the second error is actually caused by how you use / pass around ScriptNode instances. It looks like you have obtained a ScriptNode in a non-standard way which is not fully initialised. It is lacking a JavaScript scope object, which is required for its internal processing, e.g. when creating native arrays for source assocs etc.

2019-06-19 06:30:57 GMT <AFaust> I see in your script that you are using some custom JS extensions for dealing with embedded Activiti. I would assume that one of those does not provide you with a correctly initialised ScriptNode, as I have seen too many instances of community code where someone just did a "new ScriptNode" call and thought it was enough...

2019-06-19 08:05:22 GMT <alfresco-discord> <MorganP> @Francesco Corti @kgastaldo Alfresco docs seems a little bit off

2019-06-19 08:05:53 GMT <alfresco-discord> <MorganP> When you click on links on the right side, it redirects to a docsstaging URL which is ending on an error/not reachable

2019-06-19 08:06:02 GMT <alfresco-discord> <Francesco Corti> ouch...

2019-06-19 08:06:03 GMT <alfresco-discord> <MorganP> Could you take a look ?

2019-06-19 08:06:10 GMT <alfresco-discord> <MorganP> I mean ask someone to take a look

2019-06-19 08:06:18 GMT <alfresco-discord> <Francesco Corti> I'm meeting with the Documentation team in one hour... will tell them

2019-06-19 08:06:23 GMT <alfresco-discord> <Francesco Corti> thank you for the heads up

2019-06-19 08:06:30 GMT <alfresco-discord> <MorganP> Thanks

2019-06-19 08:06:49 GMT <alfresco-discord> <MorganP> I can write the URL and it's working but navigation through the doc is a little bit hard if you need to manually type the URL each time 馃槃

2019-06-19 08:07:18 GMT <angelborroy> MorganP can you include a sample

2019-06-19 08:07:26 GMT <angelborroy> I鈥檓 navigating fine now

2019-06-19 08:08:45 GMT <alfresco-discord> <MorganP> it seems to be working now

2019-06-19 08:08:52 GMT <alfresco-discord> <MorganP> links points again to docs.alfresco.com

2019-06-19 08:09:20 GMT <alfresco-discord> <MorganP> This was a link I could see for example: https://docsstaging.alfresco.com/2046331/6.1/concepts/ch-install.html

2019-06-19 08:09:42 GMT <alfresco-discord> <MorganP> Access this URL

2019-06-19 08:09:43 GMT <alfresco-discord> <MorganP> https://docs.alfresco.com/6.1/concepts/activemq-overview.html

2019-06-19 08:09:44 GMT <alfbot> Title:Configuring ActiveMQ | Alfresco Documentation (at docs.alfresco.com)

2019-06-19 08:09:58 GMT <alfresco-discord> <MorganP> If you look at the links on the left side, you can see they are all "docsstaging"

2019-06-19 08:10:29 GMT <alfresco-discord> <MorganP> But if you access to this: https://docs.alfresco.com/6.1/tasks/prep-filesys-db.html => Then the links on the left are correct to docs.alfresco.com

2019-06-19 08:10:30 GMT <alfbot> Title:Preparing the filesystem and database | Alfresco Documentation (at docs.alfresco.com)

2019-06-19 08:10:33 GMT <alfresco-discord> <MorganP> Strange

2019-06-19 09:26:56 GMT <alfresco-discord> <Francesco Corti> @MorganP I talked with the Doc Team and they are aware. They are facing the issue.... hopefully it will be solved (very) soon.

2019-06-19 10:00:15 GMT <alfresco-discord> <Thijs> This query seems to be executed on a fairly regular basis on a clients Alfresco 5.1.4 backed by PostgreSQL:

2019-06-19 10:00:16 GMT <alfresco-discord> <Thijs> select app.app_name_id as audit_app_name_id, entry.id as audit_entry_id, entry.audit_user_id as audit_user_id, entry.audit_time as audit_time, entry.audit_values_id as audit_values_id from alf_audit_app app join alf_audit_entry entry on (entry.audit_app_id =

2019-06-19 10:00:17 GMT <alfresco-discord> app.id) WHERE app.app_name_id = 1 order by entry.id asc

2019-06-19 10:00:44 GMT <alfresco-discord> <Thijs> select app.app_name_id as audit_app_name_id, entry.id as audit_entry_id, entry.audit_user_id as audit_user_id, entry.audit_time as audit_time, entry.audit_values_id as audit_values_id from alf_audit_app app join alf_audit_entry entry on (entry.audit_app_id =

2019-06-19 10:00:45 GMT <alfresco-discord> app.id) WHERE app.app_name_id = 1 order by entry.id asc

2019-06-19 10:01:23 GMT <alfresco-discord> <Thijs> https://pastebin.com/kNa2cqzZ

2019-06-19 10:01:24 GMT <alfbot> Title:select app.app_name_id as audit_app_name_id, - Pastebin.com (at pastebin.com)

2019-06-19 10:01:30 GMT <alfresco-discord> <Thijs> any idea where it comes from?

2019-06-19 10:07:06 GMT <alfresco-discord> <plus-> is the acs-community-ngnix closed source?

2019-06-19 10:07:12 GMT <alfresco-discord> <plus-> can't find the repo

2019-06-19 10:26:25 GMT <AFaust> plus-: Who should own that repository? I am not aware of anything named like that provided by Alfresco themselves... but maybe I have missed some things...

2019-06-19 10:26:47 GMT <AFaust> Thijs: That is the regular audit entry query used by AuditQueryService / AuditQueryDAO

2019-06-19 11:11:50 GMT <alfresco-discord> <plus-> https://github.com/Alfresco/acs-community-deployment/blob/master/docker-compose/docker-compose.yml#L89

2019-06-19 11:11:51 GMT <alfbot> Title:acs-community-deployment/docker-compose.yml at master 路 Alfresco/acs-community-deployment 路 GitHub (at github.com)

2019-06-19 11:40:52 GMT <alfresco-discord> <Thijs> That query takes a long time, while returning 0 results

2019-06-19 11:41:03 GMT <alfresco-discord> <Thijs> 15s

2019-06-19 11:41:20 GMT <alfresco-discord> <Thijs> and actually, it is very simple

2019-06-19 11:46:01 GMT <alfresco-discord> <yreg> @Thijs it seems like an issue with your plan, it should filter before joining

2019-06-19 11:46:24 GMT <alfresco-discord> <Thijs> yes

2019-06-19 11:46:29 GMT <alfresco-discord> <Thijs> it is an issue with the plan

2019-06-19 11:46:41 GMT <alfresco-discord> <Thijs> QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop (cost=0.44..1326451.71 rows=8972615 width=40) (actual time=17011.440..17011.441 rows=0 loops=1) Join Filter: (app.id =

2019-06-19 11:46:42 GMT <alfresco-discord> entry.audit_app_id) Rows Removed by Join Filter: 26917844 -> Index Scan using alf_audit_entry_pkey on alf_audit_entry entry (cost=0.44..922683.01 rows=26917844 width=40) (actual time=0.073..9202.192 rows=26917844 loops=1) -> Materialize (cost=0.00..1.04 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=26917844) -> Seq Scan on alf_audit_app app (cost=0.00..1.04 rows=1 width=16) (actual

2019-06-19 11:46:42 GMT <alfresco-discord> time=0.022..0.024 rows=1 loops=1) Filter: (app_name_id = 1) Rows Removed by Filter: 2 Planning Time: 0.438 ms Execution Time: 17011.489 ms (10 rows)

2019-06-19 11:48:23 GMT <alfresco-discord> <Thijs> https://pastebin.com/HU7Axwr5

2019-06-19 11:48:24 GMT <alfbot> Title:alfresco=# explain analyse SELECT app.app_name_id AS audit_app_name_id, - Pastebin.com (at pastebin.com)

2019-06-19 12:52:21 GMT <Tichodroma> Performance question: I have a large tree for folders, five levels deep, up to 100 folders a each level. This is *huge*. Now I have the requirement to `setPermissions(...)` on this tree as far up as possible. This is no problem with three levels below, there are up to 1,000,000 folders which all inherit permissions. `setPermissions(...)` takes ~ 51 seconds.

2019-06-19 12:53:37 GMT <Tichodroma> But further up the tree the numer of folders grows exponentially. With four levels below, the org.alfresco.cache.node.nodesTransactionalCache fills up and I wonder if the method will ever return.

2019-06-19 12:54:29 GMT <Tichodroma> Do you have any experience setting permissions on such a structure? Maybe some performance tuning advice?

2019-06-19 13:48:16 GMT <alfresco-discord> <denok> Hi, what is the best/easiest approach if I want to override a method in WorkflowServiceImpl.java?

2019-06-19 13:49:02 GMT <AxelFaust> To not do it...

2019-06-19 13:49:36 GMT <alfresco-discord> <denok> Why not?

2019-06-19 13:49:38 GMT <AxelFaust> Services provided by Alfresco are generally not meant for extension / overrides.

2019-06-19 13:50:20 GMT <AxelFaust> Yes, you can do it, and yes, I have done so myself in the past, but usually only ever to fix some bugs.

2019-06-19 13:51:31 GMT <AxelFaust> But for anyone who is building an extension to Alfresco, overriding anything in core Alfresco should be considered off-limits. If there are other extensions in the same Alfresco system using these services, they have certain expectations about how these services operate, and by overriding them, you may break those expectations / implicit contracts.

2019-06-19 13:52:21 GMT <AxelFaust> My first question(s) in your case would be: Why do you want to override a method in WorkflowServiceImpl? Are there better alternatives to achieve the same outcome?

2019-06-19 13:54:55 GMT <alfresco-discord> <denok> Basically they want a special case where users in a specific group to have access to all tasks of a specific workflow. I was thinking of overriding or adding logic that runs before the isTaskEditable method to solve this.

2019-06-19 14:04:06 GMT <alfresco-discord> <MorganP> Alfresco 6.1 with JDK8, a good idea or a bad idea...?

2019-06-19 14:04:21 GMT <Tichodroma> Why not?

2019-06-19 14:04:40 GMT <angelborroy> It should work, as it鈥檚 compiled with OpenJDK 11 with compatibility for 8

2019-06-19 14:04:47 GMT <angelborroy> But I didn鈥檛 test that

2019-06-19 14:12:27 GMT <AxelFaust> On Monday I helped upgrade a customer to 6.1 who only had JDK 8 + Tomcat 7 prepared (for some reason).

2019-06-19 14:12:46 GMT <AxelFaust> It worked without problems, but we still scheduled an upgrade to JDK 11 + Tomcat 8.5 for Friday next week.

2019-06-19 14:13:17 GMT <AxelFaust> I have to note, they only had contacted on Monday morning for the first time because they had issues with the DB upgrade / migration.

2019-06-19 14:13:32 GMT <alfresco-discord> <MorganP> so recompile of all addons as well

2019-06-19 14:13:34 GMT <alfresco-discord> <MorganP> for jdk 11

2019-06-19 14:13:55 GMT <AxelFaust> Otherwise I would have done my darndest to have JDK 11 + Tomcat 8.5 ready before we began.

2019-06-19 14:14:25 GMT <AxelFaust> MorganP: There should be no need to recompile addons for JDK 11

2019-06-19 14:15:07 GMT <AxelFaust> Unless you are using some internal Java APIs that have changed between JDK versions, you barely ever need to recompile.

2019-06-19 14:15:17 GMT <alfresco-discord> <MorganP> Yes

2019-06-19 14:15:24 GMT <AxelFaust> (or unless Alfresco changes their APIs / libs in a major version upgrade)

2019-06-19 14:36:25 GMT <alfresco-discord> <MorganP> Someone already used the OOTB Support Tools with ACS 6.1?

2019-06-19 14:36:59 GMT <AxelFaust> Me...

2019-06-19 14:37:42 GMT <AxelFaust> As one of the maintainers as well as in two customer system, and various of my own test environments.

2019-06-19 14:38:06 GMT <alfresco-discord> <MorganP> You used the SDK 4.0 to build it? Or just kept the same amp as in 5.2'

2019-06-19 14:38:47 GMT <AxelFaust> denok: you know that there is also an additional workflow security handling done my the WorkflowPermissionInterceptor, right?

2019-06-19 14:41:09 GMT <AxelFaust> MorganP: No, we have not used SDK 4.0 yet. Actually, that is one thing that has kept us from releasing 1.1.0.0 (which is 6.1 compatible, while 1.0.0.0 will have issues with scheduled jobs in 6.1), as there was a suggestion to change packaging, which would / might involved upgrade to SDK 4 use, but I am still waiting for suggestions on how this can be done WITHOUT changing how the contents of the AMP are packaged.

2019-06-19 14:41:39 GMT <AxelFaust> See the discussion in https://github.com/OrderOfTheBee/ootbee-support-tools/pull/136

2019-06-19 14:41:41 GMT <alfbot> Title:Prepare release 1.1.0.0 by AFaust 路 Pull Request #136 路 OrderOfTheBee/ootbee-support-tools 路 GitHub (at github.com)

2019-06-19 14:43:08 GMT <AxelFaust> Wait - my comments regarding scheduled jobs actually have nothing to do with 1.1.0.0 + Alfresco 6.1 - that was already a thing we had to handle for 6.0...

2019-06-19 14:43:15 GMT <AxelFaust> So ignore that bit.

2019-06-19 14:43:37 GMT <AxelFaust> Still, I recommend to use the 1.1.0.0-SNAPSHOT over the 1.0.0.0 release

2019-06-19 14:47:56 GMT <alfresco-discord> <MorganP> Good to know there is the 1.1.0.0 on your repo, I didn't see that

2019-06-19 14:47:57 GMT <alfresco-discord> <MorganP> thx

End of Daily Log

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