Clean up Exalate database after restore Prd to Dev environment

Hi, we have three Jira Data Center On Prem instances, one for production, one for testing and one for development. It often happens that to refresh the development environments we update the Dev environments using Jira XML export\import.

On these side environments we, after updating the data, we modified the existing connections to avoid unwanted sync before starting.
Unfortunately is it also not possible to create a new connection anymore.

The question is:

Is there an easy way to clean up Exalate database tables (Oracle) to have a clean plugin setup after restoring to a test environment?

Thanks!

Hi @ron.becker,

Welcome to the community!

We have a standard process to restore a staging/dev environment from a production backup in Jira On-premise:

To clean up Exalate Database tables in your Staging or Dev environment, in order to have a clean setup, you can run the following:

TRUNCATE TABLE "AO_08F1AF_TRACE"; // trace data of comments and attachments
TRUNCATE TABLE "AO_08F1AF_TWIN_TRACE"; // relation between local and remote entities
TRUNCATE TABLE "AO_08F1AF_ERROR"; // errors 
TRUNCATE TABLE "AO_08F1AF_BLOB_EVENT"; // outgoing attachments events on queue
TRUNCATE TABLE "AO_08F1AF_BLOB_REQUEST"; // incoming attachments requests on queue
TRUNCATE TABLE "AO_08F1AF_SYNC_EVENT"; // outgoing events on queue
TRUNCATE TABLE "AO_08F1AF_SYNC_REQUEST"; // incoming requests on queue
TRUNCATE TABLE "AO_08F1AF_BLOB_METADATA"; attachments metadata
TRUNCATE TABLE "AO_08F1AF_REPLICA"; // payload data
TRUNCATE TABLE "AO_08F1AF_RELATION"; //Connections data

If you need further help, you can contact Exalate support :slight_smile:

Regards

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.