Unable to perform an Appliance or Node Backup due to case fragmentation state

book

Article ID: 100047090

calendar_today

Updated On:

Description

Error Message

BUILD FAILED

D:\CW\V9XX\build.xml:xxxx: The following error occurred while executing this line.

D:\CW\V9XX\build\build-schema.xml:xxxx: unable to determine fragmentation state of case esadb_lds_case_xxxxxxxxxx

Cause

Possible issue with one or more cases.

Resolution

When performing all cases backup or Appliance/Node Backup, eDP checks the fragmentation of each case's database. If there's a potential issue with any case, backup will stop without backing up any cases.

Solution #1:

To determine which case(s) is/are causing the backup to fail, follow steps below:

1. From a command prompt on the server where mySQL is installed on, run: 

mysqlcheck -u root -p -A > d:\foldername\mysql_out.txt 

2. Enter the SQL password to proceed.

3. Once complete, open the mysql_out.txt and search for a $ (dollar sign). If $ exists next to the databasename, there's a fragmentation with that database/case.

4. From the eDP server, go to a command prompt and run the command below to determine the corresponding case:

D:\CW\V9XX\b admin-client support run clusterbrowser > d:\clusterbrowser.txt

5. Search the content of clusterbrowser.txt for the databasename containing $ from the result in step 1 to find the corresponding case.name.

6. From the Appliance UI, examine the corresponding case found in step 3 if there's any problem with it such as pre-processing failed or  incomplete.

7. Archive or backup and delete the case in question.

8. Perform an Appliance backup again.

Solution # 2:

To bypass the fragmentation check during an Appliance backup, follow steps below:

1. From the eDP server, run an Appliance backup with a switch to ignore fragmentation from a command line:

D:\CW\V9XX\b backup -D=esa.backup.ignoreFragments=true

2. Follow the prompts to continue with a backup.

Note: This method simply bypass the fragmentation check and not fixing the case in question.

Issue/Introduction

Unable to perform an Appliance or Node Backup due to case fragmentation state