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-09-29 06:47:50 GMT <bhuvana> hi all

2017-09-29 06:48:17 GMT <bhuvana> can we integrate any mssql version with alfresco community version 5.2e

2017-09-29 06:51:41 GMT <mtsiak> hi all. i am creating an amp with alfresco sdk archetype. This amp is depended to another of ours amp.

2017-09-29 06:52:16 GMT <mtsiak> how do i specify this to the pom.

2017-09-29 06:52:51 GMT <mtsiak> 1. i am includin <dependencies><dependency> .. <type>amp</type></dependency>

2017-09-29 06:53:33 GMT <mtsiak> and 2. build><plugins><plugin><artifactId>maven-war-plugin</artifactId><configuration><overlays><overlay> .. <type>amp</type></overlay>

2017-09-29 06:53:52 GMT <mtsiak> but doesnot seem to work

2017-09-29 06:55:51 GMT <mtsiak> a bean of the firsh amp depends on the bean of the second amp, and i get the NoSuchBeanDefinitionException

2017-09-29 07:02:24 GMT <Tichodroma> mtsiak: do you want to use the other bean during a unit test?

2017-09-29 07:03:54 GMT <mtsiak> no, it it another bootstap contect bean

2017-09-29 07:04:22 GMT <mtsiak> the types, aspects on the dependancy bean are needed in the amp i am creating.

2017-09-29 07:04:23 GMT <Tichodroma> why don't you just use apply-amps.sh to apply both AMPs onto the alfresco.war?

2017-09-29 07:04:52 GMT <Tichodroma> I don't understand at what stage of development and/or deployment you want to do exactly what.

2017-09-29 07:05:53 GMT <mtsiak> i have 2 eclipse sdk projects (want to create a share amp and a repo amp)

2017-09-29 07:07:17 GMT <mtsiak> the amp is depented to the amp which contains some custom model, workflows..

2017-09-29 07:08:23 GMT <mtsiak> e.g. if you create an amp i am always adding the javascript-console-repo (and share), in case i need it. and it works.

2017-09-29 07:08:32 GMT <Tichodroma> adding how?

2017-09-29 07:12:04 GMT <mtsiak> http://www.heypasteit.com/clip/0IIUAW

2017-09-29 07:12:05 GMT <alfbot> Title: Clip #0IIUAW (at www.heypasteit.com)

2017-09-29 07:13:40 GMT <Tichodroma> You use the maven-war-plugin to overlay a JAR, not an AMP

2017-09-29 07:14:02 GMT <mtsiak> but it is jar of type..

2017-09-29 07:14:48 GMT <DarkStar1> Morning everyone

2017-09-29 07:20:28 GMT <yreg> Morning

2017-09-29 07:22:29 GMT <bhuvana> hi all

2017-09-29 07:44:32 GMT <mtsiak> Tichodroma: what should i use?

2017-09-29 07:46:50 GMT <Tichodroma> I'd not use the overlay mechanism but instead put all AMPs into the amps/ and amps_share/ directories of your vanilla Alfresco installation. Apply them using bin/apply-amps.sh. Run Alfresco

2017-09-29 07:49:15 GMT <mtsiak> ok. will do that, to go on

2017-09-29 08:47:26 GMT <hiten> Hi Angelborroy

2017-09-29 08:47:35 GMT <angelborroy> hi

2017-09-29 08:47:51 GMT <hiten> I am looking at your ocr project

2017-09-29 08:48:00 GMT <hiten> https://angelborroy.wordpress.com/2017/01/19/alfresco-installing-ocr-as-an-external-service/

2017-09-29 08:48:01 GMT <alfbot> Title: Alfresco, installing OCR as an external service | Programming and So (at angelborroy.wordpress.com)

2017-09-29 08:48:33 GMT <angelborroy> yep

2017-09-29 08:49:41 GMT <hiten> I am able to implement it but I also wanted to add some kind queuing mechanism where there will be 3-4 ocr servers and the request will go to either of the servers

2017-09-29 08:50:15 GMT <hiten> any idea on how can I start on this

2017-09-29 08:50:31 GMT <angelborroy> let me see

2017-09-29 08:51:37 GMT <angelborroy> ok, we have a pool in Alfresco if the OCR action is async

