topic Re: Rescue files/data from Alfresco system in Alfresco Archive

Rescue files/data from Alfresco system

floher — Fri, 26 Apr 2013 08:52:10 GMT

Hi there,I am currently facing a serious problem with our alfresco installation. We were using alfresco for a time period of about 2 years. The only feature we made use of was the file storage of alfresco share. Due to different reasons we have to change our system and we are not able to use alfresc

Re: Rescue files/data from Alfresco system

afaust — Fri, 26 Apr 2013 12:57:34 GMT

Hello,

just a quick question: The problem about login your describing sounds like you've tried with /share. Please try to login to /alfresco which should always work as long as your Alfresco still starts up. From there you are able to browse and export the stored content as well, just in a different UI.

Have you tried deinstalling the "Bulk Export" plugin?

If even your Alfresco Repository server does not start up, you can use the database tables alf_node, alf_child_assoc, alf_qname and alf_node_properties to reconstruct a minimal folder-document hierarchy. Use alf_content_data / alf_content_url to retrieve the actual path of a document in the file content store.

Regards
Axel

Re: Rescue files/data from Alfresco system

floher — Sun, 28 Apr 2013 13:31:32 GMT

Hi,

yes I tried to login into /share. But if I try to open /alfresco I get the following message:

type Status report

message /alfresco/

description The requested resource (/alfresco/) is not available.

How can I get /alfresco running, this would be perfectly enough for me. Regarding your second advice, I already thought about recovering my data like this, but I did not manage to get any relation from the tables alf_content_data and alf_content_url to the alf_node tables. The uuids are not really matching and I tried to loop through the alf_data dir and to get for each file the corresponding information of alf_content and alf_node tables but I am missing the relation.

Thank you so far,
best regards, Florian Herborn

Re: Rescue files/data from Alfresco system

afaust — Tue, 30 Apr 2013 16:01:58 GMT

Hello,

how to get /alfresco running depends on the kind of errors you receive. If you could post your logfile of Alfresco (alfresco.log / catalina.out) we could take a look and point you in the right direction.

The relation to content can be obtained by associating alf_node with alf_node_properties via id = node_id and associating alf_node_properties with alf_content_data via long_value = id (for those entries where alf_node_properties associated with alf_qname via qname_id = id has a local_name of "content"). Or to express it in SQL


select * from alf_node left join alf_node_properties on alf_node.id = alf_node_properties.node_id left join alf_content_data on alf_node_properties.long_value = alf_content_data.id left join alf_qname as propQName on propQName.id = alf_node_properties.qname_id left join alf_qname as typeQName on typeQName.id = alf_node.type_qname_id left join alf_content_url on alf_content_data.content_url_id = alf_content_url.id where typeQName.local_name = "content" and propQName.local_name = "content";
‍‍‍

Now you obviously still need the name of a file object, but this requires just a simple adjustment…

Regards
Axel

Re: Rescue files/data from Alfresco system

g_rathod — Mon, 06 May 2013 12:01:16 GMT

Axel is right,
Unless specific error in log file we can't measure the problem you are facing.
First try to up alfresco client instead /share.

Please post your error which is appear in log. (Full log)