topic Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1 in Alfresco Archive

Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1

jenilgandhi04 — Tue, 11 Nov 2014 21:41:26 GMT

I am getting Exception while creating workflow :1. Activiti API Version 5.112. MYSQL Version 5.6.203. Follwing is the Exception Stacktrace:### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1### The

Re: Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1

jbarrez — Wed, 19 Nov 2014 23:08:41 GMT

Need a bit more info. What api are you calling? Which process? Code snippets, pls

Re: Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1

jenilgandhi04 — Tue, 25 Nov 2014 03:33:44 GMT

Hi,
I am uploading xml file for workflow and following is the submit method.

@RequestMapping(value="/client/admin/workflow", method=RequestMethod.POST)
    public String adminWorkflowPost(FileUpload fileUpload, HttpSession s) {

        ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
        RepositoryService repositoryService = processEngine.getRepositoryService();

        CommonsMultipartFile fileData = fileUpload.getFileData();

        try {
            // Set the name to subprogramId, so the deployment can be retrieved.
            repositoryService.createDeployment()
                    .addInputStream(fileData.getOriginalFilename(), fileData.getInputStream()).name(String.valueOf(fileUpload.getSubprogramId()))
                    .deploy();

        } catch (IOException e) {
            e.printStackTrace();
        }

        return "redirect:/client/admin/workflow.html?id=" + fileUpload.getSubprogramId();
    }

Re: Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1

trademak — Tue, 25 Nov 2014 09:38:50 GMT

Is there a reason for using such an old version of Activiti? In Activiti 5.16 this is definitely working. It could be that there's an issue with 5.11 and MySQL 5.6. Did you try with MySQL 5.5.x?

Best regards,

Re: Incorrect datetime value: '' for column 'DEPLOY_TIME_' at row 1

jenilgandhi04 — Tue, 25 Nov 2014 21:08:09 GMT

Hey guys ! Thank you very much for your help.

But this problem has been solved by replacing my older mysqlconnector jar with mysql-connector-java-5.1.34.jar

thanks once again for your input.