topic Re: Alfresco 4.2c unable to start in Alfresco Archive

Alfresco 4.2c unable to start

vikrant — Fri, 01 Feb 2013 12:09:23 GMT

2013-02-01 17:21:32,303 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Replication' subsystem, ID: [Replication, default] complete 2013-02-01 17:21:34,647 ERROR [web.context.ContextLoader] [localhost-startStop-1] Context initialization failed java

Re: Alfresco 4.2c unable to start

bisana — Fri, 01 Feb 2013 15:56:02 GMT

Check ur database connection
Also when u post give more information, such as is it fresh installation or upgradation

Re: Alfresco 4.2c unable to start

juddm — Wed, 10 Jul 2013 17:11:00 GMT

I had the same problem when I changed a dynamic model. After shutting tomcat down I found I was unable to restart. No doubt a problem with my model but I quickly found myself in a catch 22 as I was unable to delete the model because I was unable to start tomcat. Little information is available in order to delete the model from the db directly - so I'm a little lost as to possible next steps other than to start from scratch.

Anyone got any ideas or did vikrant solve this issue ?

It doesn't seem to be a very good idea to use dynamic models when prototyping. see: http://forums.alfresco.com/forum/general/non-technical-alfresco-discussion/changing-dynamic-models-01292009-1058

Mike

Re: Alfresco 4.2c unable to start

juddm — Wed, 10 Jul 2013 18:40:10 GMT

I found a solution to this problem which was deleting the object from the database. I am on the postgresql - so if anyone stumbles upon this thread - here is what worked for me. Given the lack of documentation and my experience with Alfresco - I'd recommend only following this if you are desperately stuck!

1. Make a backup of the database - in case something goes wrong


pg_dump alfresco -U alfresco -h localhost > ~/alfresco-backup.sql
‍‍‍

You can restore this later if needed by the following:


psql -U postgres -h localhost
drop database alfresco;
create database alfresco;
alter database alfresco owner to alfresco;
\q

psql -d alfresco -U alfresco -h localhost < ~/alfresco-backup.sql
‍‍‍‍‍‍‍‍‍

2. Find the problem content type

My assumption based on my experience was this was caused by a problem dynamic model. I found in table alf_qname that "dictionaryModel" was id 317. So I search my alf_node for type_qname_id = 317


select * from alf_node where type_qname_id in (317);
‍‍‍

3. Delete all child / related records


delete from alf_node_assoc where target_node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_node_aspects where node_id in (select id from alf_node where type_qname_id in (317));
delete from alf_child_assoc where parent_node_id in (select id from alf_node where type_qname_id in (317)); 
delete from alf_node_properties where node_id in (select id from alf_node where type_qname_id in (317));
‍‍‍‍‍‍

and finally:


delete from alf_node where type_qname_id in (317);
‍‍‍

Hopefully, this will get you out of a hole if you need it.

Regards,

Mike

Re: Alfresco 4.2c unable to start

bisana — Thu, 11 Jul 2013 04:32:46 GMT

Thanks Mike
I am going to book mark this post