[Mifos-users] help(Internal Server Error 500)

[test s]

I am trying the creation of client on the Mifos X demo server 

initially i went admintab->system->manage report->created demo simple report  submitted

and next i went to reports->client->select the demo simple report wen click on run   

->I am getting this error.

Internal Server Error [500]

localhostlog showing this message

 

Jul 02, 2014 10:18:31 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Jul 02, 2014 10:18:32 AM org.apache.catalina.core.ApplicationContext log


INFO: Initializing Spring root WebApplicationContext

Catalina log is showing this message

Jul 02, 2014 10:18:05 AM org.apache.catalina.core.

AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\Program Files (x86)\PC Connectivity Solution\;C:\Program Files\Java\jdk1.7.0_45\bin;.;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.7.0_45;\binC:\Program Files (x86)\Sony\VAIO Startup Setting Tool;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.6\;C:\HashiCorp\Vagrant\bin;C:\Program Files\nodejs\;;.
Jul 02, 2014 10:18:05 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jul 02, 2014 10:18:05 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8443"]
Jul 02, 2014 10:18:06 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Jul 02, 2014 10:18:06 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1239 ms
Jul 02, 2014 10:18:06 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jul 02, 2014 10:18:06 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.54
Jul 02, 2014 10:18:06 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\mifosng-provider.war
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.servlet.SpringServlet getContext
INFO: Using default applicationContext
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, GLClosuresApiResource, of type org.mifosplatform.accounting.closure.api.GLClosuresApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, GLAccountsApiResource, of type org.mifosplatform.accounting.glaccount.api.GLAccountsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, journalEntriesApiResource, of type org.mifosplatform.accounting.journalentry.api.JournalEntriesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, accountingRuleApiResource, of type org.mifosplatform.accounting.rule.api.AccountingRuleApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, auditsApiResource, of type org.mifosplatform.commands.api.AuditsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, makercheckersApiResource, of type org.mifosplatform.commands.api.MakercheckersApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, cacheApiResource, of type org.mifosplatform.infrastructure.cache.api.CacheApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, codesApiResource, of type org.mifosplatform.infrastructure.codes.api.CodesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, codeValuesApiResource, of type org.mifosplatform.infrastructure.codes.api.CodeValuesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, globalConfigurationApiResource, of type org.mifosplatform.infrastructure.configuration.api.GlobalConfigurationApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, accessDeniedExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.AccessDeniedExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, badCredentialsExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.BadCredentialsExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, invalidJsonExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.InvalidJsonExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, invalidTenantIdentifierExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.InvalidTenantIdentifierExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, jsonSyntaxExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.JsonSyntaxExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, malformedJsonExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.MalformedJsonExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, noAuthorizationExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.NoAuthorizationExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformApiDataValidationExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformApiDataValidationExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformDataIntegrityExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformDataIntegrityExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformDomainRuleExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformDomainRuleExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformInternalServerExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformInternalServerExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformResourceNotFoundExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformResourceNotFoundExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, platformServiceUnavailableExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.PlatformServiceUnavailableExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, unAuthenticatedUserExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.UnAuthenticatedUserExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, unrecognizedQueryParamExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.UnrecognizedQueryParamExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, unsupportedCommandExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.UnsupportedCommandExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, unsupportedParameterExceptionMapper, of type org.mifosplatform.infrastructure.core.exceptionmapper.UnsupportedParameterExceptionMapper as a provider class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, datatablesApiResource, of type org.mifosplatform.infrastructure.dataqueries.api.DatatablesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, reportsApiResource, of type org.mifosplatform.infrastructure.dataqueries.api.ReportsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, runreportsApiResource, of type org.mifosplatform.infrastructure.dataqueries.api.RunreportsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, documentManagementApiResource, of type org.mifosplatform.infrastructure.documentmanagement.api.DocumentManagementApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, imagesApiResource, of type org.mifosplatform.infrastructure.documentmanagement.api.ImagesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, schedulerApiResource, of type org.mifosplatform.infrastructure.jobs.api.SchedulerApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, schedulerJobApiResource, of type org.mifosplatform.infrastructure.jobs.api.SchedulerJobApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, authenticationApiResource, of type org.mifosplatform.infrastructure.security.api.AuthenticationApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, smsApiResource, of type org.mifosplatform.infrastructure.sms.api.SmsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, holidaysApiResource, of type org.mifosplatform.organisation.holiday.api.HolidaysApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, currenciesApiResource, of type org.mifosplatform.organisation.monetary.api.CurrenciesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, officesApiResource, of type org.mifosplatform.organisation.office.api.OfficesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, officeTransactionsApiResource, of type org.mifosplatform.organisation.office.api.OfficeTransactionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, staffApiResource, of type org.mifosplatform.organisation.staff.api.StaffApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, bulkLoansApiResource, of type org.mifosplatform.portfolio.loanaccount.api.BulkLoansApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, loanChargesApiResource, of type org.mifosplatform.portfolio.loanaccount.api.LoanChargesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, loanDisbursementDetailApiResource, of type org.mifosplatform.portfolio.loanaccount.api.LoanDisbursementDetailApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, loansApiResource, of type org.mifosplatform.portfolio.loanaccount.api.LoansApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, loanTransactionsApiResource, of type org.mifosplatform.portfolio.loanaccount.api.LoanTransactionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, guarantorsApiResource, of type org.mifosplatform.portfolio.loanaccount.guarantor.api.GuarantorsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, accountTransfersApiResource, of type org.mifosplatform.portfolio.account.api.AccountTransfersApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, standingInstructionApiResource, of type org.mifosplatform.portfolio.account.api.StandingInstructionApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, calendarsApiResource, of type org.mifosplatform.portfolio.calendar.api.CalendarsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, chargesApiResource, of type org.mifosplatform.portfolio.charge.api.ChargesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, clientIdentifiersApiResource, of type org.mifosplatform.portfolio.client.api.ClientIdentifiersApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, clientsApiResource, of type org.mifosplatform.portfolio.client.api.ClientsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, collateralsApiResource, of type org.mifosplatform.portfolio.collateral.api.CollateralsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, fundsApiResource, of type org.mifosplatform.portfolio.fund.api.FundsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, centersApiResource, of type org.mifosplatform.portfolio.group.api.CentersApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, groupsApiResource, of type org.mifosplatform.portfolio.group.api.GroupsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, groupsLevelApiResource, of type org.mifosplatform.portfolio.group.api.GroupsLevelApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, interestRateChartsApiResource, of type org.mifosplatform.portfolio.interestratechart.api.InterestRateChartsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, interestRateChartSlabsApiResource, of type org.mifosplatform.portfolio.interestratechart.api.InterestRateChartSlabsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, loanProductsApiResource, of type org.mifosplatform.portfolio.loanproduct.api.LoanProductsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, productMixApiResource, of type org.mifosplatform.portfolio.loanproduct.productmix.api.ProductMixApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, meetingsApiResource, of type org.mifosplatform.portfolio.meeting.api.MeetingsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, notesApiResource, of type org.mifosplatform.portfolio.note.api.NotesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, fixedDepositAccountsApiResource, of type org.mifosplatform.portfolio.savings.api.FixedDepositAccountsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, fixedDepositAccountTransactionsApiResource, of type org.mifosplatform.portfolio.savings.api.FixedDepositAccountTransactionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, fixedDepositProductsApiResource, of type org.mifosplatform.portfolio.savings.api.FixedDepositProductsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, recurringDepositAccountsApiResource, of type org.mifosplatform.portfolio.savings.api.RecurringDepositAccountsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, recurringDepositAccountTransactionsApiResource, of type org.mifosplatform.portfolio.savings.api.RecurringDepositAccountTransactionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, recurringDepositProductsApiResource, of type org.mifosplatform.portfolio.savings.api.RecurringDepositProductsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, savingsAccountChargesApiResource, of type org.mifosplatform.portfolio.savings.api.SavingsAccountChargesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, savingsAccountsApiResource, of type org.mifosplatform.portfolio.savings.api.SavingsAccountsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, savingsAccountTransactionsApiResource, of type org.mifosplatform.portfolio.savings.api.SavingsAccountTransactionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, savingsProductsApiResource, of type org.mifosplatform.portfolio.savings.api.SavingsProductsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, searchApiResource, of type org.mifosplatform.portfolio.search.api.SearchApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, permissionsApiResource, of type org.mifosplatform.useradministration.api.PermissionsApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, rolesApiResource, of type org.mifosplatform.useradministration.api.RolesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, usersApiResource, of type org.mifosplatform.useradministration.api.UsersApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, mixReportApiResource, of type org.mifosplatform.mix.api.MixReportApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, mixTaxonomyApiResource, of type org.mifosplatform.mix.api.MixTaxonomyApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, mixTaxonomyMappingApiResource, of type org.mifosplatform.mix.api.MixTaxonomyMappingApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans
INFO: Registering Spring bean, templatesApiResource, of type org.mifosplatform.template.api.TemplatesApiResource as a root resource class
Jul 02, 2014 10:19:36 AM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate
INFO: Initiating Jersey application, version 'Jersey: 1.17 01/17/2013 03:31 PM'
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\mifosng-provider.war has finished in 91,634 ms
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\community-app
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\community-app has finished in 310 ms
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\docs
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\docs has finished in 226 ms
Jul 02, 2014 10:19:38 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager
Jul 02, 2014 10:19:39 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager has finished in 379 ms
Jul 02, 2014 10:19:39 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT
Jul 02, 2014 10:19:39 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT has finished in 205 ms
Jul 02, 2014 10:19:39 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Jul 02, 2014 10:19:39 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8443"]
Jul 02, 2014 10:19:39 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Jul 02, 2014 10:19:39 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 93189 ms

