Created
February 12, 2013 15:09
-
-
Save amichaelgrant/4770504 to your computer and use it in GitHub Desktop.
After login
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| HTTP Status 500 - | |
| type Exception report | |
| message | |
| description The server encountered an internal error () that prevented it from fulfilling this request. | |
| exception | |
| org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select c.account_no as accountNo, c.office_id as officeId, o.name as officeName, c.id as id, c.firstname as firstname, c.middlename as middlename, c.lastname as lastname, c.fullname as fullname, c.display_name as displayName, c.external_id as externalId, c.joined_date as joinedDate, c.image_key as imagekey from m_client c join m_office o on o.id = c.office_id where o.hierarchy like ? and c.is_deleted=0 and ( (display_name like '%%') and o.hierarchy like '.%') order by c.display_name ASC, c.account_no ASC]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'c.account_no' in 'field list' | |
| org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) | |
| org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) | |
| org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717) | |
| org.mifosplatform.portfolio.client.service.ClientReadPlatformServiceImpl.retrieveAllIndividualClients(ClientReadPlatformServiceImpl.java:70) | |
| org.mifosplatform.portfolio.client.api.ClientsApiResource.retrieveAllIndividualClients(ClientsApiResource.java:97) | |
| sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
| sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
| sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
| java.lang.reflect.Method.invoke(Method.java:616) | |
| com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) | |
| com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) | |
| com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) | |
| com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) | |
| com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) | |
| com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) | |
| com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) | |
| com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) | |
| com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) | |
| com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:722) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) | |
| org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) | |
| org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) | |
| org.mifosplatform.infrastructure.security.filter.TenantAwareBasicAuthenticationFilter.doFilter(TenantAwareBasicAuthenticationFilter.java:91) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) | |
| org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) | |
| org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) | |
| org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) | |
| root cause | |
| com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'c.account_no' in 'field list' | |
| sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) | |
| sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) | |
| sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) | |
| java.lang.reflect.Constructor.newInstance(Constructor.java:532) | |
| com.mysql.jdbc.Util.handleNewInstance(Util.java:411) | |
| com.mysql.jdbc.Util.getInstance(Util.java:386) | |
| com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) | |
| com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) | |
| com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) | |
| com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) | |
| com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) | |
| com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) | |
| com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) | |
| com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) | |
| sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) | |
| sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
| java.lang.reflect.Method.invoke(Method.java:616) | |
| org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) | |
| $Proxy166.executeQuery(Unknown Source) | |
| org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643) | |
| org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) | |
| org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717) | |
| org.mifosplatform.portfolio.client.service.ClientReadPlatformServiceImpl.retrieveAllIndividualClients(ClientReadPlatformServiceImpl.java:70) | |
| org.mifosplatform.portfolio.client.api.ClientsApiResource.retrieveAllIndividualClients(ClientsApiResource.java:97) | |
| sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
| sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
| sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
| java.lang.reflect.Method.invoke(Method.java:616) | |
| com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) | |
| com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) | |
| com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) | |
| com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) | |
| com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) | |
| com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) | |
| com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) | |
| com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) | |
| com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) | |
| com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) | |
| com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:722) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) | |
| org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) | |
| org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) | |
| org.mifosplatform.infrastructure.security.filter.TenantAwareBasicAuthenticationFilter.doFilter(TenantAwareBasicAuthenticationFilter.java:91) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144) | |
| org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) | |
| org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) | |
| org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) | |
| org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) | |
| org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) | |
| note The full stack trace of the root cause is available in the Apache Tomcat/7.0.26 logs. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment