TDM: OrientDB corruption resolution

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

OrientDB has become corrupt

Cause

OrientDB journal files became corrupted

Environment

TDM 4.7
 

Resolution

carry out the following steps (no exception)

1. Stop TDMPortal and OrientDB

2. Remove entry <entry value="false" name="storage.useWAL"/> from orientdb-server-config.xml

3. Restore backup from March orientdb_March+Backup.zip

4. Now  go to C:\ProgramData\CA\CA Test Data Manager Portal\orientdb\databases\ReservationDB

5. sort by type and delete all the files with are empty(0kb) and name ReservationDB.<<id>>.wal

<Please see attached file for image>

id="m_8598127359230969710Picture_x0020_1" alt="image.png" height="500" src="https://mail.google.com/mail/u/0?ui=2&ik=8d984fecab&attid=0.0.1&permmsgid=msg-f:1629292015378062354&th=169c6874a3fd5c12&view=fimg&sz=s0-l75-ft&attbid=ANGjdJ8b8E0W_jqmOrCIagfwKvpKbSVTH0_PphB5sxBEvBajF_aLMusp9RLkgCF2yjZMVsjtj9Ur032yjemk2PwlCEL0mzjEOGXKYvCmUZQQL_bX7RbaNoo2Dxlhics&disp=emb" style="width: 5.8541in; height: 5.2083in;" width="562">

 

6. Open command prompt as administrator and navigate to C:\Program Files\CA\CA Test Data Manager Portal\orientdb\bin

7. run console.bat

8. At orientdb prompt execute command  connect plocal:"C:/ProgramData/CA/CA Test Data Manager Portal/orientdb/databases/ReservationDB" admin admin

9.  Now run command  check database

10. Run command REPAIR DATABASE --fix-graph --fix-ridbags --fix-bonsai --fix-links -v

11. Run command exit

12. Restart OrientDB and TDM Portal

Additional Information

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.