EMR fails to come up on first start ever since upgrade to 3.4.1

System Issues
1

KHC fails to come up the first start displaying the error below. on doing a second restart the modules have got to be started manually. this started happening after the version upgrade to 3.4.1 from 3.3.7.

groovy.lang.MissingPropertyException: No such property: healthCenter for class: SimpleTemplateScript1
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:53)
at org.codehaus.groovy.runtime.callsite.PogoGetPropertySite.getProperty(PogoGetPropertySite.java:52)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGroovyObjectGetProperty(AbstractCallSite.java:307)
at SimpleTemplateScript1.run(SimpleTemplateScript1.groovy:272)
at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:187)
at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:116)
at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:117)
at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

2

Hello @jls, kindly run this script in MySQL on the Openmrs database and restart the server.

ALTER TABLE htmlformentry_html_form CONVERT TO CHARACTER SET UTF8;
ALTER TABLE serialized_object CONVERT TO CHARACTER SET UTF8;