Bug in 'Edit Profile Fields'

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

captainpeter
Posts: 8
Joined: Wed Feb 13, 2013 4:45 pm
Location: Vienna / Austria

Bug in 'Edit Profile Fields'

Post by captainpeter »

Hi,
I'm using OpenEMM 2015 on CentOS 7 64bit with a database brought up from pre v2011 days.

If I open Administration -> Edit Profile Fields OpenEMM shows the database tables with the following column headings:

Code: Select all

Field name | Field name in DB | Type | Lenght | Default Value | Null-value allowed
I can click the first five column headings to sort the list accordingly but whenever I click the 'Null-value allowed' heading it will present an error message as follows:

Error occurred.
An unexpected error occurred. Please contact our support team.

cheers
Peter
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Bug in 'Edit Profile Fields'

Post by maschoff »

Please check Tomcat's log file catalina.out for any error reports when producing this error message.
OpenEMM Maintainer
captainpeter
Posts: 8
Joined: Wed Feb 13, 2013 4:45 pm
Location: Vienna / Austria

Re: Bug in 'Edit Profile Fields'

Post by captainpeter »

here's catalina.out right after clicking the header:

2015-06-29 20:12:21,964: WARN [http-bio-8080-exec-1174] org.displaytag.util.LookupUtil - Exception: [.LookupUtil] Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl". Cause: Unknown property 'default_value' on class 'class org.agnitas.beans.impl.ProfileFieldImpl'
java.lang.NoSuchMethodException: Unknown property 'default_value' on class 'class org.agnitas.beans.impl.ProfileFieldImpl'
at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1313)
at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:611)
at org.displaytag.util.LookupUtil.getProperty(LookupUtil.java:271)
at org.displaytag.util.LookupUtil.getBeanProperty(LookupUtil.java:129)
at org.displaytag.model.RowSorter.compare(RowSorter.java:140)
at java.util.TimSort.countRunAndMakeAscending(TimSort.java:351)
at java.util.TimSort.sort(TimSort.java:230)
at java.util.Arrays.sort(Arrays.java:1512)
at java.util.ArrayList.sort(ArrayList.java:1454)
at java.util.Collections.sort(Collections.java:175)
at org.displaytag.model.TableModel.sortRowList(TableModel.java:451)
at org.displaytag.model.TableModel.sortFullList(TableModel.java:486)
at org.displaytag.tags.TableTag.setupViewableData(TableTag.java:1506)
at org.displaytag.tags.TableTag.doEndTag(TableTag.java:1198)
at org.apache.jsp.settings.profile_005ffield.settings_002dprofile_002dfield_002dlist_jsp._jspService(settings_002dprofile_002dfield_002dlist_jsp.java:370)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152)
at org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764)
at org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896)
at org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465)
at org.apache.jsp.template_jsp._jspx_meth_tiles_005finsert_005f7(template_jsp.java:1117)
at org.apache.jsp.template_jsp._jspService(template_jsp.java:371)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
at org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260)
at org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:232)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SessionHijackingPreventionFilter.doFilter(SessionHijackingPreventionFilter.java:137)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2015-06-29 20:12:21,971: ERROR [http-bio-8080-exec-1174] error.jsp - LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
RuntimeLookupException:
LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
StackTrace:
org.displaytag.model.RowSorter.compare(RowSorter.java:148)
java.util.TimSort.countRunAndMakeAscending(TimSort.java:351)
java.util.TimSort.sort(TimSort.java:230)
java.util.Arrays.sort(Arrays.java:1512)
java.util.ArrayList.sort(ArrayList.java:1454)
java.util.Collections.sort(Collections.java:175)
org.displaytag.model.TableModel.sortRowList(TableModel.java:451)
org.displaytag.model.TableModel.sortFullList(TableModel.java:486)
org.displaytag.tags.TableTag.setupViewableData(TableTag.java:1506)
org.displaytag.tags.TableTag.doEndTag(TableTag.java:1198)
org.apache.jsp.settings.profile_005ffield.settings_002dprofile_002dfield_002dlist_jsp._jspService(settings_002dprofile_002dfield_002dlist_jsp.java:370)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129)
org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152)
org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764)
org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896)
org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465)
org.apache.jsp.template_jsp._jspx_meth_tiles_005finsert_005f7(template_jsp.java:1117)
org.apache.jsp.template_jsp._jspService(template_jsp.java:371)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260)
org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:232)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:49)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.SessionHijackingPreventionFilter.doFilter(SessionHijackingPreventionFilter.java:137)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)

