More than one Alfresco schema- on export/restore DB

cancel
Showing results for 
Search instead for 
Did you mean: 
dharmendra_pan2
Active Member II

More than one Alfresco schema- on export/restore DB

I am moving alfresco database from Oracle to MySQL AWS, Performed export and import of database and content store using cold backup procedure.

I am getting the below error message when trying to start application server- we have set schema update to false in global properties file.

More than one Alfresco schema was found when querying the database metadata. Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.

There is something wrong or need to be changed at database side which I think easy to fix if you have good knowledge of MySQL. 

why alfresco thinks that there are more than on Alfresco schema when my database contains only one schema.

-D

1 Reply
dharmendra_pan2
Active Member II

Re: More than one Alfresco schema- on export/restore DB

Solution : In mySQL schema and tables name were in uppar case so it was showing error message More than one Alfresco schema was found.

Alfresco started perfectly fine when I converted schema/database and tables name to lower case.

-D