It was due to the mysql setting - STRICT_TRANS_TABLES
Please do following setup in your server
=============================================================================
This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem.
=======================================================================================
Also refer
This will fix all your issues.
Thanks for your support and also really sorry again for my late reply.