2017-09-29 08:52:01 GMT <angelborroy> so several OCR request shall be triggered at the same time from Alfresco repo

2017-09-29 08:52:24 GMT <angelborroy> probably it should be advisable to use a dedicated pool

2017-09-29 08:52:33 GMT <angelborroy> instead of async actions Alfresco thread pool

2017-09-29 08:54:34 GMT <angelborroy> hiten then you can create a thread from a shell script with a round robin approach or so

2017-09-29 08:54:40 GMT <angelborroy> hiten does this make sense for you?

2017-09-29 08:56:35 GMT <rusin> hi all

2017-09-29 08:57:46 GMT <rusin> is alfresco community 5.2e version supports MSSql Server 2012

2017-09-29 08:59:14 GMT <angelborroy> rusin: no

2017-09-29 08:59:35 GMT <angelborroy> only Alfresco Enterprise has support for SQL Server, Oracle, DB2 and os

2017-09-29 08:59:56 GMT <angelborroy> Community only works with Posgresql, MariaDB and MySQL

2017-09-29 09:00:16 GMT <rusin> hi angelborroy

2017-09-29 09:00:26 GMT <rusin> thanks for your comments

2017-09-29 09:00:28 GMT <hiten> so the logic would be in shell script that will shoot the request to diff servers

2017-09-29 09:00:30 GMT <hiten> ??

2017-09-29 09:00:39 GMT <angelborroy> hiten probably is the easiest

2017-09-29 09:00:44 GMT <rusin> is there any possibilities

2017-09-29 09:00:59 GMT <hiten> I am not so clear about the pool part :(

2017-09-29 09:02:02 GMT <angelborroy> rusin Community does not work with SQL Server, IMO no alternatives

2017-09-29 09:02:16 GMT <angelborroy> rusin just use an open source database

2017-09-29 09:02:49 GMT <rusin> apart from pool capabilities shall we integrate with mssql

2017-09-29 09:02:52 GMT <rusin> ok

2017-09-29 09:02:57 GMT <angelborroy> hiten obviously you can also dev your thread dispatcher in Java

2017-09-29 09:03:19 GMT <angelborroy> rusin sorry I can’t understand you

2017-09-29 09:04:14 GMT <rusin> sorry angelborroy

2017-09-29 09:04:22 GMT <rusin> that query for hiten

2017-09-29 09:56:44 GMT <hiten> Hey AngelBorroy

2017-09-29 09:56:52 GMT <angelborroy> hiten hey

2017-09-29 10:15:16 GMT <hiten> I did some searching about what you explained

2017-09-29 10:15:59 GMT <hiten> trying to get some idea

2017-09-29 10:17:42 GMT <hiten> We are creating a dedicated pool in the first place to make sure that the alfresco threads are not totally consumed by OCR and system still works

2017-09-29 10:17:44 GMT <hiten> ??

2017-09-29 10:30:14 GMT <angelborroy> hiten

2017-09-29 10:30:19 GMT <angelborroy> yes, this is the idea

2017-09-29 10:35:39 GMT <rusin> is it possible to create custom roles like only upload and delete in alfresco community

2017-09-29 10:48:55 GMT <angelborroy> rusin it is possible

2017-09-29 10:49:00 GMT <angelborroy> rusin but it is not easy http://smasue.github.io/add-custom-role

2017-09-29 10:49:01 GMT <alfbot> Title: Add custom roles in Alfresco (at smasue.github.io)

2017-09-29 10:51:35 GMT <rusin> ok thanks angelborroy

2017-09-29 10:52:08 GMT <rusin> i tried that but unable to login the alfresco

2017-09-29 10:52:47 GMT <angelborroy> rusin you can also try simplifying Share actions for predetermined groups

2017-09-29 10:53:21 GMT <angelborroy> rusin I’m using this template for that https://github.com/keensoft/alfresco-simplify-share

2017-09-29 10:53:22 GMT <alfbot> Title: GitHub - keensoft/alfresco-simplify-share: Share customisation to hide elements from Document Library (at github.com)

2017-09-29 10:54:34 GMT <fwu> hi all

2017-09-29 10:54:58 GMT <rusin> angelborroy i will try and get back

2017-09-29 10:55:48 GMT <fwu> ppl, any idea about this error:

2017-09-29 10:55:59 GMT <fwu> ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8081-exec-1] Exception from executeScript: 08280019 Wrapped Exception (with status template): 08280058 Invalid Global Id 'activitiInvitationNominatedAddDirect' org.springframework.extensions.webscripts.WebScriptException: 08280019 Wrapped Exception (with status template): 08280058 Invalid Global Id 'activitiInvitationNominatedAddDirect'

