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.
This will fix all your issues.
Thanks for your support and also really sorry again for my late reply.