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-07-25 04:55:13 GMT <ashley_> Hi, i am using alfresco 5.2.e and pentaho 7. I have done installation and configuration pentaho App Builder, when click the Customize "Customizations are possibile only after A.A.A.R. installation" is showing. Can please help on this issue.

2017-07-25 08:03:59 GMT <angelborroy> morning bmejias!

2017-07-25 08:04:13 GMT <angelborroy> a PostgreSQL question for you bmejias

2017-07-25 08:04:52 GMT <angelborroy> I have an alfresco_node_properties table with 243 M records and 200 GB of physical storage

2017-07-25 08:04:59 GMT <angelborroy> it looks too much for a single table…

2017-07-25 08:05:09 GMT <angelborroy> … any similar experience on your part?

2017-07-25 08:05:27 GMT <bmejias> hi angelborroy

2017-07-25 08:06:26 GMT <bmejias> I don't remember something like that.... the only thing I can think of is very large indexes.

2017-07-25 08:06:38 GMT <angelborroy> 100 GB indexes and 100 GB data

2017-07-25 08:06:40 GMT <bmejias> but from 243M to 200GB, is kind of way too much

2017-07-25 08:06:42 GMT <angelborroy> is more or less 50%

2017-07-25 08:06:54 GMT <angelborroy> so it’s not a regular scenario

2017-07-25 08:07:00 GMT <angelborroy> ok, just to be sure

2017-07-25 08:07:03 GMT <angelborroy> thanks a ton!

2017-07-25 08:07:09 GMT <bmejias> ah OK, 100GB of data.... so it's not the alf_node_properties table that is causing trouble.

2017-07-25 08:07:21 GMT <bmejias> what about statistics?

2017-07-25 08:07:30 GMT <angelborroy> for the table: 100 GB data and 100 GB indexes

2017-07-25 08:07:37 GMT <DarkStar1> Morning everyone. I had forgotten that my chat client was switched on.

2017-07-25 08:07:37 GMT <angelborroy> only for alf_node_properties

2017-07-25 08:07:38 GMT <bmejias> I remember having a problem with the alf_stat* tables that were really huge

2017-07-25 08:07:45 GMT <angelborroy> 500 GB storage for all the database

2017-07-25 08:08:16 GMT <bmejias> ah ok, I read incorrectly, 243M records... not MB of storage.

2017-07-25 08:08:25 GMT <angelborroy> yep

2017-07-25 08:08:27 GMT <bmejias> those records made it for the 100GB of data

2017-07-25 08:08:31 GMT <angelborroy> right

2017-07-25 08:08:37 GMT <angelborroy> and 100 GB of indexes

2017-07-25 08:08:42 GMT <bmejias> well, the database is just that large apparently.

2017-07-25 08:09:14 GMT <bmejias> If you do a dump, the dump file is much smaller... but it means it takes time to recover. How are taking backups?

2017-07-25 08:09:20 GMT <bmejias> physical backups?

2017-07-25 08:09:31 GMT <bmejias> or pg_dump?

2017-07-25 08:09:32 GMT <angelborroy> they are using VMWare snapshots

2017-07-25 08:09:40 GMT <angelborroy> so no pg_dump is performed

2017-07-25 08:10:59 GMT <angelborroy> I’ll make a more detailed study this week

2017-07-25 08:11:51 GMT <angelborroy> as they are claiming about my way of installing the product

2017-07-25 08:12:00 GMT <angelborroy> (which I think is not the main problem, I guess)

2017-07-25 08:12:13 GMT <bmejias> VMWare snapshot.... mmmm... interesting.... I wonder how much consistency is guaranteed with that.

2017-07-25 08:12:58 GMT <bmejias> if they are having problems with performance, with such database maybe they need more RAM

2017-07-25 08:13:25 GMT <bmejias> 100GB of indexes, it will probably have to go every time to read from disk

2017-07-25 08:13:52 GMT <angelborroy> there is no problem with performance

2017-07-25 08:14:03 GMT <angelborroy> there is only a problem with storage

2017-07-25 08:14:07 GMT <bmejias> one test for disaster recovery would be to take one of those VMWare snapshots, start it, and check the logs of Postgresql to see if they remain consistent.

2017-07-25 08:14:11 GMT <angelborroy> they think that it is too much

2017-07-25 08:14:24 GMT <bmejias> how many records in alf_node?

