Filtering in resultlist set ON: OwInvalidOperationException

[walle]

I get an overflow in DB when I enable one of the filter in the Ajax resultlist. (using Alfresco CMIS, Community Edition)

Error: OwStandardDBAttributeBagWriteableFactory.setAttribute() value_p is too long. Attribute value has a fixed maximum length.
Error Source: OECM
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.wewebu.ow.server.ui.OwAppContext.handleRequest(OwAppContext.java:1315)
at com.wewebu.ow.server.app.OwMainAppContext.handleRequest(OwMainAppContext.java:642)
at com.wewebu.ow.server.ui.OwWebApplication.handleRequest(OwWebApplication.java:352)
at org.apache.jsp.default20_jsp._jspService(default20_jsp.java:76)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:284)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:322)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1714)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.wewebu.ow.server.exceptions.OwInvalidOperationException: OwStandardDBAttributeBagWriteableFactory.setAttribute() value_p is too long. Attribute value has a fixed maximum length.
at com.wewebu.ow.server.util.OwStandardDBAttributeBagWriteableFactory.setAttribute(OwStandardDBAttributeBagWriteableFactory.java:232)
at com.wewebu.ow.server.util.OwStandardDBAttributeBagWriteable.setAttribute(OwStandardDBAttributeBagWriteable.java:53)
at com.wewebu.ow.server.dmsdialogs.views.OwObjectListView$OwFilter.save(OwObjectListView.java:1217)
at com.wewebu.ow.server.dmsdialogs.views.OwObjectListViewFilterEXTJSGrid.onEnableFilter(OwObjectListViewFilterEXTJSGrid.java:117)
… 30 more ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[d_evil]

Hi Walle,

:shock:  that's a really  problem, looks like the filter persistance handling is creating an extrem long value. That must be fixed in next fix pack for the latest and available supported  release.

The only workaround I can help you with, is to alter the table of ow_attribute_bag and double the size of attributevalue column.

Cheers,
D.evil