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

2018-09-24 08:09:34 GMT <yreg> Good morning !

2018-09-24 08:11:10 GMT <AFaust> Ahoi

2018-09-24 12:12:47 GMT <alfresco-discord> <bhagyas> Any asciidoc fans here?

2018-09-24 12:13:09 GMT <alfresco-discord> <bhagyas> Would be interested to know if anyones using for Alf project documentation

2018-09-24 12:34:19 GMT <alfresco-discord> <Loftux> Does the built in Alfresco Bulk Import tool keep the last modified date?

2018-09-24 12:35:16 GMT <yreg> @Loftux the add-on does

2018-09-24 12:35:40 GMT <yreg> Not sure if that was implemented before/after alfresco included it in its EE version

2018-09-24 12:36:12 GMT <angelborroy> By disabling audit service in uploading operation?

2018-09-24 12:38:47 GMT <yreg> angelborroy, here it is https://github.com/pmonks/alfresco-bulk-import/blob/785646f11cd0432b834434a0f248b79d12ddf997/amp/src/main/java/org/alfresco/extension/bulkimport/impl/BatchImporterImpl.java#L159

2018-09-24 12:38:48 GMT <alfbot> Title:alfresco-bulk-import/BatchImporterImpl.java at 785646f11cd0432b834434a0f248b79d12ddf997 · pmonks/alfresco-bulk-import · GitHub (at github.com)

2018-09-24 12:39:01 GMT <angelborroy> thanks!

2018-09-24 12:39:38 GMT <yreg> Blame says that snippet is 3 years old

2018-09-24 12:40:33 GMT <alfresco-discord> <Loftux> Should have looked at the code, it does look like it is indeed keeping the date https://github.com/loftuxab/alfresco-community-loftux/blob/loftux/projects/repository/source/java/org/alfresco/repo/bulkimport/impl/AbstractNodeImporter.java#L419

2018-09-24 12:40:34 GMT <alfbot> Title:alfresco-community-loftux/AbstractNodeImporter.java at loftux · loftuxab/alfresco-community-loftux · GitHub (at github.com)

2018-09-24 14:26:05 GMT <alfresco-discord> <kore> How will get the share host and port in java ? I tried with SysAdminParams but it's giving always localhost and 8080

2018-09-24 14:27:00 GMT <angelborroy> @kore SysAdminParams gives you the value in alfresco-global.properties

2018-09-24 14:29:03 GMT <alfresco-discord> <kore> @angel.borroy In our alfresco-global.properties file it contains host as IP address 192.168.100.183 and port 9090 but it's not giving like that

2018-09-24 14:33:50 GMT <alfresco-discord> <kore> always giving like this http://localhost:8080

2018-09-24 14:34:28 GMT <alfresco-discord> <kore> SysAdminParams syts = new SysAdminParamsImpl(); logger.debug("URL details are "+syts.getAlfrescoProtocol()+"://"+syts.getAlfrescoHost()+":"+syts.getAlfrescoPort());

2018-09-24 14:40:52 GMT <alfresco-discord> <kore> SysAdminParamsImpl k = new SysAdminParamsImpl(); logger.debug("URL details are "+sys.getAlfrescoProtocol()+"://"+sys.getAlfrescoHost()+":"+sys.getAlfrescoPort());

2018-09-24 14:41:43 GMT <alfresco-discord> <kore> giving like this http://localhost:8080 even my alfresco-global.properties file contains different

2018-09-24 14:42:48 GMT <alfresco-discord> <kore> or is there any other way to get the alfresco port and host in java ??

2018-09-24 14:49:04 GMT <AFaust> kore: Instead of constructing your own instance of SysAdminParams (which of course does not contain any of the configured values), simply inject yourself a reference to the SysAdminParams Spring bean containing the configured values from alfresco-global.properties

2018-09-24 18:16:19 GMT <alfresco-discord> <douglascrp> has anybody faced this kind of problem when trying to finish a workflow task? org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2018-10-21 00:00:00' for column 'DUEDATE_' at row 2 ### The error may involve

