[Mifos-issues] [JIRA Studio] Created: (MIFOS-4184) Problem with question groups functionality: Data too long for column change_log_detail.field_name

0 views
Skip to first unread message

Milan Patel (JIRA)

unread,
Nov 19, 2010, 11:53:25 AM11/19/10
to mifos-...@lists.sourceforge.net
Problem with question groups functionality: Data too long for column change_log_detail.field_name
-------------------------------------------------------------------------------------------------

Key: MIFOS-4184
URL: http://mifosforge.jira.com/browse/MIFOS-4184
Project: mifos
Issue Type: Bug
Components: QuestionGroups/Surveys/PPI
Affects Versions: Release E
Reporter: Milan Patel
Priority: Major


I created a new client, and the client creation process includes a survey based on Question Groups.

Upon submitting the client to save to database, I get an error on front-end:"An unhandled error has occurred. Please contact your system administrator."

Log has error message at bottom of this description--significantly stating "com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'field_name' at row 1"

Upon reviewing MYSQL insert statement, I find following transactions:

insert into change_log (entity_id, entity_type, modifier_name, changed_by, changed_date) values (1201, 1, 'mifos', 1, '2010-11-19')

insert into change_log_detail (field_name, old_value, new_value, change_log_id) values ('Activos y Pasivos/Cuales son sus activos (del negocio y de la casa)?/Vehiculos (Valor, COP)', '-', '600000', 10)

insert into change_log_detail (field_name, old_value, new_value, change_log_id) values ('Activos y Pasivos/Otras preguntas/Tiene relacion con el sector financiero?', '-', 'No', 10)

insert into change_log_detail (field_name, old_value, new_value, change_log_id) values ('Activos y Pasivos/Cuales son sus activos (del negocio y de la casa)?/Maquinaria y equipo (Valor, COP)', '-', '400000', 10)

Note 3 insert statement-- value for field "field_name" is 'Activos y Pasivos/Otras preguntas/Tiene relacion con el sector financiero?'. This is 102 characters, where field itself is set to 100. If statement is run directly in MYSQL workbench, statement is inserted, but field value is truncated by 2 characters.

This problem is related to Question Groups, as the insert statement is related to a response from question groups--the field name itself is in format question group name / section heading /question.


I am trying workaround of expanding the database field change_log_detail.field_name, but I don't know if this is sensible in a production environment or not.


Nov 19, 2010 11:19:02 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet Controller threw exception
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'field_name' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3561)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2329)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2836)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:669)
at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:362)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:338)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)
at org.hibernate.engine.Cascade.cascade(Cascade.java:161)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:476)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:354)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:705)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:693)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:689)
at org.mifos.framework.components.audit.persistence.AuditPersistence.save(AuditPersistence.java:42)
at org.mifos.framework.components.audit.business.AuditLog.save(AuditLog.java:94)
at org.mifos.framework.components.audit.business.service.AuditLogServiceImpl.addAuditLogRegistry(AuditLogServiceImpl.java:94)
at org.mifos.platform.questionnaire.service.QuestionnaireServiceFacadeImpl.saveResponses(QuestionnaireServiceFacadeImpl.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy40.saveResponses(Unknown Source)
at org.mifos.application.questionnaire.struts.QuestionnaireFlowAdapter.saveResponses(QuestionnaireFlowAdapter.java:122)
at org.mifos.customers.client.struts.action.ClientCustAction.create(ClientCustAction.java:469)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at org.mifos.framework.struts.action.BaseAction.execute(BaseAction.java:161)
at org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:195)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.mifos.servlet.filters.MifosAccessLogFilter.doFilter(MifosAccessLogFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:188)
at org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:102)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)


--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Mifos-issues mailing list
Mifos-...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Kay Chau (JIRA)

unread,
Nov 19, 2010, 2:16:26 PM11/19/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62222#action_62222 ]

Kay Chau commented on MIFOS-4184:
---------------------------------

We need to know Build # of Release E you are using, and how big were the answers used for the QG

Kay Chau (JIRA)

unread,
Nov 19, 2010, 2:16:26 PM11/19/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kay Chau reassigned MIFOS-4184:
-------------------------------

Assignee: Milan Patel

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI
> Affects Versions: Release E
> Reporter: Milan Patel

