How do you migrate a database backing Activiti without losing the workflows currently in flight?

[rinat]

We have an Oracle database backing our spring activiti bpmns for our application. We need to migrate from one database to another. It seems that simply moving the data from the activiti tables to the new database wasn't enough because we're getting NullPointerExceptions on resources in the BpmnDeployer.

What is the process to accomplish this?

[cjose · Accepted solution]

Moving the data should have been enough unless your migration is a more complex migration such as migration from multiple databases to a single database etc...please provide more information such as error details.

[rinat]

Thanks for the response! We figured out that our migration wasn't as complete as we thought. We were missing a blob column in one of our tables that represents the process.