2017-07-25 08:14:26 GMT <angelborroy> they had made disaster recovery tests and it works fine

2017-07-25 08:14:42 GMT <bmejias> ah OK, it looks good then

2017-07-25 08:14:48 GMT <angelborroy> I don’t know, I have only partial information

2017-07-25 08:14:55 GMT <angelborroy> They have a rich content model, for sure

2017-07-25 08:15:02 GMT <angelborroy> about 100 fields per document

2017-07-25 08:15:16 GMT <angelborroy> but 50 Kb of metadata per document looks too high

2017-07-25 08:33:22 GMT <AFaust> Anyone here using the Enterprise Repository Admin Console in IE 9/10/11 on Windows 7, who also gets (or previously got) a CVE 2017-0059 virus/malware warning?

2017-07-25 08:34:11 GMT <AFaust> It's quite annoying on this customer system using their client + active virus protection software....

2017-07-25 08:34:45 GMT <AFaust> I also find the lack of details on this CVE disturbing. I have not found anything that allows me to understand what specifically triggers the warning

2017-07-25 08:54:39 GMT <bmejias> angelborroy 50kb of metadata sounds indeed large.

2017-07-25 08:55:45 GMT <angelborroy> yep, I’ll try to dig in that ratio

2017-07-25 08:55:55 GMT <angelborroy> probably a simple VACUUM will help

2017-07-25 08:56:10 GMT <angelborroy> they told me, no period VACUUM is performed

2017-07-25 08:57:24 GMT <mtsiak> hi all.

2017-07-25 08:58:30 GMT <mtsiak> some of our webscripts throw access denied exception in our upgraded 5.2 alfresco.

2017-07-25 08:58:39 GMT <mtsiak> any ideas ?

2017-07-25 08:58:49 GMT <angelborroy> hi

2017-07-25 08:58:54 GMT <angelborroy> custom webscripts?

2017-07-25 08:59:11 GMT <mtsiak> http://www.heypasteit.com/clip/0IIPGT

2017-07-25 08:59:12 GMT <alfbot> Title: Clip #0IIPGT (at www.heypasteit.com)

2017-07-25 08:59:17 GMT <mtsiak> yes.

2017-07-25 08:59:44 GMT <mtsiak> e.g. esing cert works does not. :)

2017-07-25 08:59:44 GMT <angelborroy> which kind of authentication is configured?

2017-07-25 09:00:08 GMT <angelborroy> esign cert is working fine for us with 201702

2017-07-25 09:00:36 GMT <angelborroy> probably is not related with webscript but with repo behaviour / action, right?

2017-07-25 09:01:13 GMT <mtsiak> (yes esing cert works )

2017-07-25 09:01:18 GMT <angelborroy> ah, ok

2017-07-25 09:01:37 GMT <angelborroy> try to detail stack trace

2017-07-25 09:01:48 GMT <angelborroy> usually the problem is not related with webscript definition

2017-07-25 09:01:55 GMT <mtsiak> the authentication is not dedined in some

2017-07-25 09:02:43 GMT <angelborroy> https://github.com/keensoft/alfresco-esign-cert/blob/master/esign-cert-repo/src/main/amp/config/alfresco/extension/templates/webscripts/es/keensoft/sign/webscripts/save-sign.post.desc.xml

2017-07-25 09:02:44 GMT <alfbot> Title: alfresco-esign-cert/save-sign.post.desc.xml at master · keensoft/alfresco-esign-cert · GitHub (at github.com)

2017-07-25 09:02:51 GMT <mtsiak> and those with problem, define the <extentention><modules><module> ... <components>... file where we define the widget location.

2017-07-25 09:04:08 GMT <angelborroy> but this is the Share part, right?

2017-07-25 09:04:30 GMT <bmejias> angelborroy ah yes.... vacuum.... that's very important

2017-07-25 09:04:35 GMT <angelborroy> it looks like the problem is on the repo part

2017-07-25 09:05:51 GMT <mtsiak> <authentication> is required?

2017-07-25 09:06:12 GMT <angelborroy> it looks like for 5.2 it is

2017-07-25 09:06:20 GMT <angelborroy> probably default value has changed

2017-07-25 09:06:35 GMT <mtsiak> ok. will change that as in your repo and come back

2017-07-25 09:34:03 GMT <Tichodroma> is it possible to execute a db-atfs search in JavaScript? (Alfresco 5.x)

