[jboss-user] [jBPM] - JBPM 4.3 - org.jbpm.api.JbpmException: couldn't acquire block of ids

[Maciej Swiderski]

Maciej Swiderski [http://community.jboss.org/people/swiderski.maciej] replied to the discussion

"JBPM 4.3 - org.jbpm.api.JbpmException: couldn't acquire block of ids"

To view the discussion, visit: http://community.jboss.org/message/539230#539230

--------------------------------------------------------------
Hi,

what does return following query on your data base:

     select
        propertyim0_.KEY_ as KEY1_6_,
         propertyim0_.VERSION_ as VERSION2_6_,
        propertyim0_.VALUE_ as  VALUE3_6_ 
    from
        JBPM4_PROPERTY propertyim0_ 

It should return two rows, one for db.version and second for next.dbid.

If you don't have it I would recommend to drop your jbpm schema and create it once again. Please use ant tasks for that that are delivered with jBPM distribution.

drop.jbpm.schema -Ddatabase=postgresql


create.jbpm.schema -Ddatabase=postgresql

create.jbpm.schema task will insert all required items into that table.

HTH
Maciej

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/539230#539230]

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/20100423/9fb80d61/attachment.html