Is there a method to migrate data from oracle to postgres database for Bonita 6.4.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?
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
folder with original oracle connectors. I found that the connector jar is found in the table:
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.
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.
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.