2017-07-25 09:36:01 GMT <Tichodroma> search.query({language:"db-atfs", query: "=@foo:bar:\"baz\""}) does not work: org.alfresco.repo.search.SearcherException: Unknown query language: db-atfs

2017-07-25 09:37:45 GMT <Tichodroma> or is fts-alfresco equivalent? Background: I need a way to search for an exact property value without having for Solr to index a property.

2017-07-25 09:40:20 GMT <Tichodroma> OK, fts-alfresco can be used for what I have in mind.

2017-07-25 09:46:52 GMT *** angelborroy_ is now known as angelborroy

2017-07-25 09:57:59 GMT <fwu> hi all!

2017-07-25 10:00:27 GMT <AFaust> Tichodroma: fts-alfresco will use db-afts if the query is compatible - db-afts as a query language is just the shortcut to avoid fallback to index

2017-07-25 10:01:09 GMT <AFaust> But if the admin configured the repository with the default consistency set to EVENTUAL, db-afts is the only way to force a DB query

2017-07-25 10:01:20 GMT <AFaust> since fts-alfresco will never do DB queries in that case

2017-07-25 10:02:37 GMT <Tichodroma> AFaust: what's the default value for this consistency configuration?

2017-07-25 10:03:07 GMT <AFaust> TRANSACTIONAL_IF_POSSIBLE

2017-07-25 10:03:19 GMT <AFaust> Which means "DB first, fallback to index"

2017-07-25 10:03:24 GMT <Tichodroma> sounds OK

2017-07-25 10:03:38 GMT <Tichodroma> forcing db-atfs from JS is not possible, right?

2017-07-25 10:03:56 GMT <AFaust> Only by specifying db-afts as the query language

2017-07-25 10:04:05 GMT <Tichodroma> hm, that throws an error for me

2017-07-25 10:04:12 GMT <AFaust> I have created a JIRA to add the parameter for consistency to script API

2017-07-25 10:04:16 GMT <Tichodroma> :)

2017-07-25 10:04:30 GMT <AFaust> https://issues.alfresco.com/jira/browse/ALF-21824

2017-07-25 10:04:31 GMT <Tichodroma> let's hope it will not be closed some day because of inactivity

2017-07-25 10:04:44 GMT <AFaust> I'm not betting anything...

2017-07-25 10:05:29 GMT <Tichodroma> but the configuration option together with a DB friendly query should be enough for me

2017-07-25 10:09:29 GMT <AFaust> I just wish people would stop using the @ notation. It is absolutely unnecessary

2017-07-25 10:10:39 GMT <AFaust> '=foo:bar:"baz"' is just fine (note: single-quote-strings are almost always superior double-quote-strings in JavaScript)

2017-07-25 10:10:48 GMT <Tichodroma> true

2017-07-25 10:12:02 GMT <AFaust> Ahh - I just now realized the typo in your JavaScript statement before: you specified "db-atfs" instead of "db-afts"

2017-07-25 10:13:30 GMT <Tichodroma> WTF?!

2017-07-25 10:13:38 GMT <Tichodroma> thanks, those are hard to spot

2017-07-25 10:14:10 GMT <Tichodroma> maye I thought afts is somehow similar to NTFS :)

2017-07-25 11:15:10 GMT <bhuvana_> hi all

2017-07-25 11:15:30 GMT <bhuvana_> I am working on aaar reports with alfresco 5.2

2017-07-25 11:15:54 GMT <bhuvana_> but i am unable to integrate with aaar4.4 and 4.5

2017-07-25 11:16:20 GMT <bhuvana_> i am unable to install aaar plugin in biserver

2017-07-25 11:16:59 GMT <bhuvana_> can any one help me for any reference link

2017-07-25 11:20:48 GMT <fwu> back

2017-07-25 11:22:15 GMT <fwu> ppl, does the javascript console works on Alfresco 5.2? It seems not as I deployed the javascript-console-repo-0.6.0.jar and share jar at it doesnt work. Is there a new jar version?

2017-07-25 11:32:04 GMT <mrks_js> fwu: i have it running & working under 5.2.e

2017-07-25 11:33:03 GMT <mrks_js> javascript-console-repo-0.7-SNAPSHOT.jar

2017-07-25 11:33:58 GMT <digcat> i have version running against 2017-07, which is latest community

