TDM: OrientDB corruption resolution

Article Id: 130267

Status: Published

Updated On: 29-03-2019 11:08

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.

1558688108707000130267_sktwi1f5rjvs16fih.html

Download