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.