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

1
0
-1

I have a java application with BonitaBPMCommunity-6.4.1-JBoss-7.1.1 with oracle database. I want to migrate this oracle 11.2.0 EE bonita database in postgres 10 bonita database.
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

In any case, is there anyone who has faced the same problem and what procedure has been carried out?
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
```
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_

Comments

Submitted by gfcinque_1403118 on Mon, 08/24/2020 - 12:58

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

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

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

3. From the tests performed Bonita 6.4.1 seems to continue to work in postgres

In summary, the steps performed are:

  1. Export existing bonita schema with ora2pg
  2. Run from scratch new bonita server
  3. Cancellation of pre-registered tables
  4. Copy existing bonita (step 1) in bonita schema (step 2)
  5. Copy /bonita folder in new bonita server
  6. Update any connectors for use in postgres
Submitted by Pierre-yves Monnet on Mon, 08/24/2020 - 19:19

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.

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.

Submitted by gfcinque_1403118 on Tue, 08/25/2020 - 09:49

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

1 answer

1
0
-1

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

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,

Notifications