topic Re: After restarting Alfresco 5.2.3 i have some folder corrupted in Alfresco Forum

After restarting Alfresco 5.2.3 i have some folder corrupted

massimo_gandolf — Wed, 05 Feb 2020 08:40:00 GMT

Hi all,

I'm Massimo and I'm new in the forum then I'm sorry if my English is not undertandable or if I'm not clear exposing the problem;

I have an installation of Alfresco 5.2.3; sometime ofter a restart due to a problem, I found that the chain of the objects in alf_child_assoc is broken loosing many child objects; I try to explain better with an example:

my repository has this structure

root

folder1

sub1a

sub1b

sub1c

sub1d

sub1e

folder2

sub2a

sub2b

sub2c

sub2d

sub2e

.....

after the restart I can have some folderx tree broken, like

root

folder1

sub1a

sub1b

sub1c

sub1d

sub1e

folder2

sub2a

sub2b

.....

if a make a query on db in table alf_chiald_assoc i can found only Sub2a and Sub2b, but I have loose the others...

there is a way to rebuild the structureor to find the child loosed?

thanks for all suggestions

Regards

Massimo

Re: After restarting Alfresco 5.2.3 i have some folder corrupted

heiko_robert — Wed, 05 Feb 2020 20:25:56 GMT

It looks like you have a DB problem.

Alfresco relies on the transaction skills of the database. If nodes in Alfresco disappear after a restart, it means that either a pending / incomplete transaction has been rolled back or your database has a problem.

Which db product are you using? Does it run on the same system that Alfresco is running on?

Re: After restarting Alfresco 5.2.3 i have some folder corrupted

massimo_gandolf — Thu, 06 Feb 2020 08:18:26 GMT

Hi Robert,

Our Alfresco works on Oracle 11Db; we communicate with repository via Cmis 1.1.

there is a tool that can make some check on db consistency or someone else that permit to understand if oud db doesn't work well?

thanks

Massimo

Re: After restarting Alfresco 5.2.3 i have some folder corrupted

afaust — Thu, 06 Feb 2020 11:49:27 GMT

Did you already get into contact with Alfresco Support? Since this is an Enterprise version using a DB only supported in Enterprise, and the issue (corruption) is a serious one, you should get them involved as soon as possible.

Re: After restarting Alfresco 5.2.3 i have some folder corrupted

massimo_gandolf — Thu, 13 Feb 2020 09:06:10 GMT

thanks for response.

i will try with alfresco support

Massimo