Facing problem in POSTGRESQL installation for Hybris 6.4 vanilla Suite

[Former Member]

Trying to initilaize the 6.4 suite with Psotgresql db ..getting JaloInternalException and JaloSystemException Postgresql version :9.2.15 DB driver version :postgresql-9.4.1207

Have not done any additional configurations as such for Postgres.

Question 1 : Does Hybris 6.4 suppport Posrgresql? Question 2 : Is there any additional Configurations to be done?

Stack trace Unknown error notifying listener de.hybris.platform.cronjob.jalo.CronJobManager$CronJobTenantListener@269fe822 on tenant master startup : JaloSession.jaloSession(): no active currency in system de.hybris.platform.jalo.JaloInternalException: JaloSession.jaloSession(): no active currency in system[HY-0].. at de.hybris.platform.jalo.c2l.C2LManager$5.compute(C2LManager.java:425). at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305). at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278). at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180). at de.hybris.platform.jalo.c2l.C2LManager$C2LCacheUnit.getCached(C2LManager.java:1122). at de.hybris.platform.jalo.c2l.C2LManager.getDefaultCurrencyForTenant(C2LManager.java:432). at de.hybris.platform.jalo.JaloSession.getInitialSessionCurrency(JaloSession.java:420). at de.hybris.platform.jalo.JaloSession.initSessionContext(JaloSession.java:374)SEVERE: Servlet.service() for servlet [springmvc] in context with path [] threw exception [Error while processing internal filterchain. Exception occurred at chain position: 4 of 7. Current filter: 'de.hybris.platfo at de.hybris.platform.jalo.JaloSession.createInstance(JaloSession.java:249)de.hybris.platform.jalo.JaloInternalException: JaloSession.jaloSession(): no active currency in system[HY-0] at de.hybris.platform.jalo.JaloConnection.createSession(JaloConnection.java:752) at de.hybris.platform.jalo.c2l.C2LManager$5.compute(C2LManager.java:425) at de.hybris.platform.jalo.JaloConnection.createAnonymousCustomerSession(JaloConnection.java:664) at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) at de.hybris.platform.jalo.JaloConnection.createAnonymousCustomerSession(JaloConnection.java:646) at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) at de.hybris.platform.jalo.JaloSession.getCurrentSession(JaloSession.java:851) at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) at de.hybris.platform.jalo.Item.getSession(Item.java:1607) at de.hybris.platform.jalo.c2l.C2LManager$C2LCacheUnit.getCached(C2LManager.java:1122) at de.hybris.platform.jalo.ExtensibleItem.getProperty(ExtensibleItem.java:308) at de.hybris.platform.jalo.c2l.C2LManager.getDefaultCurrencyForTenant(C2LManager.java:432) at de.hybris.platform.jalo.type.RelationDescriptor.getRelationType(RelationDescriptor.java:90) at de.hybris.platform.jalo.JaloSession.getInitialSessionCurrency(JaloSession.java:420) at de.hybris.platform.jalo.type.ComposedType$DescriptorsCache.(ComposedType.java:491) at de.hybris.platform.jalo.JaloSession.initSessionContext(JaloSession.java:374) at de.hybris.platform.jalo.type.ComposedType$1.compute(ComposedType.java:627) at de.hybris.platform.jalo.JaloSession.createInstance(JaloSession.java:249) at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) at de.hybris.platform.jalo.JaloConnection.createSession(JaloConnection.java:752) at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) at de.hybris.platform.jalo.JaloConnection.createAnonymousCustomerSession(JaloConnection.java:664) at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) at de.hybris.platform.jalo.JaloConnection.createAnonymousCustomerSession(JaloConnection.java:646) at de.hybris.platform.jalo.JaloTypeCacheUnit.getCached(JaloTypeCacheUnit.java:83) at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.createNewSession(DefaultSessionService.java:74) at de.hybris.platform.jalo.type.ComposedType.getDescriptorsCache(ComposedType.java:629) at de.hybris.platform.servicelayer.web.SessionFilter.createNewJaloSession(SessionFilter.java:237) at de.hybris.platform.jalo.type.ComposedType.getAttributeDescriptorIncludingPrivate(ComposedType.java:1034) at de.hybris.platform.servicelayer.web.SessionFilter.activateSession(SessionFilter.java:224) at de.hybris.platform.task.impl.DefaultTaskService.checkSystemOK(DefaultTaskService.java:524) at de.hybris.platform.servicelayer.web.SessionFilter.doFilter(SessionFilter.java:92) at de.hybris.platform.task.impl.DefaultTaskService$2.run(DefaultTaskService.java:547) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) at de.hybris.platform.task.impl.DefaultTaskService.waitAndRunExclusiveAction(DefaultTaskService.java:799) at de.hybris.platform.servicelayer.web.RedirectWhenSystemIsNotInitializedFilter.doFilter(RedirectWhenSystemIsNotInitializedFilter.java:101) at de.hybris.platform.task.impl.DefaultTaskService.init(DefaultTaskService.java:542) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) at de.hybris.platform.task.impl.DefaultTaskService$1.start(DefaultTaskService.java:168) at de.hybris.platform.servicelayer.web.Log4JFilter.doFilter(Log4JFilter.java:44) at de.hybris.platform.cronjob.jalo.CronJobManager.startTaskEngine(CronJobManager.java:1879) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) at de.hybris.platform.cronjob.jalo.CronJobManager$CronJobTenantListener.afterTenantStartUp(CronJobManager.java:174) at de.hybris.platform.servicelayer.web.session.HybrisSpringSessionFilter.doFilter(HybrisSpringSessionFilter.java:69) at de.hybris.platform.core.AbstractTenant.executeStartupNotifyIfNecessary(AbstractTenant.java:911) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) at de.hybris.platform.core.AbstractTenant.executeInitsIfNecessary(AbstractTenant.java:1388) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain.processStandardFilterChain(AbstractPlatformFilterChain.java:201) at de.hybris.platform.core.Registry.assureTenantStarted(Registry.java:668) at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain.doFilterInternal(AbstractPlatformFilterChain.java:179) at de.hybris.platform.core.Registry.activateTenant(Registry.java:709) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at de.hybris.platform.core.Registry.setCurrentTenant(Registry.java:556) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at de.hybris.platform.tx.DefaultAfterSaveListenerRegistry$AfterSaveEventPublisherThread.internalRun(DefaultAfterSaveListenerRegistry.java:260) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:135) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at de.hybris.platform.servicelayer.web.XSSFilter.processPatternsAndDoFilter(XSSFilter.java:358) at de.hybris.platform.servicelayer.web.XSSFilter.doFilter(XSSFilter.java:306) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) .. .. .. .. .. de.hybris.platform.jalo.JaloSystemException: org.springframework.jdbc.BadSqlGrammarException: query; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "ON" Position: 162 at de.hybris.platform.persistence.GenericItemEJBImpl.createGenericItem(GenericItemEJBImpl.java:125) ~[coreserver.jar:?] at de.hybris.platform.jalo.GenericItem.createItem(GenericItem.java:87) ~[coreserver.jar:?] at de.hybris.platform.jalo.c2l.Currency.createItem(Currency.java:105) ~[coreserver.jar:?] at de.hybris.platform.jalo.Item.newInstanceInternal(Item.java:4124) ~[coreserver.jar:?] at de.hybris.platform.jalo.Item.access$6(Item.java:4065) ~[coreserver.jar:?] at de.hybris.platform.jalo.Item$19.execute(Item.java:4043) ~[coreserver.jar:?] at de.hybris.platform.tx.Transaction.execute(Transaction.java:1190) ~[coreserver.jar:?] at de.hybris.platform.tx.Transaction.execute(Transaction.java:1155) ~[coreserver.jar:?] at de.hybris.platform.jalo.Item.newInstance(Item.java:4038) ~[coreserver.jar:?] at de.hybris.platform.jalo.type.ComposedType.newInstance(ComposedType.java:1337) ~[coreserver.jar:?] at de.hybris.platform.jalo.type.ComposedType.newInstance(ComposedType.java:128) ~[coreserver.jar:?] at de.hybris.platform.jalo.type.ComposedType.newInstance(ComposedType.java:182) ~[coreserver.jar:?] at de.hybris.platform.jalo.c2l.C2LManager.createCurrency(C2LManager.java:524) ~[coreserver.jar:?] at de.hybris.platform.jalo.c2l.C2LManager.createCurrency(C2LManager.java:502) ~[coreserver.jar:?] at de.hybris.platform.core.systemsetup.datacreator.impl.C2LDataCreator.createOrGetCurrency(C2LDataCreator.java:101) ~[coreserver.jar:?] at de.hybris.platform.core.systemsetup.datacreator.impl.C2LDataCreator.createDefaultCurrency(C2LDataCreator.java:77) ~[coreserver.jar:?] at de.hybris.platform.core.systemsetup.datacreator.impl.C2LDataCreator.populateDatabase(C2LDataCreator.java:43) ~[coreserver.jar:?] at de.hybris.platform.core.systemsetup.CoreSystemSetup.createEssentialData(CoreSystemSetup.java:58) [coreserver.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_20] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_20] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_20] at java.lang.reflect.Method.invoke(Method.java:483) ~[?:1.8.0_20] at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:216) [spring-core-4.3.3.RELEASE.jar:4.3.3.RELEASE] at de.hybris.platform.core.initialization.impl.SystemSetupCollectorImpl.invokeSystemSetupMethod(SystemSetupCollectorImpl.java:336) [coreserver.jar:?] at de.hybris.platform.core.initialization.impl.SystemSetupCollectorImpl.executeMethods(SystemSetupCollectorImpl.java:285) [coreserver.jar:?] at de.hybris.platform.core.Initialization.createEssentialData(Initialization.java:985) [coreserver.jar:?] at de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:574) [coreserver.jar:?] at de.hybris.platform.core.Initialization.access$5(Initialization.java:465) [coreserver.jar:?] at de.hybris.platform.core.Initialization$5.call(Initialization.java:786) [coreserver.jar:?] at de.hybris.platform.core.Initialization$5.call(Initialization.java:1) [coreserver.jar:?] at de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:80) [coreserver.jar:?] at de.hybris.platform.core.Initialization.doInitialize(Initialization.java:818) [coreserver.jar:?] at de.hybris.ant.taskdefs.InitPlatformAntPerformableImpl.performImpl(InitPlatformAntPerformableImpl.java:106) [coreserver.jar:?] at de.hybris.ant.taskdefs.AbstractAntPerformable.doPerform(AbstractAntPerformable.java:92) [coreserver.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_20] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_20] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_20] at java.lang.reflect.Method.invoke(Method.java:483) ~[?:1.8.0_20] at bsh.Reflect.invokeMethod(Reflect.java:134) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.Reflect.invokeObjectMethod(Reflect.java:80) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.Name.invokeMethod(Name.java:858) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.Interpreter.eval(Interpreter.java:645) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.Interpreter.eval(Interpreter.java:739) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at bsh.Interpreter.eval(Interpreter.java:728) [bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41] at de.hybris.platform.util.ClientExecuter.execute(ClientExecuter.java:49) [coreserver.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_20] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_20] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_20] at java.lang.reflect.Method.invoke(Method.java:483) ~[?:1.8.0_20] at de.hybris.bootstrap.loader.Loader.execute(Loader.java:142) [ybootstrap.jar:?] at de.hybris.bootstrap.loader.Loader.main(Loader.java:118) [ybootstrap.jar:?]

[former_member623977 · Accepted solution]

@Naveen - Postgresql DB is not supported by Hybris. Please check the third party comparability - https://help.hybris.com/6.4.0/hcd/8c71300f866910149b40c88dfc0de431.html