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-09-06 06:51:22 GMT <AFaust> Doing a test run for a customer's migration from 3.4 to 6.1 right now, and the first thing I've learned is: I have completely forgotten that older Alfresco / Java versions absolutely required memory tuning to just be able to start at all

2019-09-06 07:21:19 GMT *** r is now known as Guest80420

2019-09-06 07:25:06 GMT <alfresco-discord> <dgradecak> lucky you, I was stupid enough to accept maintaining an alfresco integration with grails 2 馃槃

2019-09-06 09:04:08 GMT <AFaust> Argh... Stupid Alfresco Maven artifact mess. For some reason, the alfresco-platform-5.2.6.war artifact on artifacts.alfresco.com is not a real Enterprise artifact, missing Enterprise DB upgrade scripts etc.

2019-09-06 09:07:32 GMT <AFaust> Ahh... looks like 5.2.6 hasn't even been published yet, and probably those 5.2.6 artifacts are just some wonky invalid build results

2019-09-06 09:09:13 GMT <angelborroy> I was using 5.2.6 last week and it seems to work fine

2019-09-06 09:09:20 GMT <angelborroy> What鈥檚 the problem?

2019-09-06 09:09:42 GMT <alfresco-discord> <Alexander Seitz> Since when was 5.2.6 released?

2019-09-06 09:09:58 GMT <AFaust> Well, the customer is using MS SQL, and when running the upgrade step for 4.2 -> 5.2, it complained that it could not locate the SQLs for the dialect.

2019-09-06 09:10:14 GMT <AFaust> I checked the exploded WAR, and there was no alfresco-enterprise-repository-xx.jar at all...

2019-09-06 09:10:15 GMT <angelborroy> I was using this file

2019-09-06 09:10:16 GMT <angelborroy> https://releases.alfresco.com/Enterprise-5.2/5.2.6/5.2.6/build-00018/ALL/alfresco-content-services-distribution-5.2.6.zip

2019-09-06 09:10:42 GMT <AFaust> I was using the alfresco-platform WAR artifact. No need for the full distribution...

2019-09-06 09:11:12 GMT <AFaust> Also loading from artifacts.alfresco.com, not whatever service releases.alfresco.com is...

2019-09-06 09:11:13 GMT <angelborroy> This one?

2019-09-06 09:11:14 GMT <angelborroy> https://releases.alfresco.com/Enterprise-5.2/5.2.6/5.2.6/build-00018/ALL/alfresco-content-services-platform-distributionzip-5.2.6.zip

2019-09-06 09:11:27 GMT <AFaust> NO DISTRIBUTION

2019-09-06 09:11:41 GMT <angelborroy> Sorry!

2019-09-06 09:11:59 GMT <AFaust> https://artifacts.alfresco.com/nexus/service/local/repositories/enterprise-releases/content/org/alfresco/alfresco-platform/5.2.6/alfresco-platform-5.2.6.war

2019-09-06 09:12:53 GMT <alfresco-discord> <Alexander Seitz> okay, but there was no official release yet: https://myalfresco.force.com/support/articles/en_US/Release_Notes/Alfresco-Content-Services-version-5-2-6?popup=true or page is not up yet..

2019-09-06 09:13:18 GMT <AFaust> Yes, that's what I realised when I had the customer check the support portal just now.

2019-09-06 09:13:37 GMT <angelborroy> It has been released internally

2019-09-06 09:13:51 GMT <angelborroy> But probably all the artifacts are not available yet

2019-09-06 09:14:23 GMT <angelborroy> Did you try this one?

2019-09-06 09:14:23 GMT <AFaust> But regardless, the artifact is crap - it should have either not been available, or it should have been a properly built one. Now it looks like a build from Community source without any Enterprise stuff, using an Enteprrise versio

2019-09-06 09:14:24 GMT <angelborroy> https://nexus.alfresco.com/nexus/service/local/repo_groups/private/content/org/alfresco/alfresco-platform-enterprise/5.2.6/alfresco-platform-enterprise-5.2.6.war