2017-09-29 10:56:08 GMT <fwu> im not using that workflow

2017-09-29 10:56:32 GMT <fwu> and I get it when using the workflows I have started

2017-09-29 10:59:05 GMT <hiten> fwu: I think I have seen the above error

2017-09-29 10:59:31 GMT <hiten> this came during the upgrade from 5.0 to 5.1

2017-09-29 11:00:32 GMT <hiten> I had to manually deploy the activitiInvitationNominatedAddDirect bpmn

2017-09-29 11:00:46 GMT <hiten> through the activity console

2017-09-29 11:00:56 GMT <hiten> sorry workflow console

2017-09-29 11:03:16 GMT <fwu> hiten, yes I beleive this is from 5.2 I didnt change nothing

2017-09-29 11:03:27 GMT <fwu> so it seems it comes with some problem

2017-09-29 11:04:45 GMT <fwu> so, this error means the workflow is not deployed? But what is using it? Why it is being read in the workflows I have started? Actually even if I dont have started any workflow, I get this error!

2017-09-29 11:05:14 GMT <fwu> nevertheless it must be a deploy problem. Maybe this workflow is referenced in some table and not in others

2017-09-29 11:05:26 GMT <fwu> how did you deployed it?

2017-09-29 11:06:39 GMT <fwu> I could remove any entrance in the database for that workflow, but it may have some risks

2017-09-29 11:11:11 GMT <hiten> go to the url http://localhost:8080/alfresco/s/admin/admin-workflowconsole

2017-09-29 11:11:36 GMT <hiten> in the text field type the following command

2017-09-29 11:15:42 GMT <hiten> deploy activiti <path/to/activitiInvitationNominatedAddDirect.bpmn>

2017-09-29 11:16:01 GMT <hiten> you can get the latest bpmn from the alfresco github

2017-09-29 11:16:15 GMT <hiten> put it in your server or local

2017-09-29 11:16:46 GMT <hiten> I keep mine under $alfresco_dir/tomcat/shared/classes/alfresco/extension/workflows

2017-09-29 11:42:18 GMT <fwu> hiten, after deploying it, cant I just delte the bpmn?

2017-09-29 11:42:52 GMT <fwu> I thought I would need to deploy it just to make some entries in some tables, but then I could forget that bpmn

2017-09-29 11:43:50 GMT <fwu> or maybe to deploy it once in the workflows folder in the data dcitionary stuff

2017-09-29 12:17:02 GMT <fwu> ppl what is the smallest numeric data types in Alfresco?

2017-09-29 14:58:09 GMT *** marsv024_ is now known as marsv024

2017-09-29 15:10:44 GMT <Tichodroma> Does the fts-alfresco search language support range queries for date properties?

2017-09-29 15:13:38 GMT <xkahn> Tichodroma: yes

2017-09-29 15:14:00 GMT <xkahn> field:[n TO m] or field:n..m -- find field values n to m, inclusive

2017-09-29 15:14:00 GMT <xkahn> field:<n TO m] -- find field values above n up to and including m

