Dynamic data list

[12年前 に Madhuri Sharma によって更新されました。]

Hello,
Thanks for all response it's really worked but now i have another problem i want to create data definition i am doing open Dynamic data list -> select->add data definition ->save , it save successfully but not seen on the screen. what should i do and where i am doing mistake. i got an error on console that is ....




Hibernate: SELECT Layout.plid as plid14_0_, Layout.uuid_ as uuid2_14_0_, Layout.groupId as groupId14_0_, Layout.companyId as companyId14_0_, Layout.createDate as createDate14_0_, Layout.modifiedDate as modified6_14_0_, Layout.privateLayout as privateL7_14_0_, Layout.layoutId as layoutId14_0_, Layout.parentLayoutId as parentLa9_14_0_, Layout.name as name14_0_, Layout.title as title14_0_, Layout.description as descrip12_14_0_, Layout.keywords as keywords14_0_, Layout.robots as robots14_0_, Layout.type_ as type15_14_0_, Layout.typeSettings as typeSet16_14_0_, Layout.hidden_ as hidden17_14_0_, Layout.friendlyURL as friendl18_14_0_, Layout.iconImage as iconImage14_0_, Layout.iconImageId as iconIma20_14_0_, Layout.themeId as themeId14_0_, Layout.colorSchemeId as colorSc22_14_0_, Layout.wapThemeId as wapThemeId14_0_, Layout.wapColorSchemeId as wapColo24_14_0_, Layout.css as css14_0_, Layout.priority as priority14_0_, Layout.layoutPrototypeUuid as layoutP27_14_0_, Layout.layoutPrototypeLinkEnabled as layoutP28_14_0_, Layout.templateLayoutUuid as templat29_14_0_ FROM Layout INNER JOIN Group_ ON (Group_.companyId = Layout.companyId) AND (Group_.classNameId = 10014) AND (Group_.classPK = Layout.plid) WHERE (Layout.groupId = ?) AND (Layout.privateLayout = ?)
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Group_.classPK) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Groups_Orgs.organizationId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_UserGroups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Users_Orgs ON (Users_Orgs.userId = ?) WHERE (Users_Orgs.organizationId = Organization_.organizationId) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) UNION ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Group_ ON (Group_.classPK = Organization_.organizationId) INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Users_UserGroups.userId = ?) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) ORDER BY orgName ASC limit ?
Hibernate: select groupimpl0_.groupId as groupId12_0_, groupimpl0_.companyId as companyId12_0_, groupimpl0_.creatorUserId as creatorU3_12_0_, groupimpl0_.classNameId as classNam4_12_0_, groupimpl0_.classPK as classPK12_0_, groupimpl0_.parentGroupId as parentGr6_12_0_, groupimpl0_.liveGroupId as liveGrou7_12_0_, groupimpl0_.name as name12_0_, groupimpl0_.description as descript9_12_0_, groupimpl0_.type_ as type10_12_0_, groupimpl0_.typeSettings as typeSet11_12_0_, groupimpl0_.friendlyURL as friendl12_12_0_, groupimpl0_.site as site12_0_, groupimpl0_.active_ as active14_12_0_ from Group_ groupimpl0_ where groupimpl0_.groupId=?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: select portletpre0_.portletPreferencesId as portletP1_37_, portletpre0_.ownerId as ownerId37_, portletpre0_.ownerType as ownerType37_, portletpre0_.plid as plid37_, portletpre0_.portletId as portletId37_, portletpre0_.preferences as preferen6_37_ from PortletPreferences portletpre0_ where (portletpre0_.ownerId=? )AND(portletpre0_.ownerType=? )AND(portletpre0_.plid=? )AND(portletpre0_.portletId=? )
Hibernate: select COUNT(*) as col_0_0_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )
Hibernate: select COUNT(*) as col_0_0_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: SELECT DDMStructure.structureId as structur1_98_0_, DDMStructure.uuid_ as uuid2_98_0_, DDMStructure.groupId as groupId98_0_, DDMStructure.companyId as companyId98_0_, DDMStructure.userId as userId98_0_, DDMStructure.userName as userName98_0_, DDMStructure.createDate as createDate98_0_, DDMStructure.modifiedDate as modified8_98_0_, DDMStructure.classNameId as classNam9_98_0_, DDMStructure.structureKey as structu10_98_0_, DDMStructure.name as name98_0_, DDMStructure.description as descrip12_98_0_, DDMStructure.xsd as xsd98_0_, DDMStructure.storageType as storage14_98_0_ FROM DDMStructure WHERE (companyId = ?) AND (groupId = ?) AND (classNameId = ? OR ? IS NULL) AND ( (lower(name) LIKE ? OR ? IS NULL) AND (description LIKE ? OR ? IS NULL) AND (storageType LIKE ? OR ? IS NULL) ) ORDER BY DDMStructure.structureId DESC limit ?
09:50:54,638 ERROR [JDBCExceptionReporter:234] ERROR: operator does not exist: bigint = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 653
09:50:54,638 ERROR [IncludeTag:426] Current URL /en_GB/group/control_panel/manage?p_p_id=166&p_p_lifecycle=0&p_p_state=pop_up&_166_templateId=&_166_saveCallback=_167_selectDDMStructure&_166_scopeTemplateType=&_166_scopeStructureType=com.liferay.portlet.dynamicdatalists.model.DDLRecordSet&_166_chooseCallback=_167_selectDDMStructure&_166_structureId=&_166_struts_action=%2Fdynamic_data_mapping%2Fview&_166_templateHeaderTitle=&_166_scopeStructureName=data-definition&_166_scopeAvailableFields=Liferay.FormBuilder.AVAILABLE_FIELDS.DDM_STRUCTURE&_166_scopeStorageType=xml generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
09:50:54,638 ERROR [IncludeTag:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:262)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:702)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:323)
at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:418)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:2884)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:110)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:91)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:67)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:258)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
at sun.reflect.GeneratedMethodAccessor572.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy200.search(Unknown Source)
at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:702)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:323)
at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:418)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:2884)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:316)
at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:120)
at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:281)
at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:251)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
at org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:230)
at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:239)
at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:152)
at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:211)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:653)
at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:726)
at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:426)
at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1184)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:4526)
at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1418)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:214)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:135)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:122)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:54)
at com.liferay.portlet.layoutconfiguration.util.velocity.PortletLogic.processContent(PortletLogic.java:75)
at com.liferay.portlet.layoutconfiguration.util.velocity.TemplateProcessor.processMax(TemplateProcessor.java:83)
at sun.reflect.GeneratedMethodAccessor460.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:342)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
at org.apache.velocity.Template.merge(Template.java:328)
at org.apache.velocity.Template.merge(Template.java:235)
at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381)
at com.liferay.portal.velocity.VelocityEngineImpl.mergeTemplate(VelocityEngineImpl.java:184)
at com.liferay.portal.kernel.velocity.VelocityEngineUtil.mergeTemplate(VelocityEngineUtil.java:61)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processTemplate(RuntimePortletImpl.java:278)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:118)
at org.apache.jsp.html.portal.layout.view.control_005fpanel_jsp._jspService(control_005fpanel_jsp.java:790)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:412)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:680)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:244)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:173)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:548)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:302)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:55)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at com.liferay.portal.servlet.I18nServlet.service(I18nServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:80)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:209)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:184)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:98)
... 229 more

""Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.""


Position: 653
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 236 more

Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Group_.classPK) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Groups_Orgs.organizationId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_UserGroups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Users_Orgs ON (Users_Orgs.userId = ?) WHERE (Users_Orgs.organizationId = Organization_.organizationId) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) UNION ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Group_ ON (Group_.classPK = Organization_.organizationId) INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Users_UserGroups.userId = ?) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) ORDER BY orgName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Group_.classPK) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Groups_Orgs.organizationId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_UserGroups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Users_Orgs ON (Users_Orgs.userId = ?) WHERE (Users_Orgs.organizationId = Organization_.organizationId) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) UNION ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Group_ ON (Group_.classPK = Organization_.organizationId) INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Users_UserGroups.userId = ?) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) ORDER BY orgName ASC limit ?
09:51:21,304 WARN [404_jsp:100] /assets/skins/sam/sprite.png
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: select ddmstructu0_.structureId as structur1_98_, ddmstructu0_.uuid_ as uuid2_98_, ddmstructu0_.groupId as groupId98_, ddmstructu0_.companyId as companyId98_, ddmstructu0_.userId as userId98_, ddmstructu0_.userName as userName98_, ddmstructu0_.createDate as createDate98_, ddmstructu0_.modifiedDate as modified8_98_, ddmstructu0_.classNameId as classNam9_98_, ddmstructu0_.structureKey as structu10_98_, ddmstructu0_.name as name98_, ddmstructu0_.description as descrip12_98_, ddmstructu0_.xsd as xsd98_, ddmstructu0_.storageType as storage14_98_ from DDMStructure ddmstructu0_ where (ddmstructu0_.groupId=? )AND(ddmstructu0_.structureKey=? )
Hibernate: insert into DDMStructure (uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, structureKey, name, description, xsd, storageType, structureId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )AND(resourcepe0_.roleId=? )
Hibernate: insert into ResourcePermission (companyId, name, scope, primKey, roleId, ownerId, actionIds, resourcePermissionId) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )AND(resourcepe0_.roleId=? )
Hibernate: insert into ResourcePermission (companyId, name, scope, primKey, roleId, ownerId, actionIds, resourcePermissionId) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )AND(resourcepe0_.roleId=? )
Hibernate: insert into ResourcePermission (companyId, name, scope, primKey, roleId, ownerId, actionIds, resourcePermissionId) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: ( SELECT Role_.roleId as roleId49_0_, Role_.companyId as companyId49_0_, Role_.classNameId as classNam3_49_0_, Role_.classPK as classPK49_0_, Role_.name as name49_0_, Role_.title as title49_0_, Role_.description as descript7_49_0_, Role_.type_ as type8_49_0_, Role_.subtype as subtype49_0_ FROM Role_ INNER JOIN Users_Roles ON (Users_Roles.roleId = Role_.roleId) WHERE (Users_Roles.userId = ?) ) UNION ( SELECT Role_.roleId as roleId49_0_, Role_.companyId as companyId49_0_, Role_.classNameId as classNam3_49_0_, Role_.classPK as classPK49_0_, Role_.name as name49_0_, Role_.title as title49_0_, Role_.description as descript7_49_0_, Role_.type_ as type8_49_0_, Role_.subtype as subtype49_0_ FROM Role_ INNER JOIN Groups_Roles ON (Groups_Roles.roleId = Role_.roleId) WHERE (Groups_Roles.groupId = ?) )
Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where ((resourcepe0_.companyId=? ))AND((resourcepe0_.name=? ))AND((resourcepe0_.scope=? ))AND((resourcepe0_.primKey=? ))AND(((resourcepe0_.roleId=? )))
Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where ((resourcepe0_.companyId=? ))AND((resourcepe0_.name=? ))AND((resourcepe0_.scope=? ))AND(((resourcepe0_.primKey IS NULL )OR(resourcepe0_.primKey=? )))AND(((resourcepe0_.roleId=? )))
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: select COUNT(*) as col_0_0_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )
Hibernate: select COUNT(*) as col_0_0_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName, Group_.type_ AS groupType, Group_.friendlyURL AS groupFriendlyURL FROM Group_ WHERE (Group_.site = ?) AND (Group_.companyId = ?) AND (Group_.liveGroupId = 0) AND (Group_.name != 'Control Panel') AND (lower(Group_.name) LIKE ? OR lower(Group_.name) LIKE ? OR ? IS NULL) AND (lower(Group_.description) LIKE ? OR ? IS NULL) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: SELECT DDMStructure.structureId as structur1_98_0_, DDMStructure.uuid_ as uuid2_98_0_, DDMStructure.groupId as groupId98_0_, DDMStructure.companyId as companyId98_0_, DDMStructure.userId as userId98_0_, DDMStructure.userName as userName98_0_, DDMStructure.createDate as createDate98_0_, DDMStructure.modifiedDate as modified8_98_0_, DDMStructure.classNameId as classNam9_98_0_, DDMStructure.structureKey as structu10_98_0_, DDMStructure.name as name98_0_, DDMStructure.description as descrip12_98_0_, DDMStructure.xsd as xsd98_0_, DDMStructure.storageType as storage14_98_0_ FROM DDMStructure WHERE (companyId = ?) AND (groupId = ?) AND (classNameId = ? OR ? IS NULL) AND ( (lower(name) LIKE ? OR ? IS NULL) AND (description LIKE ? OR ? IS NULL) AND (storageType LIKE ? OR ? IS NULL) ) ORDER BY DDMStructure.structureId DESC limit ?
09:51:28,388 ERROR [JDBCExceptionReporter:234] ERROR: operator does not exist: bigint = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 653
09:51:28,388 ERROR [IncludeTag:426] Current URL /en_GB/group/control_panel/manage?p_p_id=166&p_p_lifecycle=0&p_p_state=pop_up&p_p_mode=view&_166_chooseCallback=_167_selectDDMStructure&_166_saveCallback=_167_selectDDMStructure&_166_scopeAvailableFields=Liferay.FormBuilder.AVAILABLE_FIELDS.DDM_STRUCTURE&_166_scopeStorageType=xml&_166_scopeStructureName=data-definition&_166_scopeStructureType=com.liferay.portlet.dynamicdatalists.model.DDLRecordSet&_166_scopeTemplateType=&_166_templateHeaderTitle=&_166_templateId=&_166_struts_action=%2Fdynamic_data_mapping%2Fview&_166_structureId= generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
09:51:28,388 ERROR [IncludeTag:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:262)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:702)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:323)
at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:418)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:2884)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:110)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:91)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:67)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:258)
at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
at sun.reflect.GeneratedMethodAccessor572.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy200.search(Unknown Source)
at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:702)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:323)
at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:418)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:2884)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:316)
at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:120)
at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:281)
at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:251)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
at org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:230)
at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:239)
at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:152)
at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:211)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:653)
at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:726)
at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:426)
at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1184)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:4526)
at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1418)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:214)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:135)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:122)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:54)
at com.liferay.portlet.layoutconfiguration.util.velocity.PortletLogic.processContent(PortletLogic.java:75)
at com.liferay.portlet.layoutconfiguration.util.velocity.TemplateProcessor.processMax(TemplateProcessor.java:83)
at sun.reflect.GeneratedMethodAccessor460.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:342)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
at org.apache.velocity.Template.merge(Template.java:328)
at org.apache.velocity.Template.merge(Template.java:235)
at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381)
at com.liferay.portal.velocity.VelocityEngineImpl.mergeTemplate(VelocityEngineImpl.java:184)
at com.liferay.portal.kernel.velocity.VelocityEngineUtil.mergeTemplate(VelocityEngineUtil.java:61)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processTemplate(RuntimePortletImpl.java:278)
at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:118)
at org.apache.jsp.html.portal.layout.view.control_005fpanel_jsp._jspService(control_005fpanel_jsp.java:790)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:412)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:680)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:244)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:173)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:548)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:302)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:55)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at com.liferay.portal.servlet.I18nServlet.service(I18nServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:80)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:209)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:184)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:98)
... 229 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 653
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 236 more

Hibernate: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Group_.classPK) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Groups_Orgs.organizationId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_Orgs.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Group_.liveGroupId = 0) AND (Group_.active_ = ?) AND (Group_.liveGroupId = 0) AND (Users_UserGroups.userId = ?) AND (Group_.companyId = ?) AND (Group_.classNameId = 10012 OR Group_.classNameId = 10027) AND (Group_.type_ != 4) ) ORDER BY groupName ASC limit ?
Hibernate: ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Users_Orgs ON (Users_Orgs.userId = ?) WHERE (Users_Orgs.organizationId = Organization_.organizationId) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) UNION ( SELECT DISTINCT Organization_.organizationId AS orgId, Organization_.name AS orgName FROM Organization_ INNER JOIN Group_ ON (Group_.classPK = Organization_.organizationId) INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) WHERE (Users_UserGroups.userId = ?) AND (Organization_.companyId = ?) AND (Organization_.parentOrganizationId != ( -1)) ) ORDER BY orgName ASC limit ?








Thanks
Madhuri