2019-09-06 09:14:43 GMT <AFaust> Ah... fml

2019-09-06 09:15:33 GMT <AFaust> Of course Alfresco Enterprise artifacts have their own special artifactID when the version should have been distinction enough....

2019-09-06 09:15:45 GMT <alfresco-discord> <Alexander Seitz> Is there a possible release date planned for 5.2.6 later this or next month? I'm planning a customer update from 5.2.2 to 2.5.latest and it would help to know a possible relase date

2019-09-06 09:16:17 GMT <angelborroy> It should be availalble in the next days

2019-09-06 09:16:18 GMT <AFaust> Seriously, on the date that Alfresco gets their Maven s*** together and has kept it together for more than a year, I am going to throw a huge party...

2019-09-06 09:18:36 GMT <alfresco-discord> <Thijs> AFaust: Am I invited?

2019-09-06 09:18:56 GMT <AFaust> Going to have to re-check my 6.1 target build now if I am actually using the correct artifacts as the base...

2019-09-06 09:19:12 GMT <angelborroy> Yes, this is the right one

2019-09-06 09:19:13 GMT <angelborroy> https://nexus.alfresco.com/nexus/service/local/repo_groups/private/content/org/alfresco/alfresco-platform-enterprise/5.2.6/alfresco-platform-enterprise-5.2.6.war

2019-09-06 09:19:39 GMT <angelborroy> But feel free to open a ticket about this

2019-09-06 09:20:22 GMT <AFaust> Thijs: I briefly considered a blank statement about "and everyone is invited", but then realised this is out in the open and could cost me a fortune. But when the time comes, I can surely manage to invite you and various other closer Alfresco community acquaintances...

2019-09-06 09:20:49 GMT <AFaust> But like a successful Brexit, the chances for that day to come are pretty slim...

2019-09-06 09:22:15 GMT <AFaust> Ah... My 6.1 build is safe, because of course the artifactIds have changed with 6.x again, and now it is the Community Edition which has a special suffix, no longer the Enterprise Edition...

2019-09-06 09:22:33 GMT <alfresco-discord> <Thijs> but you said a huge party, and when Germans claim a huge party, I'm thinking something Oktoberfesten like

2019-09-06 09:24:45 GMT <AFaust> Oktoberfest is not a "huge party". Oktoberfest is a travesty...

2019-09-06 09:30:19 GMT <alfresco-discord> <Thijs> I had to google travesty

2019-09-06 09:30:20 GMT <AFaust> Our variant of "bread and circus" for the masses

2019-09-06 09:30:21 GMT <AFaust> Which translation came up? Because depending on context, it can be a bit different...

2019-09-06 09:30:21 GMT <alfresco-discord> <Thijs> a false, absurd, or distorted representation of something.

2019-09-06 09:30:22 GMT <AFaust> Yeah - that fits mostly...

2019-09-06 09:37:57 GMT <alfresco-discord> <Alexander Seitz> Developer question regarding a timing issue with the sys:incomplete aspect we're currently facing: Is it possible to force the ADF app (filter query in app.config.json) to use transactional metaquery against the database? In app.config.json the search query looks like this: "component": { "selector": "check-list", "settings": { "options": [ { "name": "Metadaten

2019-09-06 09:37:57 GMT <alfresco-discord> unvollst盲ndig", "value": "ASPECT:'sys:incomplete'" } ] } } Internally the adf app uses the alfresco search rest api: https://api-explorer.alfresco.com/api-explorer/#!/search/search To make sure that the timing issue we're facing is not releated to the search running against the solr index (15 sec delay per default) I would like to set a similar option to the afts query like I can in java

2019-09-06 09:37:58 GMT <alfresco-discord> with the QueryConsistency setting: searchParameters.setQueryConsistency(QueryConsistency.EVENTUAL); // against Index searchParameters.setQueryConsistency(QueryConsistency.TRANSACTIONAL); // against DB

2019-09-06 09:37:59 GMT <alfbot> Title:Alfresco Content Services REST API Explorer (at api-explorer.alfresco.com)