Request Parameters:
d-444187-o: 2
action: 1
d-444187-p: 1
d-444187-s: 5
__fromdisplaytag: true

Request Attributes:
IP: 10.0.101.80
javax.servlet.include.request_uri: /error.jsp
javax.servlet.include.context_path:
javax.servlet.include.servlet_path: /error.jsp
javax.servlet.forward.request_uri: /profiledb.do;jsessionid=1EEDA9CB1109C51EB143B5D08565466A
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /profiledb.do
javax.servlet.forward.query_string: action=1&d-444187-p=1&d-444187-s=5&__fromdisplaytag=true&d-444187-o=2
org.apache.struts.taglib.tiles.CompContext: org.apache.struts.tiles.ComponentContext@19cf70c
org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER: org.springframework.web.context.request.async.WebAsyncManager@b8956b
org.apache.struts.action.MESSAGE: org.apache.struts.util.PropertyMessageResources@1fb1774
javax.servlet.error.status_code: 500
org.apache.struts.action.mapping.instance: ActionConfig[cancellable=false,path=/profiledb,validate=true,input=settings_profile_field_view,name=profileFieldForm,scope=request,type=org.springframework.web.struts.DelegatingActionProxy
org.apache.struts.action.MODULE: org.apache.struts.config.impl.ModuleConfigImpl@bbbda
org.apache.struts.globals.ORIGINAL_URI_KEY: /profiledb.do
agnNavigationKey: profiledb
agnTitleKey: Profile_Database
CharacterEncoding.FILTERED: true
columnInfo: [(1) IS_INVITED shortname:000_is_invited DOUBLE default:0 nullable:true, (1) IS_INVITED_AS shortname:000_is_invited_as DOUBLE nullable:true, (1) IS_INVITED_CONFIRM shortname:000_is_invited_confirm DOUBLE default:0 nullable:true, (1) SEC_IS_INVITED_BECAUSE shortname:000_SEC_is_invited_because VARCHAR(128) default:not specified nullable:true, (1) ACCOUNT_MANAGER shortname:001_account_manager VARCHAR(3) nullable:true, (1) ACCOUNT_MANAGER_FULL shortname:001_account_manager_full VARCHAR(64) nullable:true, (1) SEC_POSTAL_ADDRESS_STREET1 shortname:010_Adresse 1 VARCHAR(40) nullable:true, (1) SEC_POSTAL_ADDRESS_STREET2 shortname:011_Adresse 2 VARCHAR(40) nullable:true, (1) SEC_ZIP shortname:012_PLZ VARCHAR(10) nullable:true, (1) SEC_CITY shortname:013_Ort VARCHAR(40) nullable:true, (1) COUNTRY_AT shortname:014_Austria DOUBLE default:0 nullable:true, (1) COUNTRY_DE shortname:015_Deutschland DOUBLE default:0 nullable:true, (1) COUNTRY_CH shortname:016_Switzerland DOUBLE default:0 nullable:true, (1) COUNTRY_WORLD shortname:017_World DOUBLE default:0 nullable:true, (1) SEC_COUNTRY shortname:018_Land VARCHAR(20) nullable:true, (1) LANG_DE shortname:020_Deutsch DOUBLE default:0 nullable:true, (1) LANG_EN shortname:021_English Language DOUBLE default:0 nullable:true, (1) DJ_VIP shortname:030_DJ VIP DOUBLE default:0 nullable:true, (1) DJ_STD shortname:031_DJ Std DOUBLE default:0 nullable:true, (1) PRESSE shortname:040_Presse DOUBLE default:0 nullable:true, (1) PRESSE_DETAIL shortname:041_Presse Detail VARCHAR(20) nullable:true, (1) MUSIK_FP shortname:042_Musik FP DOUBLE default:0 nullable:true, (1) PRESSE_DETAIL2 shortname:043_Presse Erscheinungsweise VARCHAR(20) nullable:true, (1) SEC_PUBLISH shortname:044_Verlag - Medium VARCHAR(40) nullable:true, (1) HQ_MP3 shortname:050_HQ MP3 DOUBLE default:0 nullable:true, (1) DISTRIBUTION shortname:060_Distribution Partner DOUBLE default:0 nullable:true, (1) FIRMA shortname:070_Firma VARCHAR(100) nullable:true, (1) SEC_JOB_TITLE shortname:071_Position VARCHAR(20) nullable:true, (1) RELEASEINFO shortname:080_Releaseinfo DOUBLE default:0 nullable:true, (1) NEWSLETTER shortname:081_Newsletter DOUBLE default:0 nullable:true, (1) DOWNLOAD_CLICKS shortname:download_clicks DOUBLE default:0 nullable:true, (1) GEWINNCODES shortname:gewinncodes VARCHAR(100) nullable:true, (1) PREFERRED_SALUTATION shortname:preferred_salutation DOUBLE nullable:true, (1) REMINDER shortname:Reminder INTEGER nullable:true, (1) X_ALBERTINA_FIRMA shortname:x_albertina_firma VARCHAR(100) nullable:true, (1) X_ALBERTINA_KUNDENNUMMER shortname:x_albertina_kundennummer DOUBLE nullable:true, (1) COMIDA_COMIDA shortname:x_COMIDA_comida DOUBLE default:0 nullable:true, (1) COMIDA_LNC shortname:x_COMIDA_LNC INTEGER default:0 nullable:true, (1) COMIDA_MESSE_BAU shortname:x_COMIDA_Messe_BAU INTEGER default:0 nullable:true, (1) COMIDA_MESSE_IMMO shortname:x_COMIDA_Messe_IMMO INTEGER default:0 nullable:true, (1) COMIDA_MESSE_JASPOWA shortname:X_COMIDA_Messe_Jaspowa INTEGER default:0 nullable:true, (1) COMIDA_MESSE_WOHNEN shortname:x_COMIDA_Messe_WOHNEN INTEGER default:0 nullable:true, (1) COMIDA_MITTAG shortname:x_COMIDA_mittag DOUBLE default:0 nullable:true, (1) COMIDA_REDROOM shortname:x_COMIDA_redroom DOUBLE default:0 nullable:true, (1) XHELLGP shortname:x_hell_und_partner-gp DOUBLE default:0 nullable:true, (1) XHELLSE shortname:x_hell_und_partner-se DOUBLE default:0 nullable:true, (1) X_PASSAGE_LIST shortname:x_passage_list DOUBLE default:0 nullable:true, (1) X_ROXY_LIST shortname:x_roxy_list DOUBLE default:0 nullable:true]
agnHighlightKey: default.Overview
OpenSessionInView.FILTERED: true
org.apache.struts.taglib.html.BEAN: org.agnitas.web.ProfileFieldForm@1902194
sidemenu_sub_active: settings.Profile_DB
cmsbundle: org.apache.struts.util.PropertyMessageResources@3ee44f
agnHelpKey: profileFieldList
javax.servlet.error.servlet_name: jsp
ACTION_CONFIRM_DELETE: 6
ACTION_VIEW: 2
agnSubtitleKey: Profile_Database
sidemenu_active: Administration
profileFieldForm: org.agnitas.web.ProfileFieldForm@1902194
javax.servlet.jsp.jspException: org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
javax.servlet.error.request_uri: /template.jsp
javax.servlet.error.exception: org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
ACTION_LIST: 1
org.apache.struts.taglib.html.FORM: org.apache.struts.taglib.html.FormTag@1547c85

org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
at org.displaytag.model.RowSorter.compare(RowSorter.java:148)
at java.util.TimSort.countRunAndMakeAscending(TimSort.java:351)
at java.util.TimSort.sort(TimSort.java:230)
at java.util.Arrays.sort(Arrays.java:1512)
at java.util.ArrayList.sort(ArrayList.java:1454)
at java.util.Collections.sort(Collections.java:175)
at org.displaytag.model.TableModel.sortRowList(TableModel.java:451)
at org.displaytag.model.TableModel.sortFullList(TableModel.java:486)
at org.displaytag.tags.TableTag.setupViewableData(TableTag.java:1506)
at org.displaytag.tags.TableTag.doEndTag(TableTag.java:1198)
at org.apache.jsp.settings.profile_005ffield.settings_002dprofile_002dfield_002dlist_jsp._jspService(settings_002dprofile_002dfield_002dlist_jsp.java:370)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152)
at org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764)
at org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896)
at org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465)
at org.apache.jsp.template_jsp._jspx_meth_tiles_005finsert_005f7(template_jsp.java:1117)
at org.apache.jsp.template_jsp._jspService(template_jsp.java:371)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
at org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260)
at org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:232)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SessionHijackingPreventionFilter.doFilter(SessionHijackingPreventionFilter.java:137)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Bug in 'Edit Profile Fields'

