By reading 4.3.1 oozie source code, I solved the problem by adding oozie.service.JPAService.validate.db.connection": "false". Thanks.
On Wed, Aug 8, 2018 at 3:49 PM, Lian Jiang <jiangok2...@gmail.com> wrote: > Thanks Peter. I attached sanitized /etc/oozie/3.0.0.0-1634/0/oozie-site.xml. > Please let me know if you see any issue. > > On Mon, Jul 30, 2018 at 1:23 AM, Peter Cseh <gezap...@cloudera.com.invalid > > wrote: > >> Hi! >> >> I'm not familiar with the details of HDP, but based on the error message >> your xml is not well formatted. >> >> Based on the code: >> https://github.com/apache/oozie/blob/master/core/src/main/ >> java/org/apache/oozie/service/JPAService.java#L198 >> the issue is in your driver classname or url for the jdbc. >> Please check the generated xml files, or share them after removing >> confidential information. >> >> All the best, >> gp >> >> >> On Sun, Jul 29, 2018 at 7:24 PM Lian Jiang <jiangok2...@gmail.com> wrote: >> >> > Hi, >> > >> > I am installing HDP3.0 using ambari 2.7. OOZIE failed to start due to >> below >> > error: >> > >> > >> > 2018-07-29 06:21:27,402 WARN ConfigurationService:523 - SERVER[ >> > prod-namenode.subnet1.hadoop.oraclevcn.com] Invalid configuration >> defined, >> > [credentialStoreClassPath] >> > 2018-07-29 06:21:27,406 WARN Services:523 - SERVER[ >> > prod-namenode.subnet1.hadoop.oraclevcn.com] System ID [oozie-oozi] >> exceeds >> > maximum length [10], trimming >> > 2018-07-29 06:21:27,631 WARN ConfigUtils:523 - SERVER[ >> > prod-namenode.subnet1.hadoop.oraclevcn.com] Using a deprecated >> > configuration property >> > [oozie.service.AuthorizationService.security.enabled], should use >> > [oozie.service.AuthorizationService.authorization.enabled]. Please >> delete >> > the deprecated property in order for the new property to take effect. >> > 2018-07-29 06:21:28,551 FATAL Services:514 - SERVER[ >> > prod-namenode.subnet1.hadoop.oraclevcn.com] Runtime Exception during >> > Services Load. Check your list of 'oozie.services' or >> 'oozie.services.ext' >> > 2018-07-29 06:21:28,558 FATAL Services:514 - SERVER[ >> > prod-namenode.subnet1.hadoop.oraclevcn.com] E0103: Could not load >> service >> > classes, Unmatched braces in the pattern. >> > org.apache.oozie.service.ServiceException: E0103: Could not load >> service >> > classes, Unmatched braces in the pattern. >> > at >> > org.apache.oozie.service.Services.loadServices(Services.java:309) >> > at org.apache.oozie.service.Services.init(Services.java:213) >> > at >> > >> > org.apache.oozie.servlet.ServicesLoader.contextInitialized(S >> ervicesLoader.java:46) >> > at >> > >> > org.apache.catalina.core.StandardContext.listenerStart(Stand >> ardContext.java:4276) >> > at >> > org.apache.catalina.core.StandardContext.start(StandardConte >> xt.java:4779) >> > at >> > >> > org.apache.catalina.core.ContainerBase.addChildInternal(Cont >> ainerBase.java:803) >> > at >> > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:780) >> > at >> > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) >> > at >> > >> > org.apache.catalina.startup.HostConfig.deployDescriptor(Host >> Config.java:676) >> > at >> > >> > org.apache.catalina.startup.HostConfig.deployDescriptors(Hos >> tConfig.java:602) >> > at >> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:503) >> > at >> > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) >> > at >> > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostCo >> nfig.java:325) >> > at >> > >> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent >> (LifecycleSupport.java:142) >> > at >> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1069) >> > at >> > org.apache.catalina.core.StandardHost.start(StandardHost.java:822) >> > at >> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) >> > at >> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) >> > at >> > org.apache.catalina.core.StandardService.start(StandardServi >> ce.java:525) >> > at >> > org.apache.catalina.core.StandardServer.start(StandardServer.java:761) >> > at org.apache.catalina.startup.Catalina.start(Catalina.java:595 >> ) >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > at >> > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >> ssorImpl.java:62) >> > at >> > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java: >> 289) >> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:41 >> 4) >> > Caused by: java.lang.IllegalArgumentException: Unmatched braces in the >> > pattern. >> > at java.text.MessageFormat.applyPattern(MessageFormat.java:508) >> > at java.text.MessageFormat.<init>(MessageFormat.java:362) >> > at java.text.MessageFormat.format(MessageFormat.java:840) >> > at org.apache.oozie.service.JPAService.init(JPAService.java: >> 197) >> > at >> > org.apache.oozie.service.Services.setServiceInternal(Services.java:386) >> > at org.apache.oozie.service.Services.setService(Services.java: >> 372) >> > at >> > org.apache.oozie.service.Services.loadServices(Services.java:305) >> > ... 26 more >> > >> > >> > >> > My oozie settings which worked in HDP2.6 is: >> > >> > { >> > "oozie-site": { >> > "properties": { >> > "oozie.service.JPAService.jdbc.username": "admin", >> > "oozie.service.JPAService.jdbc.password": >> "%SERVICE_PASSWORD%", >> > "oozie.email.from.address": "had...@something.com", >> > "oozie.email.smtp.auth": "Yes", >> > "oozie.email.smtp.host": "localhost", >> > "oozie.email.smtp.username": "admin", >> > "oozie.email.smtp.password": "%EMAIL_PASSWORD%" >> > } >> > } >> > } >> > >> > Any idea? Thanks for any hints. >> > >> >> >> -- >> *Peter Cseh *| Software Engineer >> cloudera.com <https://www.cloudera.com> >> >> [image: Cloudera] <https://www.cloudera.com/> >> >> [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: >> Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: >> Cloudera >> on LinkedIn] <https://www.linkedin.com/company/cloudera> >> ------------------------------ >> > >