JBoss Community

I have same problems when i user Human Task on MYSQL

created by losfa jon in jBPM - View the full discussion

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

Reply to this message by going to Community

Start a new discussion in jBPM at Community