2019-09-06 09:38:35 GMT <alfresco-discord> <bhagyas> @Alexander Seitz The bot seems to block repeated texts

2019-09-06 09:38:45 GMT <alfresco-discord> <bhagyas> @mbui wasn't this disabled earlier?

2019-09-06 09:40:00 GMT <AFaust> @Alexander Seitz: Public v1 ReST API does not have an option to specify consistency, so you have to rely on the default consistency being properly configured on the Repository tier.

2019-09-06 09:40:41 GMT <alfresco-discord> <Alexander Seitz> repository tier is set the "use db if possible"

2019-09-06 09:40:56 GMT <alfresco-discord> <Alexander Seitz> repository tier search config

2019-09-06 09:40:57 GMT <alfresco-discord> <Alexander Seitz> https://cdn.discordapp.com/attachments/451644531323174914/619467054235254784/unknown.png

2019-09-06 09:43:30 GMT <AFaust> Yeah, so if you then use a TMQ-compatible query (and Public v1 ReST API does not magically add something incompatible) you should be fine.

2019-09-06 09:44:16 GMT <AFaust> Though I find that an ASPECT query on sys:incomplete might be a bit extreme for a DB query without any further restrictions...

2019-09-06 09:44:49 GMT <AFaust> You should typically aim for queries with only a few hundred / max 1000-2000 results BEFORE permission checks

2019-09-06 09:45:21 GMT <AFaust> Otherwise you quickly risk causing table scans in the DB

2019-09-06 09:47:59 GMT <AFaust> And you can always verify by looking at log output of DbOrIndexSiwtchingQueryLanguage