2017-09-29 15:14:00 GMT <xkahn> field:[n TO m> -- find field values from n to less than m

2017-09-29 15:14:00 GMT <xkahn> field:<n TO m> -- find field values more than n to less than m

2017-09-29 15:14:16 GMT <Tichodroma> just like this: modelprefix:propertyname:[MIN TO NOW] ?

2017-09-29 15:14:22 GMT <Tichodroma> for example

2017-09-29 15:14:22 GMT <xkahn> cm:from:["2016-01-01" TO NOW]

2017-09-29 15:14:29 GMT <Tichodroma> let me try

2017-09-29 15:14:39 GMT <xkahn> NOW: Exactly now

2017-09-29 15:14:39 GMT <xkahn> NOW/HOUR: Round to the beginning of the hour

2017-09-29 15:14:39 GMT <xkahn> NOW/DAY+1DAY: The end of today -- round to the beginning of the day and add 24 hours

2017-09-29 15:14:39 GMT <xkahn> NOW/DAY+1YEAR: Next year

2017-09-29 15:14:39 GMT <xkahn> NOW-2HOUR: Exactly two hours ago

2017-09-29 15:14:39 GMT <xkahn> NOW/DAY-6MONTHS: 6 months ago

2017-09-29 15:16:09 GMT <Tichodroma> BTW, Solr is disabled, the query can only search the DB

2017-09-29 15:16:32 GMT <Tichodroma> are date range searches possbile in this case, too?

2017-09-29 15:17:07 GMT <xkahn> no

2017-09-29 15:17:12 GMT <Tichodroma> :(

2017-09-29 15:18:32 GMT <Tichodroma> what syntax is avaible for date ranges using db-afts?

2017-09-29 15:19:44 GMT <Tichodroma> or date comparison?

2017-09-29 15:19:49 GMT <xkahn> Well, maybe. I'd have to look at the parser. It says: DATETIME: Supports all properties and comparisons =, <>, <, <=, >=, >, IN, NOT IN

2017-09-29 15:23:00 GMT <Tichodroma> that looks like SQL operators. How to formulate a datetime query in db-afts? =prefix:propname:"2017-09-29" does not work for a cm:date property

2017-09-29 15:23:18 GMT <Tichodroma> which class implements the parser?

2017-09-29 15:24:41 GMT <xkahn> Tichodroma: That page mostly talks about the queries supported by CMIS

2017-09-29 15:25:02 GMT <xkahn> Tichodroma: but it is talking about the OPERATIONS that the db-afts supports.

2017-09-29 15:25:23 GMT <xkahn> err.. the DB query engine supports.

2017-09-29 15:25:24 GMT <xkahn> sorr

2017-09-29 15:25:25 GMT <xkahn> sorry

2017-09-29 15:26:34 GMT <xkahn> This is the db-afts parser: https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/source/java/org/alfresco/repo/search/impl/querymodel/impl/db/functions/DBFTSTerm.java

2017-09-29 15:26:51 GMT <xkahn> look for the error message "Analysis mode not supported"

2017-09-29 15:28:53 GMT <xkahn> Looks like it supports: FIELD_EXACTASPECT, FIELD_EXACTTYPE, FIELD_ASPECT, FIELD_TYPE, FIELD_PARENT, and IDENTIFIER

2017-09-29 15:29:31 GMT <xkahn> Typically, when we use db-afts, we use something like =rh:id:"theid"

2017-09-29 15:33:04 GMT <xkahn> Awww... Tichodroma left.

2017-09-29 15:33:13 GMT <yreg> xkahn, no it does not

2017-09-29 15:33:22 GMT <xkahn> And just when I had the real soul crushing answer: https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/source/java/org/alfresco/repo/search/impl/querymodel/impl/db/functions/DBFTSRange.java

2017-09-29 15:33:29 GMT <xkahn> throw new QueryModelException("Range term is unsupported");

2017-09-29 15:33:33 GMT <xkahn> yreg: :)

2017-09-29 15:33:42 GMT <yreg> only CMIS language does support ranges

2017-09-29 15:33:57 GMT <yreg> but I have implemented the support for range queries in FTS as well

2017-09-29 15:34:09 GMT <yreg> a while back and it wasn't that hard actually

2017-09-29 15:34:18 GMT <xkahn> yreg: Yeah. It looks totally possible

2017-09-29 15:34:50 GMT <xkahn> yreg: it would help me actually... We use db-fts to search for content that hasn't been indexed yet

2017-09-29 15:35:13 GMT <xkahn> so a date range would help us locate those files quickly when needed

2017-09-29 15:35:38 GMT <yreg> it took me two full days to actually get it working perfectly and performance was not bad at all as long as you do paginate

2017-09-29 15:37:39 GMT <yreg> (just like any other TMQ)

2017-09-29 15:38:02 GMT <xkahn> makes sense

End of Daily Log

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