Error on moving Customer data to a different database

Hi,

We want to move the Customer data to a different Rollbase database. Steps made:

- we have a Private Cloud 5.2.0 Rollbase instance

- there are 6 customers defined with ISV Partner application

- created a new Rollbase database on a different server using the create_oedb.bat in OE 11.7.4

- new database is added in Rollbase environment using System Console

- when trying to move Customer Data to new database we get the following error (backup.log):


[2019-04-02 00:56:25,152] [Comp=backup] [CustId=220619] [Server=STORAGE_52d4965e-1fe4-4e57-a329-3b56e8e617a7] Moving table RB_APPLICATION
[2019-04-02 00:56:25,190] [Comp=backup] [CustId=220619] [Server=STORAGE_52d4965e-1fe4-4e57-a329-3b56e8e617a7] Moving table RB_AUTH_PROFILES
[2019-04-02 00:56:25,197] [Comp=backup] [CustId=220619] [Server=STORAGE_52d4965e-1fe4-4e57-a329-3b56e8e617a7] ===> Error in thread rb.MASTER.job-consumer.LargeJob.thread-1 at 04/02/2019 12:56 AM: DB Move error:
java.lang.Exception: Error copying table RB_AUTH_PROFILES: RBDB_130_117_147: Error preparing statement

null
at com.rb.core.engine.services.job.system.a417.copyTable(a417.java:341)
at com.rb.core.engine.services.job.system.a417.doJob(a417.java:103)
at com.rb.core.engine.services.job.core.a433.doJob(a433.java:121)
at com.rb.core.data.a263.doJob(a263.java:26)
at com.rb.util.concurrent.a747.run(a747.java:50)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Any ideas on how to solve this?

Thank you,
Mihai

Continue reading...