Error on moving Customer data to a different database - Forum - Rollbase - Progress Community

Error on moving Customer data to a different database


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 
    	at java.util.concurrent.Executors$ Source)
    	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
    	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
    	at java.util.concurrent.ScheduledThreadPoolExecutor$ Source)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    	at java.util.concurrent.ThreadPoolExecutor$ Source)
    	at Source)

    Any ideas on how to solve this?

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