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=ec5f16190902102018x64b4a16dyca42a3ddb74c2773%40mail.gmail.com
http://sourceforge.net/mailarchive/message.php?msg_name=487E55A4.1050201%40embarqmail.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.java:229)
at
org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationInitializer.java:139)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java: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(LifecycleSupport.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(ProcessFlowRules.java:147)
at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
at
org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java: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.java:229)
at
org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationInitializer.java:139)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java: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(LifecycleSupport.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(ProcessFlowRules.java:147)
at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
at
org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java: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.java:229)
at
org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationInitializer.java:139)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java: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(LifecycleSupport.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(ProcessFlowRules.java:147)
at org.mifos.config.ProcessFlowRules.init(ProcessFlowRules.java:64)
at
org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java: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> )
------ 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
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
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
-----Inline Attachment Follows-----
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
Yahoo! recommends that you upgrade to the new and safer Internet Explorer
8. http://downloads.yahoo.com/in/internetexplorer/------------------------------------------------------------------------------
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
