Filtering in resultlist set ON: OwInvalidOperationException

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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