<img alt="Liferay" height="36" src="http://cdn.www.liferay.com/osb-community-theme/images/custom/heading.png" />

Hi,

I'm working on a project and we want to use Liferay 6.1 (trunk version).
I checked out the trunk from the SVN. I need to use MetadataSet to describe new attributes for Documents (MetadataSet sounds very good for the functionnalities I need!).
But when I save my MetadataSet, this exception happens:

  109:04:55,363 ERROR [JDBCExceptionReporter:234] ERROR: operator does not exist: bigint = character varying
  2 Indice : No operator matches the given name and argument type(s). You might need to add explicit type casts.
  3 Position : 653
  409:04:55,365 ERROR [IncludeTag:414] Current URL /en/web/guest/document-library?p_p_id=166&p_p_lifecycle=0&p_p_state=pop_up&p_p_mode=view&_166_chooseCallback=&_166_saveCallback=&_166_scopeAvailableFields=Liferay.FormBuilder.AVAILABLE_FIELDS.DDM_STRUCTURE&_166_scopeStructureName=metadata-set&_166_scopeStructureType=com.liferay.portlet.documentlibrary.model.DLFileEntryMetadata&_166_scopeStorageType=xml&_166_showManageTemplates=false&_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
  509:04:55,369 ERROR [IncludeTag:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
  6 at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:262)
  7 at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
  8 at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
  9 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
10 at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
11 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
12 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
13 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
14 at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:93)
15 at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
16 at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:948)
17 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
18 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
19 at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
20 at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:317)
21 at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:406)
22 at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
23 at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:3514)
24 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
25 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
26Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
27 at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
28 at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:104)
29 at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:67)
30 at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
31 at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByC_G_C_N_D_S(DDMStructureFinderImpl.java:258)
32 at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructureFinderImpl.findByKeywords(DDMStructureFinderImpl.java:175)
33 at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.search(DDMStructureLocalServiceImpl.java:268)
34 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
35 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
36 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
37 at java.lang.reflect.Method.invoke(Method.java:597)
38 at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
39 at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
40 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
41 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
42 at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:60)
43 at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:93)
44 at $Proxy191.search(Unknown Source)
45 at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.search(DDMStructureLocalServiceUtil.java:411)
46 at org.apache.jsp.html.portlet.dynamic_005fdata_005fmapping.view_jsp._jspService(view_jsp.java:948)
47 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
48 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
49 at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45)
50 at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:317)
51 at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:406)
52 at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:92)
53 at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:3514)
54 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
55 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
56 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
57 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
58 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
59 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
60 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
61 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
62 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
63 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
64 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
65 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
66 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
67 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
68 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
69 at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:316)
70 at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:120)
71 at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:281)
72 at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:251)
73 at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
74 at org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
75 at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
76 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
77 at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:230)
78 at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:239)
79 at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:152)
80 at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:211)
81 at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
82 at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
83 at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
84 at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:653)
85 at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:726)
86 at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:426)
87 at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1439)
88 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
89 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
90 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
91 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
92 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
93 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
94 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
95 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
96 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
97 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
98 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
99 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
100 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
101 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
102 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
103 at com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:4460)
104 at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1377)
105 at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:214)
106 at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:135)
107 at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:122)
108 at com.liferay.portlet.layoutconfiguration.util.velocity.PortletLogic.processContent(PortletLogic.java:75)
109 at com.liferay.portlet.layoutconfiguration.util.velocity.TemplateProcessor.processMax(TemplateProcessor.java:83)
110 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
111 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
112 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
113 at java.lang.reflect.Method.invoke(Method.java:597)
114 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
115 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
116 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
117 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
118 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:342)
119 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
120 at org.apache.velocity.Template.merge(Template.java:328)
121 at org.apache.velocity.Template.merge(Template.java:235)
122 at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381)
123 at com.liferay.portal.velocity.VelocityEngineImpl.mergeTemplate(VelocityEngineImpl.java:180)
124 at com.liferay.portal.kernel.velocity.VelocityEngineUtil.mergeTemplate(VelocityEngineUtil.java:61)
125 at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:278)
126 at org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(portlet_jsp.java:715)
127 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
128 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
129 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
130 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
131 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
132 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
133 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
134 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
135 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
136 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
137 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
138 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
139 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
140 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
141 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
142 at com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:407)
143 at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:675)
144 at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:239)
145 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
146 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
147 at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:172)
148 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
149 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
150 at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
151 at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:527)
152 at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:504)
153 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
154 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
155 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
156 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
157 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
158 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
159 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
160 at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
161 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
162 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
163 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
164 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
165 at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
166 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
167 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
168 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
169 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
170 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
171 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
172 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
173 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
174 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
175 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
176 at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:136)
177 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
178 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
179 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
180 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
181 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
182 at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:301)
183 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
184 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
185 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
186 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
187 at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
188 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
189 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
190 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
191 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
192 at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:199)
193 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
194 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
195 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
196 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
197 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:113)
198 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
199 at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:55)
200 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
201 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
202 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
203 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
204 at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:240)
205 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
206 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
207 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
208 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
209 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
210 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
211 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
212 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
213 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
214 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
215 at com.liferay.portal.servlet.I18nServlet.service(I18nServlet.java:102)
216 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
217 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
218 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
219 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
220 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
221 at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
222 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
223 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
224 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
225 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
226 at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:80)
227 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
228 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
229 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
230 at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121)
231 at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:207)
232 at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48)
233 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
234 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
235 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:184)
236 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
237 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
238 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203)
239 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:105)
240 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
241 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
242 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:164)
243 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:92)
244 at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:75)
245 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
246 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
247 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
248 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
249 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
250 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
251 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
252 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
253 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
254 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
255 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
256 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
257 at java.lang.Thread.run(Thread.java:680)
258Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
259 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
260 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
261 at org.hibernate.loader.Loader.doList(Loader.java:2536)
262 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
263 at org.hibernate.loader.Loader.list(Loader.java:2271)
264 at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
265 at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
266 at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
267 at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
268 at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:94)
269 ... 229 more
270Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
271 Indice : No operator matches the given name and argument type(s). You might need to add explicit type casts.
272 Position : 653
273 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
274 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
275 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
276 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
277 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
278 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
279 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
280 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
281 at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
282 at org.hibernate.loader.Loader.doQuery(Loader.java:802)
283 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
284 at org.hibernate.loader.Loader.doList(Loader.java:2533)
285 ... 236 more

