topic [Resolved]: Schema auto-update failed in Alfresco Archive

[Resolved]: Schema auto-update failed

unknown-user — Thu, 05 Feb 2009 14:16:54 GMT

Dear All I am doing fresh installation of alfresco 2.9.0B . I am unable to deploy alfresco.war. I am getting Schema auto-update failed error. It creates one table alf_bootstrap_lock in alfresco schema. I deleted this table and restarted the server then also i am getting the same error. I am getting

Re: [Resolved]: Schema auto-update failed

unknown-user — Fri, 06 Feb 2009 08:48:23 GMT

As I had the backup(db backup & alf_data) of alfresco2.1, I used this backup and deployed alfresco.war (from alfresc2.9.0B).
Now it's working but when I deploy alfresco.war(from alfresco2.1 or alfresco2.9.0B) without backup then I am getting error which you can see in my previous post.

Please correct me if i am wrong. Kindly help me.

Regards
Nishant

Re: [Resolved]: Schema auto-update failed

abhishek385 — Fri, 06 Feb 2009 10:29:14 GMT

Hi Nishant,

Please refer to this link see if it helps.

http://forums.alfresco.com/en/viewtopic.php?f=9&t=13093&start=0&st=0&sk=t&sd=a

Re: [Resolved]: Schema auto-update failed

unknown-user — Fri, 06 Feb 2009 10:53:10 GMT

Hi Abhishek

Thanks for the response.

Actualy when I started using alfresco 2.1 that time also i faced this problem and that time as I remember I deleted the alf_bootstrap_lock table from the database and restarted the server. After this server was working fine.
Now I am facing this issue for both alfresco2.1 and 2.9.0B during first time deployment with new schema.

Regards
Nishant

Re: [Resolved]: Schema auto-update failed

unknown-user — Fri, 06 Feb 2009 13:01:02 GMT

Hi All

I have resolved this issue.
You can create any number of schema but if any other schema contains alfresco tables(didn't test for other tables) then it'll not work.

Regards
Nishant

Re: [Resolved]: Schema auto-update failed

abhishek385 — Fri, 06 Feb 2009 15:52:16 GMT

Thas really a good find. I am also not very experienced in Alfresco just started playing with it few days ago..I will definitely find out more about what you mentioned and share my experience.