Re: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

[Jacopo Cappellato <ja...@hotwaxsystems.com>]

On Sat, Mar 31, 2018 at 4:50 PM, Schumann Ye <Sc...@hotmail.com>
wrote:

> [...]

 followed the ReadMe to install the unzipped Ofbiz 16.11.03;
>

Ok, I have verified and in 16.11.* releases the MySQL type set for the
date-time type is DATETIME instead of DATETIME(3):

https://svn.apache.org/repos/asf/ofbiz/branches/release16.11/framework/entity/fieldtype/fieldtypemysql.xml

Ff you edit the file framework/entity/fieldtype/fieldtypemysql.xml and set
DATETIME(3) there and then run "Gradlew cleanAll loadDefault" you should be
able to execute your workflow.

Kind regards,

Jacopo

答复: 答复: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

[Schumann Ye <Sc...@hotmail.com>]

Dear Jacopo,

Sorry for coming back to you late on the issue.
I've done changing from DATETIME(6) to DATETIME(3). Everything works perfectly without error so far.
However, in order to avoid potential duplicate entry when creating new record, my suggestion is to set it as DATETIME(6).
As the calculating capacity & efficiency increases these days, odds still remain for duplicate data entries when the CPU & RAM are powerful enough.

This is only my personal view for your reference.
HIH.

B.R.
Schumann

-----邮件原件-----
发件人: Jacopo Cappellato <ja...@hotwaxsystems.com> 
发送时间: 2018年4月2日 13:59
收件人: user@ofbiz.apache.org ML <us...@ofbiz.apache.org>
主题: Re: 答复: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

On Sun, Apr 1, 2018 at 10:30 AM, Schumann Ye <Sc...@hotmail.com>
wrote:

> Hi Jacopo,
>
> Thanks for your hints.
> Actually I am not using SVN now, I've done quite some customizations 
> so I would like to do it directly in the database mysql by using alter table.
> Is it ok if I do it this way?
>

Yes, you can directly alter the MRP_EVENT table.

Regards,

Jacopo

Re: 答复: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

[Jacopo Cappellato <ja...@hotwaxsystems.com>]

On Sun, Apr 1, 2018 at 10:30 AM, Schumann Ye <Sc...@hotmail.com>
wrote:

> Hi Jacopo,
>
> Thanks for your hints.
> Actually I am not using SVN now, I've done quite some customizations so I
> would like to do it directly in the database mysql by using alter table.
> Is it ok if I do it this way?
>

Yes, you can directly alter the MRP_EVENT table.

Regards,

Jacopo

答复: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

[Schumann Ye <Sc...@hotmail.com>]

Hi Jacopo,

Thanks for your hints.
Actually I am not using SVN now, I've done quite some customizations so I would like to do it directly in the database mysql by using alter table.
Is it ok if I do it this way?
Thanks

Schumann

-----邮件原件-----
发件人: Jacopo Cappellato <ja...@hotwaxsystems.com> 
发送时间: 2018年4月1日 16:22
收件人: user@ofbiz.apache.org ML <us...@ofbiz.apache.org>
主题: Re: 答复: 答复: A major bug in OFBiz Manufacturing MRP function

On Sat, Mar 31, 2018 at 4:50 PM, Schumann Ye <Sc...@hotmail.com>
wrote:

> [...]

 followed the ReadMe to install the unzipped Ofbiz 16.11.03;
>

Ok, I have verified and in 16.11.* releases the MySQL type set for the date-time type is DATETIME instead of DATETIME(3):

https://svn.apache.org/repos/asf/ofbiz/branches/release16.11/framework/entity/fieldtype/fieldtypemysql.xml

Ff you edit the file framework/entity/fieldtype/fieldtypemysql.xml and set
DATETIME(3) there and then run "Gradlew cleanAll loadDefault" you should be able to execute your workflow.

Kind regards,

Jacopo