> Assignee: Milan Patel

Milan Patel (JIRA)

unread,
Nov 19, 2010, 2:28:26 PM11/19/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62225#action_62225 ]

Milan Patel commented on MIFOS-4184:
------------------------------------

I found build info as follows:

Build DateTue Nov 02 08:55:39 PDT 2010
Build Numberhudson-head-1.7.x-163

In terms of questions--there were a number of questions for which there were answers, but I would say that none were more than 10 characters or so; I believe answers for affected questions are specified in the given insert statements

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI
> Affects Versions: Release E
> Reporter: Milan Patel

> Assignee: Milan Patel

Milan Patel (JIRA)

unread,
Dec 1, 2010, 10:57:25 AM12/1/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62562#action_62562 ]

Milan Patel commented on MIFOS-4184:
------------------------------------

Hi Kay

I've added comment with build information, but I'm unsure how / if I need to
reassign the item?

2010/11/19 Kay Chau (JIRA) <ji...@mifosforge.jira.com>

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI
> Affects Versions: Release E
> Reporter: Milan Patel

> Assignee: Milan Patel

------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

Milan Patel (JIRA)

unread,
Dec 10, 2010, 9:51:26 AM12/10/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62829#action_62829 ]

Milan Patel commented on MIFOS-4184:
------------------------------------

Hi Kay

This item is still assigned to me, does it need to be reassigned? I have
included relevant information.

Thanks

Milan

---------- Forwarded message ----------
From: Milan Patel (JIRA) <ji...@mifosforge.jira.com>
Date: 2010/12/1
Subject: [JIRA Studio] Commented: (MIFOS-4184) Problem with question groups
functionality: Data too long for column change_log_detail.field_name

To: milan...@prosperitasmf.com

[
http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62562#action_62562]

Milan Patel commented on MIFOS-4184:
------------------------------------

Hi Kay

I've added comment with build information, but I'm unsure how / if I need to
reassign the item?

2010/11/19 Kay Chau (JIRA) <ji...@mifosforge.jira.com>

change_log_detail.field_name
-------------------------------------------------------------------------------------------------
based on Question Groups.


front-end:"An unhandled error has occurred. Please contact your system
administrator."

"com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'field_name' at row 1"

changed_date) values (1201, 1, 'mifos', 1, '2010-11-19')

change_log_id) values ('Activos y Pasivos/Cuales son sus activos (del
negocio y de la casa)?/Vehiculos (Valor, COP)', '-', '600000', 10)

change_log_id) values ('Activos y Pasivos/Otras preguntas/Tiene relacion con
el sector financiero?', '-', 'No', 10)

change_log_id) values ('Activos y Pasivos/Cuales son sus activos (del
negocio y de la casa)?/Maquinaria y equipo (Valor, COP)', '-', '400000',
10)

Pasivos/Otras preguntas/Tiene relacion con el sector financiero?'. This is
102 characters, where field itself is set to 100. If statement is run
directly in MYSQL workbench, statement is inserted, but field value is
truncated by 2 characters.

related to a response from question groups--the field name itself is in
format question group name / section heading /question.

change_log_detail.field_name, but I don't know if this is sensible in a
production environment or not.

invoke


column 'field_name' at row 1

com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2329)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2836)
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:677)
org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252)
org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425)
org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:476)
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:354)
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
org.mifos.framework.components.audit.persistence.AuditPersistence.save(AuditPersistence.java:42)
org.mifos.framework.components.audit.business.AuditLog.save(AuditLog.java:94)
org.mifos.framework.components.audit.business.service.AuditLogServiceImpl.addAuditLogRegistry(AuditLogServiceImpl.java:94)
org.mifos.platform.questionnaire.service.QuestionnaireServiceFacadeImpl.saveResponses(QuestionnaireServiceFacadeImpl.java:140)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
org.mifos.application.questionnaire.struts.QuestionnaireFlowAdapter.saveResponses(QuestionnaireFlowAdapter.java:122)
org.mifos.customers.client.struts.action.ClientCustAction.create(ClientCustAction.java:469)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
org.mifos.framework.struts.action.BaseAction.execute(BaseAction.java:161)
org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:195)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.mifos.servlet.filters.MifosAccessLogFilter.doFilter(MifosAccessLogFilter.java:72)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:188)
org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:102)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI
> Affects Versions: Release E
> Reporter: Milan Patel

