3 Replies Latest reply on Nov 13, 2012 4:10 PM by franco80

jbpm 5.3 JPA2 Violation of PRIMARY KEY constraint 'PKOrganizationalEn1DD065E0'. Cannot insert duplicate key in object 'dbo.OrganizationalEntity'.

franco80 Nov 13, 2012 9:51 AM

Hello again

when I invoke:

client.complete(taskId, actualUser, contentData, handler);

I recived Violation of PRIMARY KEY constraint 'PK__OrganizationalEn__1DD065E0'. Cannot insert duplicate key in object 'dbo.OrganizationalEntity'.

someone know what to do with this ? why I recived that message ?

regards

1. Re: jbpm 5.3 JPA2 Violation of PRIMARY KEY constraint 'PK__OrganizationalEn__1DD065E0'. Cannot insert duplicate key in object 'dbo.OrganizationalEntity'.

salaboy21 Nov 13, 2012 9:28 AM (in response to franco80)

For some reason you are creating the user again. It seems that you are inserting again an user that already exist.
Can you enable the hibernate logs?
Cheers
Actions
2. Re: jbpm 5.3 JPA2 Violation of PRIMARY KEY constraint 'PK__OrganizationalEn__1DD065E0'. Cannot insert duplicate key in object 'dbo.OrganizationalEntity'.

franco80 Nov 13, 2012 4:11 PM (in response to salaboy21)

ok, I know why, in ContentData I put userId and that is used in process in ActorId, this user as String is: 'john1,john2,john3'

but I thought that way is good from manual jbpm, user1,user2,user3... with comma
Actions
3. Re: jbpm 5.3 JPA2 Violation of PRIMARY KEY constraint 'PK__OrganizationalEn__1DD065E0'. Cannot insert duplicate key in object 'dbo.OrganizationalEntity'.

franco80 Nov 13, 2012 4:10 PM (in response to franco80)

reason was the lack of user in base, when I added john1,john2,john3 to base by add new User(john1)..., immediately began to work
Actions

JBossDeveloper