Created
October 8, 2014 12:51
-
-
Save derDieDasJojo/71db64f2c52830d42e71 to your computer and use it in GitHub Desktop.
create report error
This file contains 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
| 2014-10-08 14:31:29,549 [qtp256004657-65] WARN o.k.b.j.mappers.ExceptionMapperBase - Internal error | |
| org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: java.sql.SQLIntegrityConstraintViolationException: Column 'report_type' cannot be null [statement:"addReportConfiguration", located:"insert into analytics_reports ( | |
| report_name | |
| , report_pretty_name | |
| , report_type | |
| , source_table_name | |
| , refresh_procedure_name | |
| , refresh_frequency | |
| , refresh_hour_of_day_gmt | |
| ) values ( | |
| :reportName | |
| , :reportPrettyName | |
| , :reportType | |
| , :sourceTableName | |
| , :refreshProcedureName | |
| , :refreshFrequency | |
| , :refreshHourOfDayGmt | |
| );", rewritten:"insert into analytics_reports ( | |
| report_name | |
| , report_pretty_name | |
| , report_type | |
| , source_table_name | |
| , refresh_procedure_name | |
| , refresh_frequency | |
| , refresh_hour_of_day_gmt | |
| ) values ( | |
| ? | |
| , ? | |
| , ? | |
| , ? | |
| , ? | |
| , ? | |
| , ? | |
| );", arguments:{ positional:{}, named:{recordId:null,reportType:null,refreshHourOfDayGmt:null,sourceTableName:'v_new_accounts_per_day',reportName:'new_accounts_per_day',reportPrettyName:'New accounts created (per day)',refreshFrequency:null,refreshProcedureName:null,class:class org.killbill.billing.plugin.analytics.reports.configuration.ReportsConfigurationModelDao}, finder:[]}] | |
| at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1334) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.Update.execute(Update.java:56) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.UpdateHandler$2.value(UpdateHandler.java:60) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.UpdateHandler.invoke(UpdateHandler.java:72) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:171) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject$1.intercept(SqlObject.java:75) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.CloseInternalDoNotUseThisClass$$EnhancerByCGLIB$$7af47a37.addReportConfiguration(<generated>) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.reports.ReportsConfiguration$1.inTransaction(ReportsConfiguration.java:48) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.reports.ReportsConfiguration$1.inTransaction(ReportsConfiguration.java:45) ~[na:na] | |
| at org.skife.jdbi.v2.sqlobject.InTransactionHandler$1.inTransaction(InTransactionHandler.java:35) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.tweak.transactions.LocalTransactionHandler.inTransaction(LocalTransactionHandler.java:192) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.tweak.transactions.DelegatingTransactionHandler.inTransaction(DelegatingTransactionHandler.java:82) ~[jdbi-2.53.jar:2.53] | |
| at org.killbill.commons.jdbi.transaction.RestartTransactionRunner.inTransaction(RestartTransactionRunner.java:61) ~[killbill-jdbi-0.2.26.jar:na] | |
| at org.skife.jdbi.v2.BasicHandle.inTransaction(BasicHandle.java:306) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.InTransactionHandler.invoke(InTransactionHandler.java:31) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:171) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject$1.intercept(SqlObject.java:75) ~[jdbi-2.53.jar:2.53] | |
| at org.skife.jdbi.v2.sqlobject.CloseInternalDoNotUseThisClass$$EnhancerByCGLIB$$7af47a37.inTransaction(<generated>) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.reports.ReportsConfiguration.createReportConfiguration(ReportsConfiguration.java:45) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.reports.ReportsUserApi.createReport(ReportsUserApi.java:125) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.http.ReportsServlet.doPost(ReportsServlet.java:94) ~[na:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at org.killbill.billing.plugin.analytics.http.ServletRouter.forward(ServletRouter.java:101) ~[na:na] | |
| at org.killbill.billing.plugin.analytics.http.ServletRouter.doPost(ServletRouter.java:68) ~[na:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_20] | |
| at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_20] | |
| at org.killbill.billing.osgi.ContextClassLoaderHelper$1$1.execute(ContextClassLoaderHelper.java:83) ~[killbill-platform-osgi-0.0.13.jar:na] | |
| at org.killbill.commons.profiling.Profiling.executeWithProfiling(Profiling.java:33) ~[killbill-concurrent-0.2.26.jar:na] | |
| at org.killbill.billing.osgi.ContextClassLoaderHelper$1.invoke(ContextClassLoaderHelper.java:80) ~[killbill-platform-osgi-0.0.13.jar:na] | |
| at com.sun.proxy.$Proxy129.service(Unknown Source) ~[na:na] | |
| at org.killbill.billing.osgi.http.OSGIServlet.serviceViaPlugin(OSGIServlet.java:82) ~[killbill-platform-osgi-0.0.13.jar:na] | |
| at org.killbill.billing.osgi.http.OSGIServlet.doPost(OSGIServlet.java:55) ~[killbill-platform-osgi-0.0.13.jar:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at org.killbill.billing.jaxrs.resources.PluginResource.serviceViaOSGIPlugin(PluginResource.java:174) ~[killbill-jaxrs-0.11.13-SNAPSHOT.jar:na] | |
| at org.killbill.billing.jaxrs.resources.PluginResource.serviceViaOSGIPlugin(PluginResource.java:160) ~[killbill-jaxrs-0.11.13-SNAPSHOT.jar:na] | |
| at org.killbill.billing.jaxrs.resources.PluginResource.doPOST(PluginResource.java:134) ~[killbill-jaxrs-0.11.13-SNAPSHOT.jar:na] | |
| at com.palominolabs.metrics.guice.TimedInterceptor.invoke(TimedInterceptor.java:47) ~[metrics-guice-3.0.2.jar:na] | |
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_20] | |
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_20] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_20] | |
| at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_20] | |
| at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [jersey-server-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [jersey-servlet-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540) [jersey-servlet-1.18.1.jar:1.18.1] | |
| at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715) [jersey-servlet-1.18.1.jar:1.18.1] | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [javax.servlet-3.0.0.v201112011016.jar:na] | |
| at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:na] | |
| at org.killbill.billing.server.security.TenantFilter.doFilter(TenantFilter.java:112) [classes/:na] | |
| at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:na] | |
| at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:na] | |
| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484) [jetty-servlet-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) [shiro-web-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) [shiro-web-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) [shiro-core-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) [shiro-web-1.2.3.jar:1.2.3] | |
| at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) [shiro-web-1.2.3.jar:1.2.3] | |
| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476) [jetty-servlet-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:499) [jetty-servlet-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) [jetty-security-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428) [jetty-servlet-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:126) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.Server.handle(Server.java:370) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) [jetty-http-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) [jetty-http-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264) [jetty-server-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) [jetty-util-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) [jetty-util-8.1.14.v20131031.jar:8.1.14.v20131031] | |
| at java.lang.Thread.run(Thread.java:745) [na:1.8.0_20] | |
| Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'report_type' cannot be null | |
| at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:132) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.MySQLPreparedStatement.execute(MySQLPreparedStatement.java:141) ~[mariadb-java-client-1.1.7.jar:na] | |
| at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.execute(PreparedStatementJavassistProxy.java) ~[na:na] | |
| at net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy.execute(PreparedStatementSpy.java:443) ~[log4jdbc-log4j2-jdbc4-1.16.jar:na] | |
| at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1328) ~[jdbi-2.53.jar:2.53] | |
| ... 104 common frames omitted | |
| Caused by: org.mariadb.jdbc.internal.common.QueryException: Column 'report_type' cannot be null | |
| at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:942) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:991) ~[mariadb-java-client-1.1.7.jar:na] | |
| at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281) ~[mariadb-java-client-1.1.7.jar:na] | |
| ... 108 common frames omitted |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment