This content has been marked as final.
Show 5 replies
-
1. Re: Problem Creating ProcessInstance
zipwow Mar 30, 2007 7:09 PM (in response to mchicote)I'm having the same issue, but my reading of it is that it's the unique constraint on the combination of processdefinition_ and key_ fields.
I don't get this behavior on hypersonic, but I do when I run against my Oracle database. -
2. Re: Problem Creating ProcessInstance
zipwow Mar 30, 2007 9:53 PM (in response to mchicote)I created a JIRA entry on what I'm seeing:
http://jira.jboss.com/jira/browse/JBPM-913
I removed the unique constraint on key_ and processdefinition_, and that fixed up my problem. I haven't done enough testing to confirm that it doesn't *cause* other problems, however.
-Kevin -
3. Re: Problem Creating ProcessInstance
mchicote Apr 3, 2007 9:45 AM (in response to mchicote)"zipwow" wrote:
I created a JIRA entry on what I'm seeing:
http://jira.jboss.com/jira/browse/JBPM-913
I removed the unique constraint on key_ and processdefinition_, and that fixed up my problem. I haven't done enough testing to confirm that it doesn't *cause* other problems, however.
-Kevin
k thanks, i'll try removing the constraint for a temporary solution.
any official word about this? -
4. Re: Problem Creating ProcessInstance
zipwow Apr 3, 2007 12:30 PM (in response to mchicote)I'd watch the JIRA for more details. Right now it says:
The main issue here is that most databases (including mysql and oracle) do not index null values (if you think about it, you'll see why). The appropriate workaround for your case is probably to replace the unique constraint with a standard index on (KEY_, PROCESSDEFINITION_).
The permanent fix is under discussion. -
5. Re: Problem Creating ProcessInstance
pjodev Apr 17, 2007 8:18 PM (in response to mchicote)were either of you ever able to get this to work with MSSQL 2000 ?
I keep getting errors that it is a duplicate processID OR that it is trying to insert "Null" into the processID field