Alfresco doesn't support two schema

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

unknown-user

Hi All

Can anybuddy please tell me why alfresco doesn't support two schema for a port in DataBase?

Let me explain what I am asking. I created one schema 'alfresco' in PostgreSQL database.
I started the server. It's create 65 alfresco tables in this schema. I renamed this schema for example 'myschema'.
Then again I create one schema 'alfresco'  and again I start the server this time it creates one table 'alf_bootstrap_lock' in this new schema and it shows error 'schema auto updated failed. alf_bootstrap_lock patches not available'. I deleted this table and again I restarted the server then also it's create this table 'alf_bootstrap_lock' .

If I delete table 'alf_bootstrap_lock'  from alfresco and also delete the other existing schema 'myschema'.
Now I have only one schema in PostgreSQL database that is alfresco. If I start the server then it deploy successfully alfresco.war and it creates 65 tables in alfresco schema.

Any help highly appreciated.

Regards
Nishant

mikeh

Before starting the second time, clear out the alf_data folder.

We use multiple database schemas here as developers (albeit MySQL instead of PostgreSQL) so we can work on multiple versions at the same time - but there shouldn't be any difference.


Mike