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
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
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.