2017-07-25 11:34:21 GMT <fwu> strange

2017-07-25 11:34:34 GMT <fwu> Im not using the default ports. May be this the issue?

2017-07-25 11:35:11 GMT <fwu> I dont see the javascript console on the left menu, so if it was due to the ports, at least I was expecting to see the menu link...

2017-07-25 11:36:25 GMT <mrks_js> did you install both jars? how?

2017-07-25 11:37:35 GMT <fwu> yes

2017-07-25 11:38:09 GMT <fwu> I copied them to the lib folders

2017-07-25 11:40:17 GMT <digcat> hmm for me im using the amps, and the usual apply routine

2017-07-25 11:42:04 GMT <fwu> digcat, in version 4.2.f im using jar and it is working

2017-07-25 11:42:13 GMT <fwu> im trying to use jar in 5.2 also

2017-07-25 11:42:30 GMT <fwu> i will try to compile the 0.7 version

2017-07-25 11:42:31 GMT <digcat> yep

2017-07-25 11:43:42 GMT <mrks_js> i am not sure if adding to lib still works?

2017-07-25 12:09:01 GMT <AFaust> digcat: Please update to the official 0.6.0 release from Maven Central - you have a 0.6.0 SNAPSHOT build

2017-07-25 12:09:30 GMT <digcat> ahh thanks afaust

2017-07-25 12:09:51 GMT <AFaust> Florian deployed the 0.6 version to Maven Central in 2014 I believe

2017-07-25 12:09:54 GMT <digcat> hadnt seen an issue but yes will move to latest snapshot

2017-07-25 12:10:22 GMT <AFaust> mrks_js: 0.7-SNAPSHOT sounds like a fork since the main project has not advanced since 0.6

2017-07-25 12:10:43 GMT <AFaust> There is a minor but very important change that I often see people using an older SNAPSHOT missing...

2017-07-25 12:11:34 GMT <AFaust> The "Server Info" web script is loaded when you access the page in older versions, and since that web script is quite aggressive in terms of doing FTS / Lucene queries, it can drag down the performance of the system by clearing node caches

2017-07-25 12:11:53 GMT <mrks_js> <version>0.7-SNAPSHOT</version> => https://github.com/share-extras/js-console/blob/master/pom.xml

2017-07-25 12:11:54 GMT <alfbot> Title: js-console/pom.xml at master · share-extras/js-console · GitHub (at github.com)

2017-07-25 12:11:59 GMT <AFaust> in the 0.6 release that web scripts is no longer triggered automatically - only if a user explicitly triggers it

2017-07-25 12:12:32 GMT <AFaust> Oh - I hadn't seen that Florian actually did something this year...

2017-07-25 12:12:53 GMT <AFaust> Last I checked was around February and at that time there weren't any changes for 2 years

2017-07-25 12:13:29 GMT <mrks_js> https://github.com/share-extras/js-console/commit/980080f61a311d64558dc22af9d600de154a4f0e

2017-07-25 12:13:30 GMT <alfbot> Title: POM version updates · share-extras/js-console@980080f · GitHub (at github.com)

2017-07-25 12:13:34 GMT <mrks_js> it was you? : D

2017-07-25 12:13:50 GMT <AFaust> I know it was my PR, but I must have missed the notification

2017-07-25 12:13:50 GMT <mrks_js> seems no only my memory is foggy sometimes

2017-07-25 12:14:33 GMT <AFaust> But yes, not only your memory is foggy....

2017-07-25 12:14:46 GMT <AFaust> I have used the term "Jugendalzheimer" since I was ~14

2017-07-25 12:14:48 GMT <mrks_js> can't one see who handled the PR?

2017-07-25 12:15:00 GMT <AFaust> Florian merged it

2017-07-25 12:15:12 GMT <AFaust> You can see it in the commit history

2017-07-25 12:15:26 GMT <mrks_js> ah, wasn't it jens?

2017-07-25 12:15:30 GMT <AFaust> And Jens had merged my PR before that which included the version updates

2017-07-25 12:15:35 GMT <mrks_js> yes ok

2017-07-25 12:17:21 GMT <AFaust> Anyway, I formally rescind my previous statement that "the main project has not advanced since 0.6"

2017-07-25 12:18:21 GMT * AFaust is being reminded by this discussion that his JS Console fork for "Aikau-ification" is still slumbering without attention for months...

