topic Re: Content Integrity Error in Alfresco Archive

Content Integrity Error

sherrykerry — Tue, 23 Nov 2010 23:07:29 GMT

I had to recreate alfresco database with utf8 char encoding.I performed these steps:1. Stop Alfresco2. Delete alf data folder '/app/alfresco/alf_data_alfrescoSource3'3. Created new database with correct encoding4. Start ALfrescoAfter I start alfresco, I see that 'alf_data_alfrescoSource3' folder is

Re: Content Integrity Error

rhoefer — Wed, 24 Nov 2010 13:25:59 GMT

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.

Re: Content Integrity Error

mrogers — Wed, 24 Nov 2010 13:29:42 GMT

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?

Re: Content Integrity Error

sherrykerry — Wed, 24 Nov 2010 15:59:01 GMT

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.

Re: Content Integrity Error

rhoefer — Wed, 24 Nov 2010 16:41:57 GMT

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.

Re: Content Integrity Error

sherrykerry — Wed, 24 Nov 2010 17:07:34 GMT

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

Re: Content Integrity Error

mrogers — Wed, 24 Nov 2010 17:10:26 GMT

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.

Re: Content Integrity Error

rhoefer — Wed, 24 Nov 2010 17:11:45 GMT

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

Re: Content Integrity Error

sherrykerry — Wed, 24 Nov 2010 17:13:23 GMT

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