AnsweredAssumed Answered

Error updating bpm_inbox record

Question asked by Sanchez Jorge Luis on Nov 19, 2018

I writed a Command class. This class save the records and run a BPMN but after proccess whit 36 records the log send this message "Error updating bpm_inbox record Query Failed: update pmse_inbox set cas_status = 'ERROR' where cas_id = AND cas_status<>'COMPLETED' AND cas_status<>'TERMINATED': MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cas_status<>'COMPLETED' AND cas_status<>'TERMINATED'' at line 1" i not any idea this issue. Somebody experimented this same issue whit BPMS?

My instance runs in vagrant and this version the sugarcrm is 8.0.0.


thanks for your feedback