Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Cannot restore tenant backup

Information

 
Article Number000093163
EnvironmentProduct: Rollbase
Version: 5.2.2.0
Database: OpenEdge RDBMS 11.6
Question/Problem Description
When restoring a system backup in a new Rollbase installation the error below is displayed in the log file and the backup is not restored.
 
Steps to Reproduce
Clarifying Information
restore.log file:

[<date-time>] [Comp=restore] [CustId=<tenant-id>] [Server=<storage-node-id>] Restoring table RB_TRANSLATION_BACKUP
[<date-time>] [Comp=restore] [CustId=<tenant-id>] [Server=<storage-node-id>] ===> Error in thread rb.STORAGE.job-consumer.StorageJob.thread-1 at <date-time>: Restoration error: java.sql.SQLException: RB_1: Error preparing statement 
at com.rb.util.db.a674.prepareStatement(a674.java:139)
at com.rb.util.db.a674.prepareStatement(a674.java:193)
at p36.a121.restore(a121.java:172)
at p36.a126.doJob(a126.java:227)
at com.rb.core.engine.services.job.core.a435.doJob(a435.java:121)
at com.rb.core.data.a265.doJob(a265.java:26)
at com.rb.util.concurrent.a748.run(a748.java:50)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Error MessageRestoration error: java.sql.SQLException: RB_1: Error preparing statement 
Defect/Enhancement Number
Cause
Step 5 from article 000090764 has been forgotten.
RB_TRANSLATION_BACKUP is not part of Rollbase core tables and should have been dropped.
Resolution
Run the command below to drop the table from the source database and generate a new system backup.
 
DROP TABLE RB_TRANSLATION_BACKUP;
commit work;

 
Workaround
Remove file RB_TRANSLATION_BACKUP.csv from the system backup zip file.
Notes
Attachment 
Last Modified Date12/6/2018 5:26 PM