topic Re: MysqlDataTruncation while deploying new process. in Alfresco Archive

MysqlDataTruncation while deploying new process.

progix_21 — Wed, 30 Jul 2014 10:14:25 GMT

I am getting a MysqlDataTruncation Exception while deploying any process in Activiti Engine. I am using MySQL as Database instead of In-Memory Database. With In-Memory Database, deployment is working fine.Exception details:Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:

Re: MysqlDataTruncation while deploying new process.

frederikherema1 — Wed, 30 Jul 2014 15:06:46 GMT

We have different SQL-scripts for MySQL 5.5 and 5.6, make sure you're using the correct version. From the user-guide:

Note for MySQL users: MySQL version lower than 5.6.4 has no support for timestamps or dates with millisecond precision. To make things even worse, some version will throw an exception when trying to create such a column but other versions don't. When doing auto-creation/upgrade, the engine will change the DDL when executing it. When using the DDL file approach, both a regular version and a special file with mysql55 in it are available (this applies on anything lower than 5.6.4). This latter file will have column types with no millisecond precision it it.

Concretely, the following applies for MySQL version

<5.6: No millisecond precision available. DDL files available (look for files containing mysql55). Auto creation/update will work out of the box.
5.6.0 - 5.6.3: No millisecond precision available. Auto creation/update will NOT work. It is advised to upgrade to a newer database version anyway. DDL files for mysql 5.5 could be used if really needed.
5.6.4+:Millisecond precision available. DDL files available (default file containing mysql). Auto creation/update works out of the box.
Do note that in the case of upgrading the MySQL database later on and the Activiti tables are already created/upgraded, the column type change will have to be done manually!

I suspect it's related to this, not 100% sure… Can you check your MySQL version?

Re: MysqlDataTruncation while deploying new process.

payamrastogi — Mon, 24 Nov 2014 18:36:07 GMT

Hi,
We are getting the same error. If you were able to resolve that problem, kindly let me know the fix.

Re: MysqlDataTruncation while deploying new process.

trademak — Tue, 25 Nov 2014 09:43:31 GMT

Which version of Activiti are you using and which version of MySQL?

Best regards,

Re: MysqlDataTruncation while deploying new process.

prasadprabha07 — Sun, 27 Mar 2016 09:18:25 GMT

I am having the same problem….I am using MySQL version 5.6.19 and Activiti 5.19.0.2.
I executed SQL-scripts for MySQL 5.5, but I dont find SQL-scripts for 5.6

Re: MysqlDataTruncation while deploying new process.

prasadprabha07 — Sun, 27 Mar 2016 10:00:02 GMT

Yes…now its working …I have changed the mysql-connector-java-3.1.14 to mysql-connector-java-5.1.24