2018-09-24 18:16:19 GMT <alfresco-discord> org.activiti.engine.impl.persistence.entity.JobEntity.bulkInsertTimer-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO ACT_RUJOB ( ID, REV, TYPE, LOCKOWNER, LOCK_EXPTIME, EXCLUSIVE_, EXECUTIONID, PROCESS_INSTANCEID, PROC_DEFID, RETRIES_,

2018-09-24 18:16:20 GMT <alfresco-discord> EXCEPTION_STACKID, EXCEPTIONMSG, DUEDATE, REPEAT, HANDLERTYPE, HANDLERCFG, TENANTID) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?,

2018-09-24 18:16:20 GMT <alfresco-discord> 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2018-10-21 00:00:00' for column 'DUEDATE_' at row 2

2018-09-24 18:17:07 GMT <alfresco-discord> <douglascrp> has anyone faced this kind of problem when trying to finish a workflow task? ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2018-10-21 00:00:00' for column 'DUEDATE_' at row 2 ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.bulkInsertTimer-Inline

2018-09-24 18:17:15 GMT <alfresco-discord> <douglascrp> this is with the embeded activiti engine

2018-09-24 18:19:20 GMT <alfresco-discord> <douglascrp> activiti 5.19.0.3 with alfresco 5.2.g

2018-09-24 18:19:42 GMT <alfresco-discord> <douglascrp> it seems the date format is right, and it is failing only for this task in this specific workflow instance

2018-09-24 18:19:51 GMT <alfresco-discord> <douglascrp> everything else works as expected

2018-09-24 18:59:14 GMT <alfresco-discord> <whwall> There is an API endpoint that the "process workspace" uses to get a json representation of a process definition:

2018-09-24 18:59:15 GMT <alfresco-discord> <whwall> /activiti-app/app/rest/process-instances/31/model-json

2018-09-24 19:02:46 GMT <alfresco-discord> <whwall> I tried to use it, but it does not work. At least, it doesn't using basic authentication and a user that has access to to that process definition.

2018-09-24 19:03:24 GMT <alfresco-discord> <whwall> Am I missing something?

2018-09-24 20:49:25 GMT <grendal_prime> ok. If i connect to a document library using webdav, does alfresco track changes and whatnot?

2018-09-24 20:50:30 GMT <grendal_prime> because honestly this entire download->edit->re-upload process scares the shit out my people

2018-09-24 20:51:42 GMT <grendal_prime> They like using the file browser, but if alfresco is not going to track changes done via webdav or smb, why even offer them as a connection type?

2018-09-24 21:06:22 GMT <AxelFaust> grendal_prime: What do you mean with "tracking"? Are you referring to the activities feed, or do you mean versioning et al?

2018-09-24 21:07:42 GMT <AxelFaust> Generally speaking, both WebDAV and SMB (should no longer be used as Windows 10 no longer supports SMB 1) both properly work with all auditing and versioning capabilities of the Repository.

2018-09-24 21:08:29 GMT <AxelFaust> What may potentially be confusing for people is that SMB will generally not generate any activities in the feed for the web UI / notification emails.

2018-09-24 21:09:21 GMT <AxelFaust> WebDAV supports generating activities, but this must be explicitly activated first via alfresco-global.properties (system.webdav.activities.enabled)

2018-09-24 21:11:00 GMT <AxelFaust> The way that versioning works is also slightly different than if interaction is performed via the web UI since the web UI inherently applies some custom logic to automatically mark any new file as versionable, while neither WebDAV nor SMB do (unless some special operations are called / special automation is added via coding or configuration)

2018-09-24 21:12:27 GMT <AxelFaust> Neither WebDAV nor SMB should be considered as "equivalent" access paths to the content. Rather they are alternative access paths, which have been built to act more like regular, dumb network drives, instead of the collaboration-focused web UI...

2018-09-24 23:49:10 GMT <alfresco-discord> <douglascrp> Ok, I figured out what my problem with the date was... 21/10/2018 is when the day light saving starts here in brazil

2018-09-24 23:53:25 GMT <alfresco-discord> <douglascrp> similar to this one https://issues.alfresco.com/jira/browse/MNT-15454

2018-09-24 23:53:37 GMT <alfresco-discord> <douglascrp> but for activiti

End of Daily Log

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