{"action":"opened","issue":{"url":"https://api.github.com/repos/B3Partners/brmo/issues/86","labels_url":"https://api.github.com/repos/B3Partners/brmo/issues/86/labels{/name}","comments_url":"https://api.github.com/repos/B3Partners/brmo/issues/86/comments","events_url":"https://api.github.com/repos/B3Partners/brmo/issues/86/events","html_url":"https://github.com/B3Partners/brmo/issues/86","id":110950520,"number":86,"title":"inlezen (BRK) stand mislukt met oracle database","user":{"login":"mprins","id":1165786,"avatar_url":"https://avatars.githubusercontent.com/u/1165786?v=3","gravatar_id":"","url":"https://api.github.com/users/mprins","html_url":"https://github.com/mprins","followers_url":"https://api.github.com/users/mprins/followers","following_url":"https://api.github.com/users/mprins/following{/other_user}","gists_url":"https://api.github.com/users/mprins/gists{/gist_id}","starred_url":"https://api.github.com/users/mprins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mprins/subscriptions","organizations_url":"https://api.github.com/users/mprins/orgs","repos_url":"https://api.github.com/users/mprins/repos","events_url":"https://api.github.com/users/mprins/events{/privacy}","received_events_url":"https://api.github.com/users/mprins/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/B3Partners/brmo/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"mprins","id":1165786,"avatar_url":"https://avatars.githubusercontent.com/u/1165786?v=3","gravatar_id":"","url":"https://api.github.com/users/mprins","html_url":"https://github.com/mprins","followers_url":"https://api.github.com/users/mprins/followers","following_url":"https://api.github.com/users/mprins/following{/other_user}","gists_url":"https://api.github.com/users/mprins/gists{/gist_id}","starred_url":"https://api.github.com/users/mprins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mprins/subscriptions","organizations_url":"https://api.github.com/users/mprins/orgs","repos_url":"https://api.github.com/users/mprins/repos","events_url":"https://api.github.com/users/mprins/events{/privacy}","received_events_url":"https://api.github.com/users/mprins/received_events","type":"User","site_admin":false},"milestone":null,"comments":0,"created_at":"2015-10-12T10:40:50Z","updated_at":"2015-10-12T10:40:50Z","closed_at":null,"body":"Bij een nieuwe staging database mislukt het inlezen van een stand bestand met de volgende fout:\r\n\r\n`Fout bij inlezen bestand: SQLException: ORA-01400: cannot insert NULL into (\"STAGINGTEST\".\"LAADPROCES\".\"ID\")`\r\n\r\nlogfile:\r\n```\r\nFout bij inlezen bestand\r\nnl.b3p.brmo.loader.util.BrmoException: Fout bij loaden basisregistratie gegevens\r\n\tat nl.b3p.brmo.loader.BrmoFramework.loadFromStream(BrmoFramework.java:259)\r\n\tat nl.b3p.brmo.service.stripes.BasisregistratieFileUploadActionBean.upload(BasisregistratieFileUploadActionBean.java:88)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(DispatcherHelper.java:456)\r\n\tat net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:158)\r\n\tat net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.intercept(BeforeAfterMethodInterceptor.java:113)\r\n\tat net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155)\r\n\tat org.stripesstuff.plugin.waitpage.WaitPageInterceptor.intercept(WaitPageInterceptor.java:175)\r\n\tat net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155)\r\n\tat net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionContext.java:74)\r\n\tat net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandler(DispatcherHelper.java:454)\r\n\tat net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandler(DispatcherServlet.java:278)\r\n\tat net.sourceforge.stripes.controller.DispatcherServlet.service(DispatcherServlet.java:160)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:725)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)\r\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)\r\n\tat org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)\r\n\tat org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)\r\n\tat org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)\r\n\tat org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)\r\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)\r\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.sql.SQLException: ORA-01400: cannot insert NULL into (\"STAGINGTEST\".\"LAADPROCES\".\"ID\")\r\nQuery: INSERT INTO laadproces(bestand_naam,bestand_datum, soort, gebied, opmerking, status,status_datum, contact_email) VALUES (?,?,?,?,?,?,?,?) Parameters: [BURKX01-ZWD03-20140731.zip/BURKX01.xml, 2014-07-31 00:00:00.0, brk, Zeewolde, null, STAGING_OK, 2015-10-12 12:37:35.463, null]\r\n\tat org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)\r\n\tat org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491)\r\n\tat org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:404)\r\n\tat nl.b3p.brmo.loader.StagingProxy.writeLaadProces(StagingProxy.java:614)\r\n\tat nl.b3p.brmo.loader.StagingProxy.loadBr(StagingProxy.java:515)\r\n\tat nl.b3p.brmo.loader.BrmoFramework.loadFromStream(BrmoFramework.java:257)\r\n```\r\n"}}