> Assignee: Milan Patel

------------------------------------------------------------------------------

Kay Chau (JIRA)

unread,
Feb 7, 2011, 4:39:24 PM2/7/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kay Chau updated MIFOS-4184:
----------------------------

Assignee: (was: Milan Patel)

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0

------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Kay Chau (JIRA)

unread,
Feb 8, 2011, 5:24:24 PM2/8/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kay Chau updated MIFOS-4184:
----------------------------

Fix Version/s: Elsie F
Elsie F - Iteration 10
Assignee: Udai Gupta

Udai, can you investigate? This seems like the change log cannot accomodate the lengths of our Question Group fields

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Elsie F - Iteration 10, Elsie F

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Udai Gupta (JIRA)

unread,
Feb 9, 2011, 7:32:24 AM2/9/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64668#action_64668 ]

Udai Gupta edited comment on MIFOS-4184 at 2/9/11 4:31 AM:
-----------------------------------------------------------

This issue have been marked as duplicate of MIFOS-4184, The reporter might be seeing this because of using older code base

was (Author: ugupta):
This issue have been marked as duplicate of MIFOS-4184, The reported might be seeing this because of using older code base



> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Elsie F - Iteration 10, Elsie F
>
>

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Udai Gupta (JIRA)

unread,
Feb 9, 2011, 7:32:24 AM2/9/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Udai Gupta resolved MIFOS-4184.
-------------------------------

Resolution: Duplicate

This issue have been marked as duplicate of MIFOS-4184, The reported might be seeing this because of using older code base

> Problem with question groups functionality: Data too long for column change_log_detail.field_name


> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Elsie F - Iteration 10, Elsie F
>
>

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Udai Gupta (JIRA)

unread,
Feb 12, 2011, 12:07:24 PM2/12/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64668#action_64668 ]

Udai Gupta edited comment on MIFOS-4184 at 2/12/11 9:06 AM:
------------------------------------------------------------

This issue have been marked as duplicate of MIFOS-4140, The reporter might be seeing this because of using older code base

was (Author: ugupta):
This issue have been marked as duplicate of MIFOS-4184, The reporter might be seeing this because of using older code base



> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Elsie F - Iteration 10, Elsie F
>
>

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Udai Gupta (JIRA)

unread,
Feb 12, 2011, 12:07:24 PM2/12/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64668#action_64668 ]

Udai Gupta edited comment on MIFOS-4184 at 2/12/11 9:07 AM:
------------------------------------------------------------

This issue have been marked as duplicate of MIFOS-4140, The reporter might be seeing this because of using older code base


Jakub Resolved MIFOS-4140 in commit 7fd24004e39162fce0f43fce24862cca965f1eee.

This error was caused by the limit on the field name in audit logs (100 characters). I fixed this by trimming the field name from QG (QG title + section title + question text) to 100 characters if necessary.


was (Author: ugupta):
This issue have been marked as duplicate of MIFOS-4140, The reporter might be seeing this because of using older code base


> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Elsie F - Iteration 10, Elsie F
>
>

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

jbrewster (JIRA)

unread,
Feb 14, 2011, 3:45:16 PM2/14/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

jbrewster updated MIFOS-4184:
-----------------------------

Status: Ready for Showcase (was: Ready for Testing / Resolved)

agree, duplicate of MIFOS-4140

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major

> Labels: community


> Fix For: Elsie F - Iteration 10, Elsie F
>
>

For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Kay Chau (JIRA)

unread,
Feb 15, 2011, 2:10:16 PM2/15/11
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOS-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kay Chau updated MIFOS-4184:
----------------------------

Status: Ready to Ship / Verified (was: Ready for Showcase)

> Problem with question groups functionality: Data too long for column change_log_detail.field_name
> -------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4184
> URL: http://mifosforge.jira.com/browse/MIFOS-4184
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI

> Affects Versions: Release 2.0.0
> Reporter: Milan Patel
> Assignee: Udai Gupta
> Priority: Major
> Labels: community
> Fix For: Elsie F - Iteration 10, Elsie F
>
>

For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------


The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

Reply all
Reply to author
Forward
0 new messages