Content Integrity Error

[sherrykerry]

I had to recreate alfresco database with utf8 char encoding.

I performed these steps:
1. Stop Alfresco
2. Delete alf data folder '/app/alfresco/alf_data_alfrescoSource3'
3. Created new database with correct encoding
4. Start ALfresco

After I start alfresco, I see that 'alf_data_alfrescoSource3' folder is created and these folders under this also created:
audit.contentstore
contentstore
contentstore.deleted
lucene-indexes

In the log file I see that Index is build 100% and then this error as below. When I check the status it says RUNNING, but I cannot his the alfresco console/ dashboard.
Userystem INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /app/alfresco/alf_data_alfrescoSource3
Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
Userystem ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
Userystem ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
…

log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Exception in thread "LicenseVerifier_QuartzSchedulerThread" java.lang.NoClassDefFoundError: org.quartz.StatefulJob
        at org.quartz.JobDetail.class$(JobDetail.java:279)

In 'custom-repository.properties' I have:
index.recovery.mode=FULL
dir.root=/app/alfresco/alf_data_alfrescoSource3

I tried to find soln in your older posts and most of them say to perform the same steps as above. But that did not solve my problem.

Please help.

[rhoefer]

In 'custom-repository.properties' I have:
index.recovery.mode=FULL
dir.root=/app/alfresco/alf_data_alfrescoSource3

To my knowledge Alfresco  doesn't look for a "custom-repository.properties" try making a alfresco-global.properties with these properties and throw it in your extension directory.

I'd guess Alfresco is seeing the default ./alf_data directory from the default property file.

[mrogers]

There's stuff in the database that does not match the content store.

Did you change your database settings to point to your new database or are you still using the old one?

[sherrykerry]

Thanks for your reply.

@rhoefer: Where is ./alf_data default directory set ? How do I create 'alfresco-global.properties' ? We have multiple instances of alfresco in which couple of websites are hosted on each instance.

@mrogers: We dropped the schema and recreated same schema, with same DDL SQL. Just changed character_set_database default to UTF8 from latin1. So I need not change database settings as this is not new database.

[rhoefer]

Well, I'm not running your type of setup, but here's what I was talking about:

Make an alfresco-global.properties file and throw it in your app server's extension directory. I'm using jboss it's in $JBOSS_HOME/server/default/conf.

The directory root should be set with: dir.root=YOUR_PATH


I'm wondering if I misread your question, I was thinking that you probably had this all set up somewhere already, or was this a new install?
I was just guessing that maybe it was picking up the default from repository.properties and not the real path to your data.

[sherrykerry]

yeah this set up is done earlier and was working fine before I switched database char endcoding. After I restart is what causing me problems.

I see that there are bunch of files under extension. But neither alfresco-global.properties nor repository.properties
db properties, dir.ROOT, rmi ports are defined in custom-repository.properties under extension. which is under /app/tc/instances/AlfrescoSource03/shared/classes/alfresco/extension

We use tcserver (extention of tomcat) as the app server and AlfrescoSource03 is the tcserver instance which is catalina.base in catalina.properties defined under /app/tc/instances//AlfrescoSource03/conf directory.

tcserver.node=AlfrescoSource03
shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar

Terminology: /app/tc/instances/AlfrescoSource03 is the TCSERVER_HOME

[mrogers]

If you are using Alfresco 3.1 then it is configured through custom-repository.properties.

alfresco-global.properties was introduced in 3.2 to get rid of the mutiple properties files that needed to be updated.

Did you dump and recreate the database or do you have an empty schema?   The content itegrity error leads me to believe that you have some data in your database that does not match your empty content store.

[rhoefer]

Ah, my apologies to the OP. I need to start checking versions on the side bar!

[sherrykerry]

Yes we are using alfresco Version :Enterprise - v3.1.1 (229)