topic Problem - Table ACT_RE_PROCDEF not found in Alfresco Archive

Problem - Table ACT_RE_PROCDEF not found

waldi666 — Thu, 29 Sep 2011 07:01:54 GMT

Hi,i am running aciviti in version 5.7 with spring integration and inmemory h2 database access. The application starts fine -the activiti engine runs up without errors. I can use the application for a while without problems, the workflow will beexecuted without problems.After a time the activiti eng

Re: Problem - Table ACT_RE_PROCDEF not found

trademak — Thu, 29 Sep 2011 07:40:35 GMT

Hi,

What do you mean with after a while? Do you run this application in a web container?
Please provide some more details or event better a test project so we can reproduce the error.

Best regards,

Re: Problem - Table ACT_RE_PROCDEF not found

waldi666 — Thu, 29 Sep 2011 08:13:30 GMT

Hi,

I have a web application (war) with all libraries & spring configurations inside. This war will be deployed to a jetty
server. Clients access the application over webservice (jax-ws) layer. Each client request have to call an deployed
activiti workflow.
This works if i have started the jetty server. If the server in idle time (maybe 5-10 minutes) the next client call
runs in the exception.

I looks like the inmemory h2 database is lost at this time.

At the moment i will try to change the h2 database setting from:
<property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" />
to
<property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=-1" />

thanks
Heiko

Re: Problem - Table ACT_RE_PROCDEF not found

ftr — Mon, 17 Oct 2011 11:48:16 GMT

I actually encouter the same problem with deployment in a Web Module on JBoss 6. It all starts out fine but after a while I get the exact same error with the same datasource configuration.

Re: Problem - Table ACT_RE_PROCDEF not found

trademak — Mon, 17 Oct 2011 12:28:04 GMT

Is there a specific reason why you are using an in-memory data source?
I would go for a standalone H2 database, just like the Activiti Explorer does.

Best regards,

Re: Problem - Table ACT_RE_PROCDEF not found

ftr — Mon, 17 Oct 2011 12:41:05 GMT

We're currently evaluating activiti and use the in-memory version for convenience, it's unlikely that we're gonna stick with the in-memory approach should we decide to go forward with activiti.