I think this exception comes from the View action (to display the MetadataSet list). But, it seems there is no MetadataSet in database. So, creation seems to fail.
Here is my environment :
MacOsX 10.6.7
All browser
PostgreSQL 8.4.1
Tomcat 6.0.32

Somebody reproducts that ? I do not want to flood the Jira with issues due to a bad usage.

Thx!

Leo

RE: Exception while trying to create MetadataSet for Documents (Trunk)

2011年7月29日上午10:49

答复

Ray Augé

LIFERAY STAFF

等级: Liferay Legend

帖子: 1206

加入日期: 2005年2月7日

I think this doesn't happen in the latest trunk, at least it didn't for me.

One thing, I only used two simple types. Could the error be based on the types used in the config? Try with different permutations of the types and see if that could be the case.

标记为答复

RE: Exception while trying to create MetadataSet for Documents (Trunk)

2011年8月1日上午1:25

答复

Leo Pratlong

等级: Expert

帖子: 362

加入日期: 2010年7月6日

Thx Ray!

After an other test, I realize that it's not the Save on MetadataSet which does not work but the Select. And because of that, it's not possible to select a MetadataSet to link it with a DocumentType. (I was looking on the wrong DB table, oops).
But I am on the trunk (SVN trunk, which seems to be updated once a day. So, going on Git right now) and I got still this error.
I will change values directly on the DB until it will be fixed. It's not a problem for what I need to achieve.

Edit:

I looked on DB and I find some errors on the XSD saved as MetadataSet:
according to the attached picture, the name of the field Copyright should be "copyright_txt". But it has kept the default name. It's exactly the same thing for all other field types.

1<?xml version="1.0"?>
2
3<root available-locales="fr_FR" default-locale="fr_FR">
4 <dynamic-element dataType="string" name="text1902" type="text">
5       <meta-data locale="fr_FR">
6          <entry name="required"><![CDATA[true]]></entry>
7          <entry name="label"><![CDATA[Copyright]]></entry>
8          <entry name="predefinedValue"><![CDATA[]]></entry>
9          <entry name="showLabel"><![CDATA[true]]></entry>
10          <entry name="style"><![CDATA[]]></entry>
11          <entry name="tip"><![CDATA[]]></entry>
12          <entry name="fieldCssClass"><![CDATA[aui-w25]]></entry>
13          <entry name="width"><![CDATA[25]]></entry>
14       </meta-data>
15 </dynamic-element>
16 <dynamic-element dataType="string" name="text3627" type="text">
17       <meta-data locale="fr_FR">
18          <entry name="required"><![CDATA[true]]></entry>
19          <entry name="label"><![CDATA[Legend]]></entry>
20          <entry name="predefinedValue"><![CDATA[]]></entry>
21          <entry name="showLabel"><![CDATA[true]]></entry>
22          <entry name="style"><![CDATA[]]></entry>
23          <entry name="tip"><![CDATA[]]></entry>
24          <entry name="fieldCssClass"><![CDATA[aui-w25]]></entry>
25          <entry name="width"><![CDATA[25]]></entry>
26       </meta-data>
27 </dynamic-element>
28 <dynamic-element dataType="date" fieldNamespace="ddm" name="ddm-date5148" type="ddm-date">
29       <meta-data locale="fr_FR">
30          <entry name="required"><![CDATA[false]]></entry>
31          <entry name="label"><![CDATA[Date]]></entry>
32          <entry name="predefinedValue"><![CDATA[]]></entry>
33          <entry name="showLabel"><![CDATA[true]]></entry>
34          <entry name="style"><![CDATA[]]></entry>
35          <entry name="tip"><![CDATA[]]></entry>
36          <entry name="fieldCssClass"><![CDATA[aui-w25]]></entry>
37          <entry name="width"><![CDATA[25]]></entry>
38       </meta-data>
39 </dynamic-element>
40</root>

附件:

Capture d’écran 2011-08-01 à 10.21.48.png (60.4k)

标记为答复

RE: Exception while trying to create MetadataSet for Documents (Trunk)

2011年11月9日上午4:46

答复

Madhuri Sharma

等级: Junior Member

帖子: 50

加入日期: 2011年10月19日

I am also facing same error please help me. I am working on liferay 6.1 .

Thanks
Madhuri