Post by maschoff »

Please have a look at database table customer_field_tbl. Its field default_value should never be NULL but hold an empty string value ('') or another meaningful value indicating the preset default value for the corresponding recipient profile field.
OpenEMM Maintainer
captainpeter
Posts: 8
Joined: Wed Feb 13, 2013 4:45 pm
Location: Vienna / Austria

Re: Bug in 'Edit Profile Fields'

Post by captainpeter »

checked the customer_field_tbl - no luck...

2015-06-30 11:55:45,552: ERROR [http-bio-8080-exec-1337] error.jsp - LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
RuntimeLookupException:
LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
StackTrace:
org.displaytag.model.RowSorter.compare(RowSorter.java:148)
java.util.TimSort.countRunAndMakeAscending(TimSort.java:351)
java.util.TimSort.sort(TimSort.java:230)
java.util.Arrays.sort(Arrays.java:1512)
java.util.ArrayList.sort(ArrayList.java:1454)
java.util.Collections.sort(Collections.java:175)
org.displaytag.model.TableModel.sortRowList(TableModel.java:451)
org.displaytag.model.TableModel.sortFullList(TableModel.java:486)
org.displaytag.tags.TableTag.setupViewableData(TableTag.java:1506)
org.displaytag.tags.TableTag.doEndTag(TableTag.java:1198)
org.apache.jsp.settings.profile_005ffield.settings_002dprofile_002dfield_002dlist_jsp._jspService(settings_002dprofile_002dfield_002dlist_jsp.java:370)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129)
org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152)
org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764)
org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896)
org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465)
org.apache.jsp.template_jsp._jspx_meth_tiles_005finsert_005f7(template_jsp.java:1117)
org.apache.jsp.template_jsp._jspService(template_jsp.java:371)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260)
org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:232)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:49)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.agnitas.web.filter.SessionHijackingPreventionFilter.doFilter(SessionHijackingPreventionFilter.java:137)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)

