Page 1 of 1

Why got errors with BLC_SYSTEM_PROPERTY?

Posted: Sat Sep 12, 2015 10:51 pm
by f0987654
The following messages keep showing when execute the ant start script.
Anyone has idea to solve this error?
Thx!!


Code: Select all

[artifact:mvn] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'blStaticAssetViewController': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:663)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:629)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:677)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:548)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:489)
[artifact:mvn]    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
[artifact:mvn]    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
[artifact:mvn]    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
[artifact:mvn]    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[artifact:mvn]    at java.lang.Thread.run(Thread.java:745)
[artifact:mvn] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:362)
[artifact:mvn]    at com.sun.proxy.$Proxy257.getResultList(Unknown Source)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:88)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.cache.AbstractCacheMissAware.getCachedObject(AbstractCacheMissAware.java:181)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl.readSystemPropertyByName(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:95)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:66)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveBooleanSystemProperty(SystemPropertiesServiceImpl.java:200)
[artifact:mvn]    at org.broadleafcommerce.common.util.BLCSystemProperty.resolveBooleanSystemProperty(BLCSystemProperty.java:67)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.getAllowUnnamedImageManipulation(StaticAssetViewController.java:165)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.init(StaticAssetViewController.java:67)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
[artifact:mvn]    ... 30 more
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
[artifact:mvn]    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
[artifact:mvn]    at com.sun.proxy.$Proxy258.prepareStatement(Unknown Source)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
[artifact:mvn]    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1854)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1831)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
[artifact:mvn]    at org.hibernate.loader.Loader.doQuery(Loader.java:899)
[artifact:mvn]    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
[artifact:mvn]    at org.hibernate.loader.Loader.doList(Loader.java:2516)
[artifact:mvn]    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
[artifact:mvn]    at org.hibernate.loader.Loader.list(Loader.java:2324)
[artifact:mvn]    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
[artifact:mvn]    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
[artifact:mvn]    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
[artifact:mvn]    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
[artifact:mvn]    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
[artifact:mvn]    ... 53 more
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn]    at com.sun.proxy.$Proxy123.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
[artifact:mvn]    ... 72 more
[artifact:mvn] [ERROR] 11:40:41 DispatcherServlet - Context initialization failed
[artifact:mvn] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'blStaticAssetViewController': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:663)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:629)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:677)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:548)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:489)
[artifact:mvn]    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
[artifact:mvn]    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
[artifact:mvn]    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
[artifact:mvn]    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[artifact:mvn]    at java.lang.Thread.run(Thread.java:745)
[artifact:mvn] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:362)
[artifact:mvn]    at com.sun.proxy.$Proxy257.getResultList(Unknown Source)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:88)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.cache.AbstractCacheMissAware.getCachedObject(AbstractCacheMissAware.java:181)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl.readSystemPropertyByName(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:95)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:66)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveBooleanSystemProperty(SystemPropertiesServiceImpl.java:200)
[artifact:mvn]    at org.broadleafcommerce.common.util.BLCSystemProperty.resolveBooleanSystemProperty(BLCSystemProperty.java:67)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.getAllowUnnamedImageManipulation(StaticAssetViewController.java:165)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.init(StaticAssetViewController.java:67)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
[artifact:mvn]    ... 30 more
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
[artifact:mvn]    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
[artifact:mvn]    at com.sun.proxy.$Proxy258.prepareStatement(Unknown Source)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
[artifact:mvn]    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1854)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1831)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
[artifact:mvn]    at org.hibernate.loader.Loader.doQuery(Loader.java:899)
[artifact:mvn]    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
[artifact:mvn]    at org.hibernate.loader.Loader.doList(Loader.java:2516)
[artifact:mvn]    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
[artifact:mvn]    at org.hibernate.loader.Loader.list(Loader.java:2324)
[artifact:mvn]    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
[artifact:mvn]    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
[artifact:mvn]    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
[artifact:mvn]    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
[artifact:mvn]    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
[artifact:mvn]    ... 53 more
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn]    at com.sun.proxy.$Proxy123.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
[artifact:mvn]    ... 72 more
[artifact:mvn] Sep 13, 2015 11:40:41 AM org.apache.catalina.core.ApplicationContext log
[artifact:mvn] SEVERE: StandardWrapper.Throwable
[artifact:mvn] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'blStaticAssetViewController': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:663)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:629)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:677)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:548)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:489)
[artifact:mvn]    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
[artifact:mvn]    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
[artifact:mvn]    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
[artifact:mvn]    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[artifact:mvn]    at java.lang.Thread.run(Thread.java:745)
[artifact:mvn] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[artifact:mvn]    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:362)
[artifact:mvn]    at com.sun.proxy.$Proxy257.getResultList(Unknown Source)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:88)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.cache.AbstractCacheMissAware.getCachedObject(AbstractCacheMissAware.java:181)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl.readSystemPropertyByName(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:95)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:66)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveBooleanSystemProperty(SystemPropertiesServiceImpl.java:200)
[artifact:mvn]    at org.broadleafcommerce.common.util.BLCSystemProperty.resolveBooleanSystemProperty(BLCSystemProperty.java:67)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.getAllowUnnamedImageManipulation(StaticAssetViewController.java:165)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.init(StaticAssetViewController.java:67)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
[artifact:mvn]    ... 30 more
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
[artifact:mvn]    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[artifact:mvn]    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
[artifact:mvn]    at com.sun.proxy.$Proxy258.prepareStatement(Unknown Source)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
[artifact:mvn]    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1854)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1831)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
[artifact:mvn]    at org.hibernate.loader.Loader.doQuery(Loader.java:899)
[artifact:mvn]    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
[artifact:mvn]    at org.hibernate.loader.Loader.doList(Loader.java:2516)
[artifact:mvn]    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
[artifact:mvn]    at org.hibernate.loader.Loader.list(Loader.java:2324)
[artifact:mvn]    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
[artifact:mvn]    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
[artifact:mvn]    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
[artifact:mvn]    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
[artifact:mvn]    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
[artifact:mvn]    ... 53 more
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn]    at com.sun.proxy.$Proxy123.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
[artifact:mvn]    ... 72 more
[artifact:mvn] Sep 13, 2015 11:40:41 AM org.apache.catalina.core.StandardContext loadOnStartup
[artifact:mvn] SEVERE: Servlet /admin threw load() exception
[artifact:mvn] java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SYSTEM_PROPERTY
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn]    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn]    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn]    at com.sun.proxy.$Proxy123.prepareStatement(Unknown Source)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
[artifact:mvn]    at com.sun.proxy.$Proxy258.prepareStatement(Unknown Source)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
[artifact:mvn]    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
[artifact:mvn]    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1854)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1831)
[artifact:mvn]    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
[artifact:mvn]    at org.hibernate.loader.Loader.doQuery(Loader.java:899)
[artifact:mvn]    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
[artifact:mvn]    at org.hibernate.loader.Loader.doList(Loader.java:2516)
[artifact:mvn]    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
[artifact:mvn]    at org.hibernate.loader.Loader.list(Loader.java:2324)
[artifact:mvn]    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
[artifact:mvn]    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
[artifact:mvn]    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
[artifact:mvn]    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
[artifact:mvn]    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[artifact:mvn]    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:362)
[artifact:mvn]    at com.sun.proxy.$Proxy257.getResultList(Unknown Source)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:88)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl$1.retrievePersistentObject(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.cache.AbstractCacheMissAware.getCachedObject(AbstractCacheMissAware.java:181)
[artifact:mvn]    at org.broadleafcommerce.common.config.dao.SystemPropertiesDaoImpl.readSystemPropertyByName(SystemPropertiesDaoImpl.java:82)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:95)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveSystemProperty(SystemPropertiesServiceImpl.java:66)
[artifact:mvn]    at org.broadleafcommerce.common.config.service.SystemPropertiesServiceImpl.resolveBooleanSystemProperty(SystemPropertiesServiceImpl.java:200)
[artifact:mvn]    at org.broadleafcommerce.common.util.BLCSystemProperty.resolveBooleanSystemProperty(BLCSystemProperty.java:67)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.getAllowUnnamedImageManipulation(StaticAssetViewController.java:165)
[artifact:mvn]    at org.broadleafcommerce.cms.web.file.StaticAssetViewController.init(StaticAssetViewController.java:67)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[artifact:mvn]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn]    at java.lang.reflect.Method.invoke(Method.java:497)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
[artifact:mvn]    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
[artifact:mvn]    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
[artifact:mvn]    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
[artifact:mvn]    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:663)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:629)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:677)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:548)
[artifact:mvn]    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:489)
[artifact:mvn]    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
[artifact:mvn]    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
[artifact:mvn]    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
[artifact:mvn]    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
[artifact:mvn]    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
[artifact:mvn]    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
[artifact:mvn]    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[artifact:mvn]    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[artifact:mvn]    at java.lang.Thread.run(Thread.java:745)
[artifact:mvn] Sep 13, 2015 11:40:41 AM org.apache.coyote.AbstractProtocol start
[artifact:mvn] INFO: Starting ProtocolHandler ["http-bio-8081"]
[artifact:mvn] Sep 13, 2015 11:40:41 AM org.apache.coyote.AbstractProtocol start
[artifact:mvn] INFO: Starting ProtocolHandler ["http-bio-8444"]


Re: Why got errors with BLC_SYSTEM_PROPERTY?

Posted: Tue Sep 15, 2015 8:32 am
by phillipuniverse
You need to start the 'site' project prior to starting 'admin'.

Re: Why got errors with BLC_SYSTEM_PROPERTY?

Posted: Thu Sep 17, 2015 9:40 am
by f0987654
thx for you reply.
It works!