Hello,
Still having the problem below.....my second option is to copy a specific
table from one Mifos instance to another.......how do I go about that?
Polly
On 19 July 2011 10:29, Polly <[email protected]> wrote:
> Hi,
> When I attempt to define a new survey or anything to do with surveys like
> defining questions etc. I get the error below. This functionality was
> working well but I do not know what went wrong. Can anyone decode this?
>
> Polly
>
> HTTP Status 500 -
> ------------------------------
>
> *type* Exception report
>
> *message* **
>
> *description* *The server encountered an internal error () that prevented
> it from fulfilling this request.*
>
> *exception*
>
> javax.servlet.ServletException: org.hibernate.exception.SQLGrammarException:
> could not initialize a collection:
> [org.mifos.application.surveys.business.Question.choices#3]
>
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
>
> org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:231)
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> org.mifos.framework.security.util.LoginFilter.doFilter(LoginFilter.java:85)
>
> org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
>
> *root cause*
>
> org.hibernate.exception.SQLGrammarException: could not initialize a
> collection: [org.mifos.application.surveys.business.Question.choices#3]
>
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> org.hibernate.loader.Loader.loadCollection(Loader.java:2001)
>
> org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
>
> org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
>
> org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
>
> org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
>
> org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
>
> org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:797)
>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241)
> org.hibernate.loader.Loader.doList(Loader.java:2220)
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
> org.hibernate.loader.Loader.list(Loader.java:2099)
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>
> org.mifos.application.surveys.persistence.SurveysPersistence.retrieveGeneralQuestionsByState(SurveysPersistence.java:138)
>
> org.mifos.application.surveys.struts.action.SurveysAction.getQuestions(SurveysAction.java:308)
>
> org.mifos.application.surveys.struts.action.SurveysAction.edit_entry(SurveysAction.java:327)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
>
> 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:92)
>
> org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:203)
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> org.mifos.framework.security.util.LoginFilter.doFilter(LoginFilter.java:85)
>
> org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
>
> *root cause*
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
> 'choices0_.PPI_POINTS' in 'field list'
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
> Source)
> java.lang.reflect.Constructor.newInstance(Unknown Source)
> com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> com.mysql.jdbc.Util.getInstance(Util.java:381)
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
>
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
>
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
>
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
> org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
>
> org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
>
> org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
>
> org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
>
> org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
>
> org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
>
> org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:797)
>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241)
> org.hibernate.loader.Loader.doList(Loader.java:2220)
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
> org.hibernate.loader.Loader.list(Loader.java:2099)
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>
> org.mifos.application.surveys.persistence.SurveysPersistence.retrieveGeneralQuestionsByState(SurveysPersistence.java:138)
>
> org.mifos.application.surveys.struts.action.SurveysAction.getQuestions(SurveysAction.java:308)
>
> org.mifos.application.surveys.struts.action.SurveysAction.edit_entry(SurveysAction.java:327)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
>
> 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:92)
>
> org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:203)
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> org.mifos.framework.security.util.LoginFilter.doFilter(LoginFilter.java:85)
>
> org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
>
> *note* *The full stack trace of the root cause is available in the Apache
> Tomcat/6.0.16 logs.*
>
>
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