[Santosh Math]

@test s

I assume, you want to create a report showing listing of all the clients. May I know what SQL query have you written to create the list of clients? 

or there is already a report namely "Client Listing".. Just goto  Admin>>System>> Manage Reports.. You will see the list of the reports. select "Client Listing" report and open it and click on edit button to see the SQL query..

Regards

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

[stes...@gmail.com]

I am new user to mifosx first time trying to create simple report i hav used the query select c.frist_name ,c.last_name ,c.account_number   from m.clients

went to reports->client->select the demo simple report wen click on run   

->I am getting this error.

Internal Server Error [500]

i cant see the fname and lastname and accno on the tab 

[Santosh Math]

@stest

Before writing the query, you need to know what the each table( m_client, m_group, m_loan, etc) fields(column headings) are.. 

Have you set up the database locally? If so, use HeidiSQL(front-end for sql) software to know what each table contains.

If you want to generate report containing list of clients, try this query.

select mc.firstname, mc.lastname, mc.gender_cv_id

from m_client mc

On Wed, Jul 2, 2014 at 4:54 PM, Santosh Math <san...@confluxtechnologies.com> wrote:

@stest

Before writing the query, you need to know what the each table( m_client, m_group, m_loan, etc) fields(column headings) are.. 

Have you set up the database locally? If so, use HeidiSQL(front-end for sql) software to know what each table contains.

If you want to generate report containing list of clients, try this query.

select mc.firstname, mc.lastname, mc.gender_cv_id

from m_client mc