Error on moving Customer data to a different database

Posted by mihai_neagoe on 02-Apr-2019 12:11

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

All Replies

Posted by Anoop Premachandran on 23-May-2019 14:08

Please log defect... Looks like null values are not handled in RB_AUTH_PROFILES Db move action

This thread is closed