topic Re: Integrity Error after Alfresco Upgrade in Alfresco Archive

Integrity Error after Alfresco Upgrade

texano — Sat, 25 Apr 2015 19:03:46 GMT

Hi,I've upgrade my Alfresco installation with 20GB repository content from 4.2.C to the newest 5.0.D.Now we are having errors related to "Mandatory property not set" and "node.integrity.IntegrityException" when creating new sites, viewing tasks, etc. This errors are show in Alfresco Share page and i

Re: Integrity Error after Alfresco Upgrade

texano — Tue, 28 Apr 2015 10:57:14 GMT

Hey guys,

Can someone help me with this?

Thanks.

Re: Integrity Error after Alfresco Upgrade

miguel75 — Tue, 28 Apr 2015 14:51:27 GMT

I've exactly the same problem

Re: Integrity Error after Alfresco Upgrade

openpj — Tue, 28 Apr 2015 19:19:25 GMT

Try to execute a full reindex, removing also the alfrescoModels included in Solr, it should solve your problem.
This because Apache Solr actually includes an old version of the Alfresco content models and you have to remove them for letting Solr to get the newer versions.

Hope this helps.

Re: Integrity Error after Alfresco Upgrade

ceeliro — Wed, 29 Apr 2015 08:43:00 GMT

Perfect it worked (at least for me)! Thanks a lot

Re: Integrity Error after Alfresco Upgrade

miguel75 — Wed, 29 Apr 2015 09:51:21 GMT

Hi!

Thanks for the reply, but it doesn't work for me

I've deleted all indexes and alfrescomodels, but the error persists.

With alfresco stopped:
[alfresco@alfresclon solr4]$ pwd
/opt/alfresco5.0.d/alf_data/solr4
[alfresco@alfresclon solr4]$ ls -la
total 20
drwxrwxr-x 5 alfresco alfresco 4096 Apr 29 11:45 .
drwxrwxr-x 8 alfresco alfresco 4096 Apr 29 11:25 ..
drwxrwxr-x 3 alfresco alfresco 4096 Apr 29 11:46 content
drwxrwxr-x 4 alfresco alfresco 4096 Apr 29 11:45 index
drwxrwxr-x 2 alfresco alfresco 4096 Apr 29 11:46 model
[alfresco@alfresclon solr4]$ rm -rf *

[alfresco@alfresclon alfrescoModels]$ pwd
/opt/alfresco5.0.d/solr4/alfrescoModels
[alfresco@alfresclon alfrescoModels]$ rm -rf *

Re: Integrity Error after Alfresco Upgrade

miguel75 — Wed, 29 Apr 2015 15:31:26 GMT

I've tried upgrading to 5.0a instead of 5.0d and now it's working ok.

Re: Integrity Error after Alfresco Upgrade

texano — Sat, 02 May 2015 23:13:00 GMT

Hey,

The reindex did not work for me
Still have the same error