2017-07-25 13:21:13 GMT <fwu> AFaust, so the 0.7 is the version to pick, right?

2017-07-25 13:30:02 GMT <fwu> ppl, can someone tellme the filse size of the alfresco console jar file (share and repo),please?

2017-07-25 13:31:00 GMT <fwu> and are you deploying it using only jar files? I still dont have it working using jar files...

2017-07-25 13:36:18 GMT <AFaust> fwu: No, 0.6 is the version to use if you want to use the official, stable release

2017-07-25 13:36:24 GMT <AFaust> 0.7 is a development version at this time

2017-07-25 13:36:54 GMT <fwu> ok, AFaust. Nevertheless none works in my 5.2 installation...

2017-07-25 13:36:59 GMT <AFaust> Also, deploy it using the AMP files. JAR files only contain the Java classes, not the static resources etc.

2017-07-25 13:37:07 GMT <fwu> ah

2017-07-25 13:37:11 GMT <fwu> that may be the problem

2017-07-25 13:37:31 GMT <fwu> the share jar seems too much small

2017-07-25 13:37:36 GMT <AFaust> Simply put: "Follow the installation instructions" - https://github.com/share-extras/js-console#installation

2017-07-25 13:37:37 GMT <alfbot> Title: GitHub - share-extras/js-console: Administration Console component for Alfresco Share, that enables the execution of arbitrary JavaScript code against the repository (at github.com)

2017-07-25 13:38:40 GMT <fwu> I thought I add installed only the amps in the 4.2.f version, but it seems Im wrong

2017-07-25 13:38:51 GMT <fwu> sorry, only the jars

2017-07-25 13:39:00 GMT <fwu> but it seems I may installed the amps

2017-07-25 13:41:21 GMT <AFaust> Yes, in 4.2 and with an older version of JavaScript Console, that was possible

2017-07-25 13:41:35 GMT <AFaust> Back then, the module was still being built with the ANT SDK

2017-07-25 13:41:56 GMT <AFaust> At one point I updated it to the Maven SDK and as a result the packaging changed to AMP.

2017-07-25 13:42:01 GMT <AFaust> exclusively

2017-07-25 13:42:56 GMT <fwu> ok AFaust, thank you!

2017-07-25 13:43:18 GMT <AFaust> (I mean, I had prepared an assembly based JAR packaging step as well, but in a short JAR-vs-AMP + standard-vs-customised SDK project discussion war it was soon forgotten and unused)

2017-07-25 13:45:36 GMT <fwu> AFaust, and now we have jar deployments AND amps ...

2017-07-25 13:46:00 GMT <fwu> but I beleive jar will never solve evertything right? Like files overwrites

2017-07-25 13:48:48 GMT <AFaust> Nothing will ever solve anything right - it always is a matter of trade-offs

2017-07-25 13:49:17 GMT <AFaust> I believe JARs to be more cumbersome and problematic than AMPs...

2017-07-25 13:50:39 GMT <AFaust> Extending the runtime problem of classloader precendence-based loading to static resources that can "shadow" each other, instead of having a clean and reliable overwrite detection during AMP installation is just one of the major issues I see...

2017-07-25 13:51:34 GMT <fwu> yes, I understand

2017-07-25 13:52:51 GMT <AFaust> But there a lot of similar issues that neither JAR nor AMP excels in... e.g. detection of Spring bean overrides is similarly non-existent in both; same with Alfresco config XML overrides...

2017-07-25 14:03:16 GMT <fwu> strange... what can be the reason to this error:

2017-07-25 14:03:19 GMT <fwu> 2017-07-25 15:02:23,067 ERROR [extensibility.impl.BasicExtensibilityModuleHandler] [http-apr-8081-exec-2] The following exception occurred retrieving evaluator: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named '' is defined at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:575)

2017-07-25 14:03:29 GMT <fwu> named ''?

2017-07-25 14:50:49 GMT <Tichodroma> Am I blind or does the WebScriptRequest in an AbstractWebScript not provide access to the URL path paramaters as url.templateArgs does in JS?

2017-07-25 14:54:43 GMT <Tichodroma> OK, it is req.getServiceMatch().getTemplateVars().get("foo")

2017-07-25 14:54:50 GMT <Tichodroma> a little bit complicated :(

End of Daily Log

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