Ensure that the 'dir.root' property is pointing to the correct data location.

[rguduri]

After restarting the server where alfresco application got installed it stopped functioning. Ensured everything is fine with the tomcat and postgres but the issue didn't resolve, throwing CONTENT INTEGRITY ERROR. Attached the log file for the same. Version am using is 4.2.c. This application has been functioning from last couple of years without any problem and restarted the server where this application deployed several times in past also, but used to function without any issue. I did back up very long time ago, so I have to loose much of data if I go back and replace with my last backup.

From the community got to know that this integrity error occurs when there is inconsistency between databse and alf_data content, but am sure that except restarting the server did nothing. And  also followed the suggestion of similar instances i.e, changing the property index.recovery.mode to all modes i.e., FULL, AUTO, NONE but no resolution. Please suggest where to look for ?

[mehe · Accepted solution]

Have you looked into /opt/alfresco-4.2.c/alf_data/contentstore ?

There should be some "Year" directories, beginning with the year of your installation until now.

If you have directories and files in there, you can check the consistency by comparing the content Urls in the DB table alf_content_url with the files in your content store.

If your are lucky, the missing files are in your old content store backup - most likely the system files are - and you can migrate (copy) the old and new contenstore.

[rguduri]

Cheers Martin, awesome. Gone through with the entries in database and found one of the year missing from alf_data. After putting everything in place, working like charm. Thanks again.

[mehe]

I had a working-session with ‌ last week, which improved my understanding of the content store/db organization, so thanks to him

[cesarista]

Some situations related with this problem may be:

- The mounted point for alf_data or contentstore was lost.

- alf_data directory was moved incorrectly.

- A backup was recovered incorrectly.

- A non coordinated backup was recovered.

- Permissions under alf_data/contentstore changed (not completelty sure..)

Regards.

--C.