Request Parameters:
d-444187-o: 2
action: 1
d-444187-p: 1
d-444187-s: 5
__fromdisplaytag: true

Request Attributes:
IP: 10.0.101.80
javax.servlet.include.request_uri: /error.jsp
javax.servlet.include.context_path:
javax.servlet.include.servlet_path: /error.jsp
javax.servlet.forward.request_uri: /profiledb.do;jsessionid=3932CC84100AEDB1793847CAF870EC43
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /profiledb.do
javax.servlet.forward.query_string: action=1&d-444187-p=1&d-444187-s=5&__fromdisplaytag=true&d-444187-o=2
org.apache.struts.taglib.tiles.CompContext: org.apache.struts.tiles.ComponentContext@3aa8d2
org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER: org.springframework.web.context.request.async.WebAsyncManager@16f0d54
org.apache.struts.action.MESSAGE: org.apache.struts.util.PropertyMessageResources@1fb1774
javax.servlet.error.status_code: 500
org.apache.struts.action.mapping.instance: ActionConfig[cancellable=false,path=/profiledb,validate=true,input=settings_profile_field_view,name=profileFieldForm,scope=request,type=org.springframework.web.struts.DelegatingActionProxy
org.apache.struts.action.MODULE: org.apache.struts.config.impl.ModuleConfigImpl@bbbda
org.apache.struts.globals.ORIGINAL_URI_KEY: /profiledb.do
agnNavigationKey: profiledb
agnTitleKey: Profile_Database
CharacterEncoding.FILTERED: true
columnInfo: [(1) IS_INVITED shortname:000_is_invited DOUBLE nullable:true, (1) IS_INVITED_AS shortname:000_is_invited_as DOUBLE nullable:true, (1) IS_INVITED_CONFIRM shortname:000_is_invited_confirm DOUBLE nullable:true, (1) SEC_IS_INVITED_BECAUSE shortname:000_SEC_is_invited_because VARCHAR(128) nullable:true, (1) ACCOUNT_MANAGER shortname:001_account_manager VARCHAR(3) nullable:true, (1) ACCOUNT_MANAGER_FULL shortname:001_account_manager_full VARCHAR(64) nullable:true, (1) SEC_POSTAL_ADDRESS_STREET1 shortname:010_Adresse 1 VARCHAR(40) nullable:true, (1) SEC_POSTAL_ADDRESS_STREET2 shortname:011_Adresse 2 VARCHAR(40) nullable:true, (1) SEC_ZIP shortname:012_PLZ VARCHAR(10) nullable:true, (1) SEC_CITY shortname:013_Ort VARCHAR(40) nullable:true, (1) COUNTRY_AT shortname:014_Austria DOUBLE nullable:true, (1) COUNTRY_DE shortname:015_Deutschland DOUBLE nullable:true, (1) COUNTRY_CH shortname:016_Switzerland DOUBLE nullable:true, (1) COUNTRY_WORLD shortname:017_World DOUBLE nullable:true, (1) SEC_COUNTRY shortname:018_Land VARCHAR(20) nullable:true, (1) LANG_DE shortname:020_Deutsch DOUBLE nullable:true, (1) LANG_EN shortname:021_English Language DOUBLE nullable:true, (1) DJ_VIP shortname:030_DJ VIP DOUBLE nullable:true, (1) DJ_STD shortname:031_DJ Std DOUBLE nullable:true, (1) PRESSE shortname:040_Presse DOUBLE nullable:true, (1) PRESSE_DETAIL shortname:041_Presse Detail VARCHAR(20) nullable:true, (1) MUSIK_FP shortname:042_Musik FP DOUBLE nullable:true, (1) PRESSE_DETAIL2 shortname:043_Presse Erscheinungsweise VARCHAR(20) nullable:true, (1) SEC_PUBLISH shortname:044_Verlag - Medium VARCHAR(40) nullable:true, (1) HQ_MP3 shortname:050_HQ MP3 DOUBLE nullable:true, (1) DISTRIBUTION shortname:060_Distribution Partner DOUBLE nullable:true, (1) FIRMA shortname:070_Firma VARCHAR(100) nullable:true, (1) SEC_JOB_TITLE shortname:071_Position VARCHAR(20) nullable:true, (1) RELEASEINFO shortname:080_Releaseinfo DOUBLE nullable:true, (1) NEWSLETTER shortname:081_Newsletter DOUBLE nullable:true, (1) DOWNLOAD_CLICKS shortname:download_clicks DOUBLE nullable:true, (1) GEWINNCODES shortname:gewinncodes VARCHAR(100) nullable:true, (1) PREFERRED_SALUTATION shortname:preferred_salutation DOUBLE nullable:true, (1) REMINDER shortname:Reminder INTEGER nullable:true, (1) X_ALBERTINA_FIRMA shortname:x_albertina_firma VARCHAR(100) nullable:true, (1) X_ALBERTINA_KUNDENNUMMER shortname:x_albertina_kundennummer DOUBLE nullable:true, (1) COMIDA_COMIDA shortname:x_COMIDA_comida DOUBLE nullable:true, (1) COMIDA_LNC shortname:x_COMIDA_LNC INTEGER nullable:true, (1) COMIDA_MESSE_BAU shortname:x_COMIDA_Messe_BAU INTEGER nullable:true, (1) COMIDA_MESSE_IMMO shortname:x_COMIDA_Messe_IMMO INTEGER nullable:true, (1) COMIDA_MESSE_JASPOWA shortname:X_COMIDA_Messe_Jaspowa INTEGER nullable:true, (1) COMIDA_MESSE_WOHNEN shortname:x_COMIDA_Messe_WOHNEN INTEGER nullable:true, (1) COMIDA_MITTAG shortname:x_COMIDA_mittag DOUBLE nullable:true, (1) COMIDA_REDROOM shortname:x_COMIDA_redroom DOUBLE nullable:true, (1) XHELLGP shortname:x_hell_und_partner-gp DOUBLE nullable:true, (1) XHELLSE shortname:x_hell_und_partner-se DOUBLE nullable:true, (1) X_PASSAGE_LIST shortname:x_passage_list DOUBLE nullable:true, (1) X_ROXY_LIST shortname:x_roxy_list DOUBLE nullable:true]
agnHighlightKey: default.Overview
OpenSessionInView.FILTERED: true
org.apache.struts.taglib.html.BEAN: org.agnitas.web.ProfileFieldForm@50d25c
sidemenu_sub_active: settings.Profile_DB
cmsbundle: org.apache.struts.util.PropertyMessageResources@3ee44f
agnHelpKey: profileFieldList
javax.servlet.error.servlet_name: jsp
ACTION_CONFIRM_DELETE: 6
ACTION_VIEW: 2
agnSubtitleKey: Profile_Database
sidemenu_active: Administration
profileFieldForm: org.agnitas.web.ProfileFieldForm@50d25c
javax.servlet.jsp.jspException: org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
javax.servlet.error.request_uri: /template.jsp
javax.servlet.error.exception: org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
ACTION_LIST: 1
org.apache.struts.taglib.html.FORM: org.apache.struts.taglib.html.FormTag@fee08a

org.displaytag.exception.RuntimeLookupException: LookupException while trying to fetch property "default_value". Cause: Error looking up property "default_value" in object type "org.agnitas.beans.impl.ProfileFieldImpl"..
at org.displaytag.model.RowSorter.compare(RowSorter.java:148)
at java.util.TimSort.countRunAndMakeAscending(TimSort.java:351)
at java.util.TimSort.sort(TimSort.java:230)
at java.util.Arrays.sort(Arrays.java:1512)
at java.util.ArrayList.sort(ArrayList.java:1454)
at java.util.Collections.sort(Collections.java:175)
at org.displaytag.model.TableModel.sortRowList(TableModel.java:451)
at org.displaytag.model.TableModel.sortFullList(TableModel.java:486)
at org.displaytag.tags.TableTag.setupViewableData(TableTag.java:1506)
at org.displaytag.tags.TableTag.doEndTag(TableTag.java:1198)
at org.apache.jsp.settings.profile_005ffield.settings_002dprofile_002dfield_002dlist_jsp._jspService(settings_002dprofile_002dfield_002dlist_jsp.java:370)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:688)
at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:682)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152)
at org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764)
at org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896)
at org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465)
at org.apache.jsp.template_jsp._jspx_meth_tiles_005finsert_005f7(template_jsp.java:1117)
at org.apache.jsp.template_jsp._jspService(template_jsp.java:371)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
at org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260)
at org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:232)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.agnitas.web.filter.SessionHijackingPreventionFilter.doFilter(SessionHijackingPreventionFilter.java:137)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Bug in 'Edit Profile Fields'