2019-09-06 09:56:07 GMT <alfresco-discord> <Alexander Seitz> there are restriction on custom aspects...whole query looks like: "component": { "selector": "check-list", "settings": { "options": [ { "name": "Metadaten unvollst盲ndig", "value": "ASPECT:'sys:incomplete' AND (ASPECT:'customer:customaspect1' OR ASPECT:'customer:customaspect2')"" } ] } } this restricts the query to have only a view results

2019-09-06 10:22:14 GMT <alfresco-discord> <Alexander Seitz> @AFaust: Thx for helping out. Could break down the issue to be related that the adf filter query goes always against the solr index.

2019-09-06 10:29:24 GMT <alfresco-discord> <dgradecak> @angelborroy do you know what ATS-532 is about?

2019-09-06 10:29:34 GMT <alfresco-discord> <dgradecak> I see a revert to java 8 support https://github.com/Alfresco/alfresco-transform-core/pull/91

2019-09-06 10:29:35 GMT <alfbot> Title:ATS-532 : Restore Java language level to 1.8 by CezarLeahu 路 Pull Request #91 路 Alfresco/alfresco-transform-core 路 GitHub (at github.com)

2019-09-06 10:29:57 GMT <alfresco-discord> <dgradecak> and wondering why

2019-09-06 10:30:26 GMT <angelborroy> Probably it鈥檚 because we are compiling with Java 11 with compatibility for Java 8

2019-09-06 10:30:40 GMT <angelborroy> That method was breaking that rule

2019-09-06 10:32:03 GMT <alfresco-discord> <dgradecak> so that is still a reality

2019-09-06 10:32:09 GMT <angelborroy> yep

2019-09-06 12:29:53 GMT <alfresco-discord> <mbui> Is the Alfresco Digital Workplace supposed to be the Alfresco Share replacement? Also is it Enterprise only? What does ADW differ from the content app? (https://github.com/Alfresco/alfresco-content-app)

2019-09-06 12:29:54 GMT <alfbot> Title:GitHub - Alfresco/alfresco-content-app: Alfresco Content Application (at github.com)

2019-09-06 12:34:30 GMT <alfresco-discord> <yreg> 1- That's possibly the intent, but it still has a very long way to go in order for it to get there

2019-09-06 12:34:51 GMT <alfresco-discord> <yreg> 2- Yes, only available in support portal

2019-09-06 12:35:24 GMT <alfresco-discord> <yreg> 3- it's basically ACA + extensions & niceties on top of it

2019-09-06 12:36:07 GMT <alfresco-discord> <yreg> and last time I checked there wasn't much added on top of ACA, but that was long time ago

2019-09-06 12:36:12 GMT <alfresco-discord> <mbui> Cheers @yreg

2019-09-06 12:48:30 GMT *** jelly-home is now known as jelly

2019-09-06 13:18:56 GMT <alfresco-discord> <Mark> Hi, I'm getting the exact AlfrescoContentKeyStoreImpl related stacktrace that's also listed here: https://gist.github.com/jancalve/cec73487f215bec71d81ea9a93a27f82 anyone know what keystores I'm supposed to check out? It looks like the keystores are in the contentstore itself, but the provided nodeRef directs to the repository root.

2019-09-06 13:18:57 GMT <alfbot> Title:catalina.out 路 GitHub (at gist.github.com)

2019-09-06 14:04:04 GMT <alfresco-discord> <dgradecak> @Mark seems he was using "alfresco mvc" (since I commented on it) and as far as I remember his issue was due to some extra modules (maybe RM) which does not handled spring context events correctly

2019-09-06 14:04:13 GMT <alfresco-discord> <dgradecak> not sure if that is what you have

2019-09-06 14:04:47 GMT <AFaust> Ehmm... OOTBee Support Tools on Alfresco Enterprise fails in SOLR Status page with an error claiming that the native JS JSON type does not exist?

2019-09-06 14:05:01 GMT <AFaust> 6.1 Enterprise to be exact

2019-09-06 14:05:19 GMT <AFaust> Does anyone here have Enterprise 6.1 running and can maybe confirm that?

2019-09-06 14:05:21 GMT <alfresco-discord> <dgradecak> hm maybe it was due to multitenancy also ...

2019-09-06 14:05:43 GMT <AFaust> Failed to execute script 'classpath*:alfresco/templates/webscripts/org/orderofthebee/support-tools/admin/ootbee-support-tools/solr-tracking.get.js': 08062210 ReferenceError: "JSON" is not defined

2019-09-06 14:06:06 GMT <AFaust> What does JSON JS type have to do with MT?

2019-09-06 14:06:19 GMT <AFaust> It's not like Alfresco themselves aren't using JSON too...

2019-09-06 14:06:43 GMT <AFaust> Albeit I can only find usages on Share tier, not in Share Services Repository-tier

2019-09-06 14:07:40 GMT <alfresco-discord> <dgradecak> was for mark not you AFaust

2019-09-06 14:07:42 GMT <AFaust> And I even get a JS compile error on a default Share Service web script which runs perfectly fine in Community.

2019-09-06 14:08:29 GMT <AFaust> Yeah, I did not check the timestamps to see that your previous messages was just seconds before I started writing

2019-09-06 14:09:15 GMT <AFaust> I am wondering if Alfresco Enterprise 6.1 is stable, or whether I accidentally picked a pre-release state in Nexus "again"...

2019-09-06 14:11:46 GMT <angelborroy> It works with CE 6.1.2 for sure

2019-09-06 14:12:02 GMT <angelborroy> What Enterprise version are you using?

2019-09-06 14:14:17 GMT <alfresco-discord> <MorganP> Can this maybe be linked to the default cores VS Sharded cores?

2019-09-06 14:18:12 GMT <alfresco-discord> <Alexander Seitz> @AFaust: ADF currently does not support TMDQ and they don't have it on their roadmap. As recommendet by DenysVuika, I've raised an feature request for it: https://github.com/Alfresco/alfresco-ng2-components/issues/5062

2019-09-06 14:18:14 GMT <alfbot> Title:Feature Request for Transactional Metadata Queries (TMDQ) in ADF 路 Issue #5062 路 Alfresco/alfresco-ng2-components 路 GitHub (at github.com)

2019-09-06 14:20:07 GMT <AFaust> Muhahaha...

2019-09-06 14:20:21 GMT <AFaust> That team continues to amaze me by their ignorance of core features...

2019-09-06 14:21:26 GMT <alfresco-discord> <MorganP> What is the action= that is being executed on the Solr by this JS?

2019-09-06 14:27:45 GMT <angelborroy> AFaust do you mean 鈥淪OLR tracking status鈥 option?

2019-09-06 14:27:54 GMT <angelborroy> It鈥檚 working for me using ACS

2019-09-06 14:31:51 GMT <AFaust> hmm... strange

2019-09-06 14:32:31 GMT <angelborroy> I鈥檓 using FROM alfresco/alfresco-content-repository:

2019-09-06 14:32:57 GMT <angelborroy> and support-tools-repo-

2019-09-06 14:33:31 GMT <AFaust> Not using any Docker in this case. Building WAR from content-services base artifact

2019-09-06 14:34:24 GMT <AFaust> running in a manual, Windows Tomcat deployment

2019-09-06 14:34:34 GMT <angelborroy> You are so brave鈥 :-P

2019-09-06 14:35:06 GMT <AFaust> well, customer has Windows and Docker on Windows for production is not an option

2019-09-06 14:35:39 GMT <AFaust> also, I would be just as brave if I actually "trusted" the Alfresco Docker images

2019-09-06 14:37:39 GMT <AFaust> at least all the upgrade steps from 3.4 to 6,1 succeeded. Only thing to figure out now are these strange errors...

2019-09-06 14:38:00 GMT <angelborroy> Congrats for that!

2019-09-06 14:38:11 GMT <angelborroy> There is a hard work behind

2019-09-06 14:38:32 GMT <angelborroy> Let me know if I can do any other thing to help

2019-09-06 14:38:43 GMT <angelborroy> No option to deploy alfresco.war in Windows

2019-09-06 14:39:18 GMT <AFaust> only issue I found is that you cannot run the TMQ index patch in the 4.0 -> 4.2 step when using MS SQL... at least not during first startup.

2019-09-06 14:40:20 GMT <AFaust> Alfresco messed up the SQL order and a patch which restructures columns / index to fit in MS SQL index limits runs "after" the TMQ patch that fails because of those limits

2019-09-06 14:40:57 GMT <hi-ko_> hopefully MS SQL is history in near future for alfresco

2019-09-06 14:43:29 GMT <AFaust> amen

2019-09-06 14:43:50 GMT <hi-ko_> we had the same issue for other instances running mssql

2019-09-06 14:51:09 GMT <alfresco-discord> <Thijs> Axel: colleague Koen fixed some MS SQL metadata query issues at a client recently

2019-09-06 14:51:22 GMT <hi-ko_> now all our customrs run on linux. Next challenge is to migrate all the mysqls to postgres but alf-repo db migrations are very ugly if serialized content is stored. Best would be to to make the migration from alfresco using both databases at the same time ;-)

2019-09-06 15:02:36 GMT <AFaust> Thijs: Thanks, but the MS SQL thingy was easy to deal with. Just run without TMQ patch, then execute the commands manually

2019-09-06 15:07:38 GMT <hi-ko_> AFaust: And you didn't have the problem to hit the max index block size in mssql?

2019-09-06 15:08:20 GMT <AFaust> No, not after having run the 4.0 -> 4.2 step without TMQ patch...

2019-09-06 15:08:48 GMT <hi-ko_> we had to alter the index definition in the db ...

2019-09-06 15:09:31 GMT <hi-ko_> due to ms limitations on max index fieldsize

2019-09-06 15:20:10 GMT <AFaust> Maybe in one of the later service packs / hotfixes they added that SQL patch that fixed the index length in my case.

2019-09-06 15:26:11 GMT <alfresco-discord> <Mark> ADF Doesn't support TMDQ? Wow.

2019-09-06 20:36:41 GMT <alfresco-discord> <aaaaaabbbbbb> Hi, someone has modified the authentication of Alfresco Share, which is through a username and password, to authenticate through a REST service?

2019-09-06 20:58:46 GMT <alfresco-discord> <alejandro.23dd> Hi, someone has modified the authentication of Alfresco Share, which is through a username and password, to authenticate through a REST service?

End of Daily Log

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