Mandatory property not set:
   Node: workspace://SpacesStore/1ad6e30b-7b4d-4886-9d79-80ad6707ecca
   Name: 1ad6e30b-7b4d-4886-9d79-80ad6707ecca
   Type: {http://www.alfresco.org/model/content/1.0}person
   Property: {http://www.alfresco.org/model/content/1.0}sizeCurrent

Re: Integrity Error after Alfresco Upgrade

texano — Tue, 05 May 2015 14:08:06 GMT

Hi OpenPj,

Reindex did not work here

Even I need to expand some tab and Alfresco Share i'm getting the error.. Can you help us?
Please check attached file.

Thanks.

Re: Integrity Error after Alfresco Upgrade

ceeliro — Fri, 08 May 2015 09:34:22 GMT

Perform same procedure than before and also set index.recovery.mode=FULL in the alfresco-global.properties

Re: Integrity Error after Alfresco Upgrade

ceeliro — Fri, 08 May 2015 09:35:19 GMT

Perform same procedure than before and also set index.recovery.mode=FULL in the alfresco-global.properties

Re: Integrity Error after Alfresco Upgrade

s00pa — Wed, 13 May 2015 06:20:00 GMT

I have exactly the same problem running 5.0.d and I've tried removing all solr indexes and reindexing and it makes no difference. A few days ago I was experimenting with 5.0.c and I can't remember seeing this problem back then. I'm trying to figure out now whether to go back to 5.0.c because it looks like 5.0.d has more problems. And to the person suggesting that we need to set index.recovery.mode=FULL, as far as I know, this has been deprecated since Solr took over from Lucene for indexing alfresco.

EDIT: removing and re-adding the users fixes the problem

–
Sean

Re: Integrity Error after Alfresco Upgrade

rjohnson — Wed, 13 May 2015 09:36:21 GMT

I doubt this is anything to do with SOLR. Alfresco seems to be complaining about the storage used value not being set and being mandatory on the users account (note the description Type: Person, Property: sizeCurrent). This will be held in the database somewhere, not SOLR. You can set quota's for peoples account and it looks as if the value for "storage used" is not set and for whatever reason Alfresco requiring it to be set. This could be a difference in defaults or settings during the upgrade.

Fixing this is likely to be tricky because I suspect you will have to update something in the database directly which is always a risk.

I do not know if you are using quotas on user accounts or not, but you might try switching it off in alfresco-global.properties and on each user account and see if that helps.

Re: Integrity Error after Alfresco Upgrade

texano — Thu, 14 May 2015 12:21:47 GMT

Hi,

Tried index.recovery.mode=FULL in the alfresco-global.properties but the problem keeps.. We are in production with this errors..

Anyone know the solution?

Thank you.

Re: Integrity Error after Alfresco Upgrade

texano — Thu, 14 May 2015 16:22:29 GMT

I don't think the problem is related with SOLR too but DB problems. When I delete a user and create it again the problem solves. I guess that the pre-upgrade users don't have sizeCurrent defined or something… and then we create a new user in version 5.0.D the sizeCurrent correct works. sizeCurrent is the size used in user space. Any idea how i can update all users in database with a value for sizeCurrent? We don't use quotas.

Thank you.

Re: Integrity Error after Alfresco Upgrade

andrewlove — Sun, 17 May 2015 20:44:58 GMT

This is an issue in 5.0.d only.

I upgraded directly from 4.2 to 5.0.d and experienced this error both in the SHARE UI and when performing a search. Critically the error causes search to return an empty result set to the user when the error is thrown server-side.

I then performed a migration from 4.2 to 5.0.c and the error was not present. Search worked flawlessly.

For now I am running on 5.0.c.

I cannot use the delete/re-create user workaround suggested here as I use passthru authentication and ldap replication using AD.

Re: Integrity Error after Alfresco Upgrade

texano — Mon, 18 May 2015 10:11:04 GMT

Any solution besides not upgrading to 5.0.D? I cannot downgrade now.. and I cannot lose all the work done in current 5.0.D version..
Anyone know when 5.0.E will be release with a fix for this? Or just a patch

Re: Integrity Error after Alfresco Upgrade

mrogers — Mon, 18 May 2015 10:51:08 GMT

5.0.E is unlikely to be released. The 5.0 code line is finished and 5.1 is in progress. Next community release will probably be 5.1.A.

Re: Integrity Error after Alfresco Upgrade

mrogers — Mon, 18 May 2015 11:02:00 GMT

The issue seems to be a missing mandatory property, so re-indexing is irrelevant. One fix would be to slap a value of zero on the failing person nodes.

Re: Integrity Error after Alfresco Upgrade

texano — Tue, 19 May 2015 00:06:26 GMT

Hi Mrogers,

That's exactly what I'm trying to do, at least until a new release comes out. Can you tell me how i can set sizeCurrent = 0 on all person nodes? I don't know the alfresco "core" enough to perform this task. Tried query the database (postgres) but no luck yet

Thank you.