PPDM - Backups fails with error ABA0002 SQL statement 'no such table: tbl_backups'. SQLite error code: 1
Summary: FileSystem Self-Service backups fail with error ABA0002: ddfssv: Unable to run the SQL statement 'no such table: tbl_backups'. SQLite error code: 1
Symptoms
When running a FileSystem backup, it fails with the following error:
2024-11-21T15:17:03.236Z [TRACE_ID_cd55d139064440b7]fsys_access(/Storage-Unit/PLCTLP-5c22421e-27eb-42d3-bafb-f883477f1efb/hostname.domain.com/fsab.rec.lck): Access check for '/Storage_unit/PLCTLP-5c22421e-27eb-42d3-bafb-f883477f1efb/hostname.domain.com/fsab.rec.lck' failed (error number 5004): [50594294] [1] Thu Nov 21 15:17:03 2024
ddp_access() failed, Path //Storage_unit/PLCTLP-5c22421e-27eb-42d3-bafb-f883477f1efb/hostname.domain.com/fsab.rec.lck, mode 0 Err: 5004-nfs lookup failed (nfs: No such file or directory)
2024-11-21T15:17:03.250Z [TRACE_ID_cd55d139064440b7]199540:ddfssv:Unable to run the SQL statement 'no such table: tbl_backups'. SQLite error code: 1.
2024-11-21T15:17:03.250Z [TRACE_ID_cd55d139064440b7]Cannot determine the count of transaction of the record file: no such table: tbl_backups
2024-11-21T15:17:03.250Z [TRACE_ID_cd55d139064440b7]Cannot determine the count of transaction of the record file
2024-11-21T15:17:03.257Z [TRACE_ID_cd55d139064440b7]SQLite database initialization failed: Unable to get the SQLite databases status..
.2024-11-21T15:17:03.258Z [TRACE_ID_cd55d139064440b7]Error occurred when running the save command: SQLite database initialization failed.
Cause
This is due to the fsab.rec file located in the DataDomain being empty.
Resolution
From the Data Domain, the file will be located in this path:
/Storage_unit/PLCTLP-XXXXXXXXXXXXXXXXXXX/hostname.domain.com/
Here, the fsab.rec will show as 0kb. Rename it, and restart the backup.
To know how to access the DataDomain Storage unit, please follow the steps 2,3,4 from this article: https://www.dell.com/support/kbdoc/en-us/000215185.