Krishnan,
These settings are known as TRAPDOOR settings, meaning they need to be set
before running Mifos. If you take a look at the config file it highlights
this. It is almost guaranteed you would run into issue if you didn¹t do
that. But, it is also the case (As Jeff is referring to) that these
features have issues/bugs that have not been addressed and therefore it may
be best to just not use them.
r
On 7/30/09 11:01, "Krishnan M" <[email protected]> wrote:
> Hello,
>
> [From the perspective of the developer...]
> Is it possible that this error can occur if there are already some customers
> in 'Pending approval' state, and you then change configuration such that
> pending approval state is disabled?
>
> (If you already have pre-existing data and customers,) try running this query:
>
> select distinct(cust.status_id), cust.customer_level_id, cstate.description,
> cstate.currently_in_use from customer cust, customer_state cstate where
> cstate.status_id = cust.status_id and cstate.level_id =
> cust.customer_level_id;
>
> Do the query results return any descriptions that include "Customer Was
> Pending"?
>
> BTW, i am interested in the functional aspect too. i've seen MFIs have someone
> responsible for verifying customers (and loan applications) that is
> independent of the field officer or other person that introduced them, and,
> that seems to be the genesis for "approving" customers.
>
> Thanks,
> krishnan
>
> --- On Thu, 30/7/09, Jeff Blue <[email protected]> wrote:
>>
>> From: Jeff Blue <[email protected]>
>> Subject: Re: [Mifos-users] FW: Help with configuration?
>> To: "A good place to start for users or folks new to Mifos."
>> <[email protected]>
>> Date: Thursday, 30 July, 2009, 4:43 PM
>>
>> Dropping 'pending approval' has historically been error prone in Mifos. I
>> don't think that option was ever really debugged. We at SEM tried and gave
>> up. I haven't been watching this issue recently, so I could be wrong about
>> current versions. You might revisit Issue # 2091 and the following two
>> threads from the Developer's List (predating the existence of the User's
>> List):
>>
>> http://sourceforge.net/mailarchive/message.php?msg_name=ec5f16190902102018x64
>> b4a16dyca42a3ddb74c2773%40mail.gmail.com
>>
>> http://sourceforge.net/mailarchive/message.php?msg_name=487E55A4.1050201%40em
>> barqmail.com
>>
>> Good luck,
>> Jeff Blue
>> working with SEM (sem-fund.org)
>>
>> Ryan Whitney wrote:
>>> Sorry, I wanted to clarify what I was talking about below. You should run
>>> those SQL commands that are identified in the configuration instructions on
>>> a fresh instance of the mifos database BEFORE you start mifos for the first
>>> time on that db.
>>>
>>> r
>>>
>>>
>>> On 7/30/09 8:54, "Ryan Whitney" <[email protected]> wrote:
>>>
>>>> Leah,
>>>>
>>>> Looking at the log it looks like the primary proplem you are having is with
>>>> the Client Pending Approval option in the configuration file. Did you try
>>>> running the database workaround identified in the configuration
>>>> instructions?
>>>>
>>>> I suspect that what you might need to do is load a fresh copy of the Mifos
>>>> database and then run each of those SQL commands identified in the config
>>>> instructions in regards to changing the approval processes. I would then
>>>> make sure you are doing that for each of those approval changes you are
>>>> making as the one error we are seeing may just be the first one Mifos runs
>>>> into before stopping (so if you fix just that one, it will then trigger the
>>>> next one)
>>>>
>>>> Let us know how it works out.
>>>>
>>>> Oh, and as an aside, I am interested to know why you are removing all the
>>>> approval steps?
>>>>
>>>> Thanks,
>>>> Ryan
>>>>
>>>> On 7/30/09 6:50, "Leah Morgan" <[email protected]> wrote:
>>>>
>>>>> Hi Ryan,
>>>>>
>>>>> Thanks for your help. In response to your questions:
>>>>>
>>>>> 1. When we put the original configuration file in place, Mifos starts
>>>>> successfully.
>>>>>
>>>>> 2. I removed the pending approvals before running the database - we
>>>>> started from a fresh database (at least I think that's what we did -
>>>>> stopped tomcat, dropped the database, then installed mifos again).
>>>>>
>>>>> 3. I've copied the log below. Is this what you're looking for? If I
>>>>> understand it correctly, it looks like I need to change the pending
>>>>> approval part like you mentioned. If I change the approvals back to
>>>>> default, should it work?
>>>>>
>>>>> Thanks!
>>>>>
>>>>> Leah
>>>>>
>>>>> 30-Apr-2009 08:42:50 org.apache.catalina.core.StandardContext
>>>>> listenerStart
>>>>> SEVERE: Exception sending context initialized event to listener instance
>>>>> of class org.mifos.framework.ApplicationInitializer
>>>>> java.lang.Error:
>>>>> org.mifos.application.configuration.exceptions.ConfigurationException: The
>>>>> value for key ProcessFlow.ClientPendingApprovalStateEnabled in the file
>>>>> applicationConfiguration.custom.properties must to be set to 1 because it
>>>>> was set to 1 in the database, hence can't be set to to 0 in the custom
>>>>> configuration file as this might invalidate existing data. Records for
>>>>> clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.jav
>>>>> a:229)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationI
>>>>> nitializer.java:139)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.jav
>>>>> a:3934)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java
>>>>> :791)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>>>>> at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:850)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:724)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
>>>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
>>>>> at
>>>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupp
>>>>> ort.java:119)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>>>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>>>>> at
>>>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>>>>> at
>>>>> org.apache.catalina.core.StandardService.start(StandardService.java:516)
>>>>> at
>>>>> org.apache..catalina.core.StandardServer.start(StandardServer.java:710)
>>>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>>>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
>>>>> Caused by:
>>>>> org.mifos.application.configuration.exceptions..ConfigurationException:
>>>>> The value for key ProcessFlow.ClientPendingApprovalStateEnabled in the
>>>>> file applicationConfiguration.custom.properties must to be set to 1
>>>>> because it was set to 1 in the database, hence can't be set to to 0 in the
>>>>> custom configuration file as this might invalidate existing data. Records
>>>>> for clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.config.ProcessFlowRules.initClientPendingApprovalState(ProcessFl
>>>>> owRules.java:147)
>>>>> at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.jav
>>>>> a:199)
>>>>> ... 25 more
>>>>> 30-Apr-2009 08:42:54 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextInitialized()
>>>>> 30-Apr-2009 08:42:54 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextInitialized()
>>>>> 30-Apr-2009 16:17:53 org.apache.catalina.core.StandardContext
>>>>> listenerStart
>>>>> SEVERE: Exception sending context initialized event to listener instance
>>>>> of class org.mifos.framework.ApplicationInitializer
>>>>> java.lang.Error:
>>>>> org.mifos.application.configuration.exceptions.ConfigurationException: The
>>>>> value for key ProcessFlow.ClientPendingApprovalStateEnabled in the file
>>>>> applicationConfiguration.custom.properties must to be set to 1 because it
>>>>> was set to 1 in the database, hence can't be set to to 0 in the custom
>>>>> configuration file as this might invalidate existing data. Records for
>>>>> clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer..init(ApplicationInitializer.ja
>>>>> va:229)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationI
>>>>> nitializer.java:139)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.jav
>>>>> a:3934)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java
>>>>> :791)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>>>>> at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:850)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:724)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
>>>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
>>>>> at
>>>>> org..apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup
>>>>> port.java:119)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>>>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>>>>> at
>>>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>>>>> at
>>>>> org.apache.catalina.core.StandardService.start(StandardService.java:516)
>>>>> at
>>>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>>>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>>>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
>>>>> Caused by:
>>>>> org.mifos.application.configuration.exceptions.ConfigurationException: The
>>>>> value for key ProcessFlow.ClientPendingApprovalStateEnabled in the file
>>>>> applicationConfiguration.custom.properties must to be set to 1 because it
>>>>> was set to 1 in the database, hence can't be set to to 0 in the custom
>>>>> configuration file as this might invalidate existing data. Records for
>>>>> clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.config.ProcessFlowRules.initClientPendingApprovalState(ProcessFl
>>>>> owRules.java:147)
>>>>> at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.jav
>>>>> a:199)
>>>>> ... 25 more
>>>>> 30-Apr-2009 16:17:57 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextInitialized()
>>>>> 30-Apr-2009 16:17:57 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextInitialized()
>>>>> 30-Apr-2009 16:22:01 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextDestroyed()
>>>>> 30-Apr-2009 16:22:01 org.apache..catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextDestroyed()
>>>>> 30-Apr-2009 16:46:49 org.apache.catalina.core.StandardContext
>>>>> listenerStart
>>>>> SEVERE: Exception sending context initialized event to listener instance
>>>>> of class org.mifos.framework.ApplicationInitializer
>>>>> java.lang.Error:
>>>>> org.mifos.application.configuration.exceptions.ConfigurationException: The
>>>>> value for key ProcessFlow.ClientPendingApprovalStateEnabled in the file
>>>>> applicationConfiguration.custom.properties must to be set to 1 because it
>>>>> was set to 1 in the database, hence can't be set to to 0 in the custom
>>>>> configuration file as this might invalidate existing data. Records for
>>>>> clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.jav
>>>>> a:229)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationI
>>>>> nitializer.java:139)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.jav
>>>>> a:3934)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java
>>>>> :791)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>>>>> at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:850)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:724)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
>>>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
>>>>> at
>>>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupp
>>>>> ort.java:119)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>>>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>>>>> at
>>>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>>>>> at
>>>>> org.apache.catalina.core.StandardService.start(StandardService.java:516)
>>>>> at
>>>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>>>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>>> at org.apache.catalina.startup.Bootstrap..start(Bootstrap.java:288)
>>>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
>>>>> Caused by:
>>>>> org.mifos.application..configuration.exceptions.ConfigurationException:
>>>>> The value for key ProcessFlow.ClientPendingApprovalStateEnabled in the
>>>>> file applicationConfiguration.custom.properties must to be set to 1
>>>>> because it was set to 1 in the database, hence can't be set to to 0 in the
>>>>> custom configuration file as this might invalidate existing data. Records
>>>>> for clients in the 'pending approval' state may already exist. Also,
>>>>> applicationConfiguration.default.properties must never be changed--make
>>>>> sure this file is untouched.
>>>>> at
>>>>> org.mifos.config.ProcessFlowRules.initClientPendingApprovalState(ProcessFl
>>>>> owRules.java:147)
>>>>> at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
>>>>> at
>>>>> org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.jav
>>>>> a:199)
>>>>> ... 25 more
>>>>> 30-Apr-2009 16:46:52 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextInitialized()
>>>>> 30-Apr-2009 16:46:52 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextInitialized()
>>>>> 30-Apr-2009 16:49:46 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextDestroyed()
>>>>> 30-Apr-2009 16:49:46 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextDestroyed()
>>>>> 30-Apr-2009 16:55:55 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: ContextListener: contextInitialized()
>>>>> 30-Apr-2009 16:55:55 org.apache.catalina.core.ApplicationContext log
>>>>> INFO: SessionListener: contextInitialized()
>>>>>
>>>>> On Thu, Jul 30, 2009 at 1:21 PM, Ryan Whitney
>>>>> <[email protected]> wrote:
>>>>>> Hello Leah,
>>>>>>
>>>>>> Forwarding this to the user¹s group as I figure more people can benefit
>>>>>> from
>>>>>> troubleshooting this issue.
>>>>>>
>>>>>> A few questions
>>>>>> 1. When you remove the configuration file, does Mifos start successfully?
>>>>>> 2. I noticed that you removed a lot of the pending approvals. As noted
>>>>>> in
>>>>>> the file there remain some issues with these features. Did you turn
>>>>>> these
>>>>>> on after running the database an initial time? Have you tried starting
>>>>>> from
>>>>>> a database that's fresh?
>>>>>> 3. Lastly, looking at some of the log files should help. If you look in
>>>>>> the
>>>>>> directory where you started mifos, there should be a mifos log file.
>>>>>> Look
>>>>>> at that and see if there is an error that corresponds to when you start
>>>>>> tomcat and post it here. You can also look in the logs directory of
>>>>>> tomcat.
>>>>>>
>>>>>> Let us know,
>>>>>> Ryan
>>>>>> --
>>>>>> Ryan Whitney
>>>>>> Mifos Technical Program Manager
>>>>>> [email protected]
>>>>>> Mifos - Technology that Empowers Microfinance (www.mifos.org
>>>>>> <http://www.mifos.org/> <http://www.mifos.org <http://www.mifos.org/> >
>>>>>> )
>>>>>>
>>>>>> ------ Forwarded Message
>>>>>> From: Leah Morgan <[email protected]>
>>>>>> Date: Thu, 30 Jul 2009 09:33:41 +0000
>>>>>> To: <[email protected]>
>>>>>> Subject: Help with configuration?
>>>>>>
>>>>>> Hi Ryan,
>>>>>>
>>>>>> I spent some time working with mifos, only to realize that we needed to
>>>>>> reconfigure some of the settings - like the rounding decimal places, etc.
>>>>>> Our volunteer developer walked me through it over the phone, but I'm
>>>>>> afraid
>>>>>> I messed up because mifos won't open when I use the configuration
>>>>>> document I
>>>>>> edited (I get the "HTTP Status 404 - the requested resource () is not
>>>>>> available" message).
>>>>>>
>>>>>> Our developer is now on vacation and I'm stuck. Is there any way you
>>>>>> could
>>>>>> review the configuration document and see what I did wrong? I'd really
>>>>>> appreciate any help you can send my way!
>>>>>>
>>>>>> Thanks so much.
>>>>>>
>>>>>> Sincerely,
>>>>>>
>>>>>> Leah
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Leah Morgan
>>>>>> Program Manager
>>>>>> Chapter 58 Trust
>>>>>>
>>>>>> US Mobile: +1 678 438 4059
>>>>>> Ghana Mobile: +233 (0)20 647 7785
>>>>>>
>>>>>> Skype: leahmorgan
>>>>>>
>>>>>>
>>>>>> ------ End of Forwarded Message
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------------------------
>>>>>> -----
>>>>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>>>>> 30-Day
>>>>>> trial. Simplify your report design, integration and deployment - and
>>>>>> focus on
>>>>>> what you do best, core application coding. Discover what's new with
>>>>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>>>>> _______________________________________________
>>>>>> Mifos-users mailing list
>>>>>> [email protected]
>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>
>>>>>
--
Ryan Whitney
Mifos Technical Program Manager
[email protected]
Mifos - Technology that Empowers Microfinance (www.mifos.org)
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