Post by maschoff »

What do you mean with "checked the customer_field_tbl - no luck"? Does this mean that your column default_value only contains valid values or empty strings?
OpenEMM Maintainer
captainpeter
Posts: 8
Joined: Wed Feb 13, 2013 4:45 pm
Location: Vienna / Austria

Re: Bug in 'Edit Profile Fields'

Post by captainpeter »

Yes, it contained only valid values or an empty string in the first place. I tried replacing its contents both ways without luck. Same result.

Meanwhile I've been getting all kinds of weird results in other places as well which makes me wonder if the database update from previously 2013r2 to 2015 failed somehow.
Some of those weird things are:
  • I can only use the agnTITLE tag in v2015 when creating new mailings. agnTITLEFULL or agnTITLEFIRST only work if the content was created pre v2015 and remains unchanged. Saving a content block with the latter two results in an error message (and will not save).
  • I can COPY an existing mailing, change its SUBJECT line and SAVE it as a new mailing. However if I perform COPY then SAVE and only then try to change the mailing's subject line it will not work.
If there were not years of old mailings and rather elaborate rules & actions in our database I would have opted for a fresh start with v2015, especially since basic setup in CentOS 7 went without a hitch.

Maybe comparing a vanilla v2015 database with my upgraded one offers a clue. Or do issues like the ones I mentioned rather point to a botched install?
Our database originates from some early v6 version (must have been the first VMX you provided) and was updated up to v2013r2.

cheers
peter
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Bug in 'Edit Profile Fields'

Post by maschoff »

As a first step I recommend to compare your database with content of file openemm-2015.sql, contained in the binary tarball of OpenEMM 2015. Search for expression "DROP TABLE IF EXISTS" and make sure that all 69 tables exist in your database.
OpenEMM Maintainer
Post Reply