# Is there a method to migrate data from oracle to postgres database for Bonita 6.4.1?

**URL:** <https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301>\
**Category:** Q&A\
**Created:** [23 July 2020 15:47 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301 "2020-07-23T15:47:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gfcinque\_1403118](https://avatars.discourse-cdn.com/v4/letter/g/45deac/32.png) [@gfcinque\_1403118](https://community.ofelia.com/u/gfcinque_1403118)\
**Post date:** [23 July 2020 15:47 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301/1 "2020-07-23T15:47:13Z")

</div>

I have a java application with **BonitaBPMCommunity-6.4.1-JBoss-7.1.1** &nbsp;with oracle database. I want to migrate this oracle 11.2.0 EE bonita database in postgres 10 bonita database.&nbsp;  
I proceeded with a manual migration with the ora2pg tool but I have doubts about scheduled jobs.

In fact at startup I got the following errors

```
15:19:39,812 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016037: Could not find new XAResource to use for recovering non-serializable XAResource XAResourceRecord < resource:null, txid:< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a80109:-503e5c8c:5f117671:9adc2, node_name=1, branch_uid=0:ffffc0a80109:-503e5c8c:5f117671:9adc6, subordinatenodename=null, eis_name=java:jboss/datasources/bonitaDS >, heuristic: TwoPhaseOutcome.FINISH_OK, product: PostgreSQL/10.13 (Ubuntu 10.13-1.pgdg18.04+1), jndiName: java:jboss/datasources/bonitaDS com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord@7b085ae5 >
15:19:39,815 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016038: No XAResource to recover < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a80109:-503e5c8c:5f117671:9adc2, node_name=1, branch_uid=0:ffffc0a80109:-503e5c8c:5f117671:9adc6, subordinatenodename=null, eis_name=java:jboss/datasources/bonitaDS >
```

Solutions are described in https://developer.jboss.org/thread/221033&nbsp;

In any case, is there anyone who has faced the same problem and what procedure has been carried out?&nbsp;  
Has the bonita been checked for correct functioning after the migration of data from oracle to postgres?

**Edit**  
Since in bars I have specific connectors for oracle db I changed them with those for postgresql db under /bonita/server/ folder. But when I start, the server recreates the&nbsp;  
```  
BonitaBPMCommunity-6.4.1-JBoss-7.1.1/bonita/server/platform/tmp/bonita\_engine\_9663@gi5/local/PROCESS/6202952572871618860  
```  
folder with original oracle connectors. I found that the connector jar is found in the table:  
dependency.value\_

---

<div class="post-metadata">

**Author:** ![Pierre-yves\_Monnet](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@Pierre-yves\_Monnet](https://community.ofelia.com/u/Pierre-yves_Monnet)\
**Post date:** [8 August 2020 21:01 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301/2 "2020-08-08T21:01:09Z")

</div>

Hello,  
Arunja is used only in 7.10, so I assume you migrate your Bonita 6.4 to 7.10 and Oracle to Postgres.

1/ what is the operation you perform first? Bonita upgrade or Database change? Best is first to upgrade Bonita to 7.10, then move the database from Oracle to Postgres.

2/ check the QUARTZ tables: are the record insides are the same?

3/ it's a WARNING: is the different job works correctly?

I know there are some issues migrating to a database. I never did it, maybe one can give an update and share its experience? You can contact the Bonita Professional Service to help you on this procedure.

Second:

_Since in bars, I have specific connectors for oracle db&nbsp;_

This is a different issue. If you want to change the connector, you have to deploy a different version of the process. You can't change the files on disk: theses files are only temporary files, downloaded from the database. Everything is store in the database.

You must use not an ORACLE connector, but a JDBC or a DATASOURCE connector: then, it will works whatever is the database.

Good luck,

---

<div class="post-metadata">

**Author:** ![gfcinque\_1403118](https://avatars.discourse-cdn.com/v4/letter/g/45deac/32.png) [@gfcinque\_1403118](https://community.ofelia.com/u/gfcinque_1403118)\
**Post date:** [24 August 2020 10:58 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301/3 "2020-08-24T10:58:50Z")

</div>

**Edit 2: In response Pierre-yves Monnet on Sat, 08/08/2020 - 23:01**

1. I just migrated the database from Oracle to Postgres&nbsp;in Bonita 6.4.1 on JBoss-7.1.1

2.&nbsp;I checked the&nbsp;QUARTZ tables.&nbsp;They have the same values, however I will do a deepening.

3.&nbsp;From the tests performed Bonita 6.4.1 **seems** to continue to work in postgres

&nbsp;

In summary, the steps performed are:

1. Export existing&nbsp;bonita schema with ora2pg
2. Run from scratch new bonita&nbsp;server
3. Cancellation of pre-registered tables
4. Copy existing&nbsp;bonita&nbsp;(step 1) in bonita schema (step 2)
5. Copy /bonita folder in&nbsp;new bonita&nbsp;server
6. Update any connectors for use in postgres

&nbsp;

---

<div class="post-metadata">

**Author:** ![Pierre-yves\_Monnet](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@Pierre-yves\_Monnet](https://community.ofelia.com/u/Pierre-yves_Monnet)\
**Post date:** [24 August 2020 17:19 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301/4 "2020-08-24T17:19:31Z")

</div>

hello,

So, if you copy all data, if you changed the configuration (datasource + vendor in the setenv.sh - I supposed, 6.4 is a 4 year old version ? - moved to postgres), and you have this kind of errors, I don't know where it can come from.&nbsp;

Arunja is maybe the default library in JBOSS, that's why you have this log. I know Bonita 7.11 use this library too in Tomcat now.

&nbsp;

---

<div class="post-metadata">

**Author:** ![gfcinque\_1403118](https://avatars.discourse-cdn.com/v4/letter/g/45deac/32.png) [@gfcinque\_1403118](https://community.ofelia.com/u/gfcinque_1403118)\
**Post date:** [25 August 2020 07:49 UTC](https://community.ofelia.com/t/is-there-a-method-to-migrate-data-from-oracle-to-postgres-database-for-bonita-6-4-1/10301/5 "2020-08-25T07:49:37Z")

</div>

Hello,  
the use of this version is bound to the production environment