Query Exception at first Start

[Omer Ilhan, modificado 9 Anos atrás.]

Hi,
I've downloaded 6.2.2 and 6.2.1 versions and did nothing but start the tomcat instance. Tomcat instance starts and configuration wizard appears but following lines are in the tomcat log. Is this a problem or can i use it anyways? or how can i fix it.

12:03:19,984 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyBookmarks
12:03:19,987 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyCalendar
12:03:19,990 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
12:03:20,070 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyDynamicDataMapping
12:03:20,072 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyGroupId
12:03:20,073 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyJournal
12:03:20,080 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyLayout
12:03:20,087 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyMessageBoards
12:03:20,094 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyOrganization
12:03:20,099 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyResourcePermissions
12:03:20,100 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyUser
12:03:20,104 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyWiki
12:03:20,107 INFO [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyWorkflow
12:03:20,137 INFO [localhost-startStop-1][ServerDetector:119] Server supports hot deploy
12:03:20,141 INFO [localhost-startStop-1][PluginPackageUtil:1013] Reading plugin package for the root context
12:03:46,398 INFO [localhost-startStop-1][AutoDeployDir:116] Creating missing directory G:\liferay-portal-6.2-ce-ga2\deploy
12:03:46,400 INFO [localhost-startStop-1][AutoDeployDir:139] Auto deploy scanner started for G:\liferay-portal-6.2-ce-ga2\deploy
12:03:51,022 ERROR [localhost-startStop-1][PortalInstances:484] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT resourcePermission FROM com.liferay.portal.model.impl.ResourcePermissionImpl resourcePermission WHERE resourcePermission.companyId = ? AND resourcePermission.primKey LIKE ? ORDER BY resourcePermission.resourcePermissionId ASC]
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT resourcePermission FROM com.liferay.portal.model.impl.ResourcePermissionImpl resourcePermission WHERE resourcePermission.companyId = ? AND resourcePermission.primKey LIKE ? ORDER BY resourcePermission.resourcePermissionId ASC]
at com.liferay.portal.events.AddDefaultLayoutSetPrototypesAction.run(AddDefaultLayoutSetPrototypesAction.java:47)
at com.liferay.portal.events.AddDefaultDataAction.run(AddDefaultDataAction.java:40)
at com.liferay.portal.events.EventsProcessorImpl.processEvent(EventsProcessorImpl.java:108)
at com.liferay.portal.events.EventsProcessorImpl.process(EventsProcessorImpl.java:59)
at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:53)
at com.liferay.portal.util.PortalInstances._initCompany(PortalInstances.java:478)
at com.liferay.portal.util.PortalInstances.initCompany(PortalInstances.java:90)
at com.liferay.portal.servlet.MainServlet.initCompanies(MainServlet.java:762)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:336)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT resourcePermission FROM com.liferay.portal.model.impl.ResourcePermissionImpl resourcePermission WHERE resourcePermission.companyId = ? AND resourcePermission.primKey LIKE ? ORDER BY resourcePermission.resourcePermissionId ASC]
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:251)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.findByC_LikeP(ResourcePermissionPersistenceImpl.java:1494)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.findByC_LikeP(ResourcePermissionPersistenceImpl.java:1348)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.deleteLayout(LayoutLocalServiceImpl.java:651)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.deleteLayouts(LayoutLocalServiceImpl.java:760)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.invoke(LayoutLocalServiceVirtualLayoutsAdvice.java:180)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice.invoke(LayoutLocalServiceStagingAdvice.java:141)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy32.deleteLayouts(Unknown Source)
at com.liferay.portal.service.LayoutLocalServiceUtil.deleteLayouts(LayoutLocalServiceUtil.java:624)
at com.liferay.portal.events.AddDefaultLayoutSetPrototypesAction.addLayoutSetPrototype(AddDefaultLayoutSetPrototypesAction.java:79)
at com.liferay.portal.events.AddDefaultLayoutSetPrototypesAction.addPublicSite(AddDefaultLayoutSetPrototypesAction.java:196)
at com.liferay.portal.events.AddDefaultLayoutSetPrototypesAction.doRun(AddDefaultLayoutSetPrototypesAction.java:251)
at com.liferay.portal.events.AddDefaultLayoutSetPrototypesAction.run(AddDefaultLayoutSetPrototypesAction.java:44)
... 26 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT resourcePermission FROM com.liferay.portal.model.impl.ResourcePermissionImpl resourcePermission WHERE resourcePermission.companyId = ? AND resourcePermission.primKey LIKE ? ORDER BY resourcePermission.resourcePermissionId ASC]
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:92)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:77)
at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.createQuery(ClassLoaderSession.java:110)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.findByC_LikeP(ResourcePermissionPersistenceImpl.java:1464)
... 66 more
Caused by: org.hibernate.QueryException: Incorrect query syntax [SELECT resourcePermission FROM com.liferay.portal.model.impl.ResourcePermissionImpl resourcePermission WHERE resourcePermission.companyId = ? AND resourcePermission.primKey LIKE ? ORDER BY resourcePermission.resourcePermissionId ASC]
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:256)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:209)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:88)
... 69 more
Caused by: java.util.NoSuchElementException
at java.util.LinkedList.getLast(LinkedList.java:122)
at org.hibernate.hql.classic.WhereParser.closeExpression(WhereParser.java:328)
at org.hibernate.hql.classic.WhereParser.token(WhereParser.java:270)
at org.hibernate.hql.classic.WhereParser.end(WhereParser.java:310)
at org.hibernate.hql.classic.ClauseParser.endChild(ClauseParser.java:122)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:76)
at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:131)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:51)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:240)
... 77 more
12:04:29,472 INFO [http-bio-8080-exec-1][HotDeployEvent:130] Plugin calendar-portlet requires marketplace-portlet
12:04:29,473 INFO [http-bio-8080-exec-1][HotDeployImpl:252] Queueing calendar-portlet for deploy because it is missing marketplace-portlet
12:04:29,578 INFO [http-bio-8080-exec-1][HotDeployEvent:130] Plugin kaleo-web requires marketplace-portlet
12:04:29,579 INFO [http-bio-8080-exec-1][HotDeployImpl:252] Queueing kaleo-web for deploy because it is missing marketplace-portlet
12:04:29,679 INFO [http-bio-8080-exec-1][HotDeployEvent:130] Plugin notifications-portlet requires marketplace-portlet
12:04:29,679 INFO [http-bio-8080-exec-1][HotDeployImpl:252] Queueing notifications-portlet for deploy because it is missing marketplace-portlet

[Aditya Bhardwaj, modificado 9 Anos atrás.]

Hi,

can you plz tell

1)Which OS are you using Linux or windows?
2)Which database Mysql or oracle?

If you are using default hypersonic please try to connect with mysql.

[Olgun YILDIZ, modificado 8 Anos atrás.]

You need to add -Dfile.encoding=UTF8 parameter in tomcat VM arguments

[fatih guleryuz, modificado 8 Anos atrás.]

you should add these initial parameters to your server startup script

-Duser.language=en -Duser.country=us

if you are using tomcat you may change

set "CATALINA_OPTS...

in

setenv.bat