Thanks a ton Idan for your help and much appreciated.
Here is the complete information if in case anyone interested.
#######
[Expert@xxxxxx:0]# sqlite3 /opt/CPsuite-R77/fw1/conf/grc_controls.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> delete from grc_controls;
sqlite> .quit
[Expert@xxxxxx:0]# sqlite3 /opt/CPsuite-R77/fw1/conf/grc_test_elements.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> delete from grc_test_elements;
Error: database disk image is malformed
sqlite> .quit
##################
[Expert@xxxxxx:0]# sqlite3 grc_test_elements.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
*** in database main ***
On tree page 1392 cell 0: 1 of 4 pages missing from overflow list starting at 970
On tree page 1392 cell 2: 2nd reference to page 948
On tree page 2522 cell 0: 2nd reference to page 1032
On tree page 2572 cell 100: 2nd reference to page 1378
On tree page 2572 cell 100: Child page depth differs
On page 2572 at right child: 2nd reference to page 2434
On tree page 994 cell 3: 2nd reference to page 478
On tree page 994 cell 3: Child page depth differs
On tree page 994 cell 4: Child page depth differs
On tree page 994 cell 14: 2nd reference to page 476
On tree page 994 cell 14: Child page depth differs
On tree page 994 cell 15: Child page depth differs
Page 889 is never used
Page 1897 is never used
Page 1899 is never used
Page 2320 is never used
Page 2332 is never used
Page 2348 is never used
Page 2552 is never used
Page 2564 is never used
Page 2565 is never used
rowid 104 missing from index GrcTestElementsUuidIdx
rowid 113 missing from index GrcTestElementsUuidIdx
rowid 141 missing from index GrcTestElementsUuidIdx
<snip>
rowid 56584 missing from index GrcTestElementsUuidIdx
rowid 56584 missing from index sqlite_autoindex_grc_test_elements_1
Error: database disk image is malformed
#####
[Expert@xxxxxx:0]# echo ".dump" | /usr/bin/sqlite3 BKP_grc_test_elements.sqlite | sed 's/ROLLBACK/COMMIT/g' | /usr/bin/sqlite3 FIXED_grc_test_elements.sqlite
[Expert@xxxxxx:0]# cp grc_test_elements.sqlite /home/admin
[Expert@xxxxxx:0]# cp FIXED_grc_test_elements.sqlite grc_test_elements
grc_test_elements.sqlite grc_test_elements.sqlite.tmp grc_test_elements_table.C
[Expert@xxxxxx:0]# cp FIXED_grc_test_elements.sqlite grc_test_elements.sqlite
Thanks and Regards,
Blason R
CCSA,CCSE,CCCS