12-19-2018 03:32 AM
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
01-14-2019 07:40 AM
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
Explore our Alfresco products with the links below. Use labels to filter content by product module.