2 Replies Latest reply on Oct 28, 2011 1:34 PM by Demian Calcaprina

    I have same problems when i user Human Task on MYSQL

    losfa jon Newbie

      hi

      first i start my Server and add a new user (customer);

      and it works ok

      but when i use Client to start a process

      it throws a sql error

      that is

      Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?

      Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

      Hibernate: insert into Content (content) values (?)

      Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=?

      Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)

      28-10-11 afternoon 04:01 org.hibernate.util.JDBCExceptionReporter logExceptions

      WARNING: SQL Error: 1452, SQLState: 23000

      28-10-11 afternoon 04:01 org.hibernate.util.JDBCExceptionReporter logExceptions

      SEVERE: Cannot add or update a child row: a foreign key constraint fails (`jbpm5`.`peopleassignments_bas`, CONSTRAINT `FK9D8CF4EC2C122ED2` FOREIGN KEY (`entity_id`) REFERENCES `organizationalentity` (`id`))

       

      it happen becouse of the Table Task is null

       

      but on the log  sql  

      Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

       

      the task has insert into values

       

      so i don.t know how to do it

      if someone who know please help me

      thanks