[jboss-user] [jBPM] - Re: TaskService Referential integrity constraint violation
Gary Struthers
do-not-reply at jboss.com
Mon Aug 15 19:40:59 EDT 2011
Gary Struthers [http://community.jboss.org/people/GaryS] created the discussion
"Re: TaskService Referential integrity constraint violation"
To view the discussion, visit: http://community.jboss.org/message/621151#621151
--------------------------------------------------------------
Hi Mauricio,
I've tried adding various users and groups to the TaskServiceSession. If I don't have an Administrator
Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
fails. But, for me that inserts fine and so does the first potential owner.
Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?)
But then it updates the session and that begins the constraint violation
Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?
0 14/08 12:33:53,996[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:
insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]
5 14/08 12:33:54,001[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement:
insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128]
7 14/08 12:33:54,003[NioProcessor-1] ERROR event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/621151#621151]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110815/4bf9625f/attachment.html
More information about the jboss-user
mailing list