{"action":"created","issue":{"url":"https://api.github.com/repos/IQSS/dataverse/issues/2542","labels_url":"https://api.github.com/repos/IQSS/dataverse/issues/2542/labels{/name}","comments_url":"https://api.github.com/repos/IQSS/dataverse/issues/2542/comments","events_url":"https://api.github.com/repos/IQSS/dataverse/issues/2542/events","html_url":"https://github.com/IQSS/dataverse/issues/2542","id":107061315,"number":2542,"title":"File Upload: Cannot add and save files only to published dataset null pointer for create date.","user":{"login":"kcondon","id":4983816,"avatar_url":"https://avatars.githubusercontent.com/u/4983816?v=3","gravatar_id":"","url":"https://api.github.com/users/kcondon","html_url":"https://github.com/kcondon","followers_url":"https://api.github.com/users/kcondon/followers","following_url":"https://api.github.com/users/kcondon/following{/other_user}","gists_url":"https://api.github.com/users/kcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/kcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kcondon/subscriptions","organizations_url":"https://api.github.com/users/kcondon/orgs","repos_url":"https://api.github.com/users/kcondon/repos","events_url":"https://api.github.com/users/kcondon/events{/privacy}","received_events_url":"https://api.github.com/users/kcondon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/IQSS/dataverse/labels/Component:%20File%20Upload%20&%20Handling","name":"Component: File Upload & Handling","color":"c7def8"},{"url":"https://api.github.com/repos/IQSS/dataverse/labels/Priority:%20High","name":"Priority: High","color":"e11d21"},{"url":"https://api.github.com/repos/IQSS/dataverse/labels/Status:%20QA","name":"Status: QA","color":"336633"},{"url":"https://api.github.com/repos/IQSS/dataverse/labels/Type:%20Bug","name":"Type: Bug","color":"fef2c0"}],"state":"open","locked":false,"assignee":{"login":"kcondon","id":4983816,"avatar_url":"https://avatars.githubusercontent.com/u/4983816?v=3","gravatar_id":"","url":"https://api.github.com/users/kcondon","html_url":"https://github.com/kcondon","followers_url":"https://api.github.com/users/kcondon/followers","following_url":"https://api.github.com/users/kcondon/following{/other_user}","gists_url":"https://api.github.com/users/kcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/kcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kcondon/subscriptions","organizations_url":"https://api.github.com/users/kcondon/orgs","repos_url":"https://api.github.com/users/kcondon/repos","events_url":"https://api.github.com/users/kcondon/events{/privacy}","received_events_url":"https://api.github.com/users/kcondon/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/IQSS/dataverse/milestones/39","html_url":"https://github.com/IQSS/dataverse/milestones/4.2","labels_url":"https://api.github.com/repos/IQSS/dataverse/milestones/39/labels","id":1143630,"number":39,"title":"4.2","description":"- Permissions performance #2036\r\n- Integrate Terms of Use in Metadata Template\r\n- File landing page (experimental) #2515\r\n- Separation of upload and edit\r\n- Bulk edit of file metadata (select subset of files, rather than edit all files at once)\r\n- Batch tagging (from view mode, to be user tested)\r\n- Batch delete  (from view mode, to be user tested)\r\n- Batch restrict  (from view mode, to be user tested)","creator":{"login":"eaquigley","id":5922904,"avatar_url":"https://avatars.githubusercontent.com/u/5922904?v=3","gravatar_id":"","url":"https://api.github.com/users/eaquigley","html_url":"https://github.com/eaquigley","followers_url":"https://api.github.com/users/eaquigley/followers","following_url":"https://api.github.com/users/eaquigley/following{/other_user}","gists_url":"https://api.github.com/users/eaquigley/gists{/gist_id}","starred_url":"https://api.github.com/users/eaquigley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eaquigley/subscriptions","organizations_url":"https://api.github.com/users/eaquigley/orgs","repos_url":"https://api.github.com/users/eaquigley/repos","events_url":"https://api.github.com/users/eaquigley/events{/privacy}","received_events_url":"https://api.github.com/users/eaquigley/received_events","type":"User","site_admin":false},"open_issues":49,"closed_issues":42,"state":"open","created_at":"2015-06-01T19:53:20Z","updated_at":"2015-09-17T21:32:31Z","due_on":"2015-09-23T04:00:00Z","closed_at":null},"comments":4,"created_at":"2015-09-17T19:53:10Z","updated_at":"2015-09-18T00:12:54Z","closed_at":null,"body":"\r\nWorks for draft, not for published. Uploaded 1 tabular, 1 text. This was happening a couple days ago but was fixed.\r\n\r\nLocal Exception Stack:\r\nException [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: org.postgresql.util.PSQLException: ERROR: null value in column \"createdate\" violates not-null constraint\r\n  Detail: Failing row contains (215, DataFile, null, null, 2015-09-17 15:44:48.017, null, 2015-09-17 15:44:48.017, null, null, 207, null).\r\nError Code: 0\r\nCall: INSERT INTO DVOBJECT (CREATEDATE, INDEXTIME, MODIFICATIONTIME, PERMISSIONINDEXTIME, PERMISSIONMODIFICATIONTIME, PUBLICATIONDATE, CREATOR_ID, OWNER_ID, RELEASEUSER_ID, DTYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n        bind => [10 parameters bound]\r\nQuery: InsertObjectQuery([DataFile id:null name:null])\r\n        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1611)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:898)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)\r\n        at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)\r\n        at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)\r\n        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)\r\n        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:363)\r\n        at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)\r\n        at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180)\r\n        at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489)\r\n        at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)\r\n        at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)\r\n        at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301)\r\n        at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)\r\n        at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)\r\n        at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)\r\n        at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)\r\n        at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)\r\n        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)\r\n        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)\r\n        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)\r\n        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)\r\n        at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:226)\r\n        at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:193)\r\n        at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:138)\r\n        at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4207)\r\n        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)\r\n        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)\r\n        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3168)\r\n        at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:352)\r\n        at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:158)\r\n        at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)\r\n        at com.sun.enterprise.transaction.JavaEETransactionImpl.commit(JavaEETransactionImpl.java:452)\r\n        at com.sun.enterprise.transaction.JavaEETransactionManagerSimplified.commit(JavaEETransactionManagerSimplified.java:854)\r\n        at com.sun.ejb.containers.EJBContainerTransactionManager.completeNewTx(EJBContainerTransactionManager.java:719)\r\n        at com.sun.ejb.containers.EJBContainerTransactionManager.postInvokeTx(EJBContainerTransactionManager.java:503)\r\n        at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4566)\r\n        at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2074)\r\n        at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2044)\r\n        at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:220)\r\n        at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)\r\n        at com.sun.proxy.$Proxy1464.mergeFileMetadata(Unknown Source)\r\n        at edu.harvard.iq.dataverse.__EJB31_Generated__DataFileServiceBean__Intf____Bean__.mergeFileMetadata(Unknown Source)\r\n        at edu.harvard.iq.dataverse.EditDatafilesPage.save(EditDatafilesPage.java:673)\r\n        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n        at java.lang.reflect.Method.invoke(Method.java:606)\r\n        at com.sun.el.parser.AstValue.invoke(AstValue.java:289)\r\n        at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)\r\n        at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)\r\n        at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)\r\n        at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)\r\n        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)\r\n        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)\r\n        at javax.faces.component.UICommand.broadcast(UICommand.java:315)\r\n        at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)\r\n        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)\r\n        at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)\r\n        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)\r\n        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198)\r\n        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:646)\r\n        at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:344)\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)\r\n        at org.glassfish.tyrus.servlet.TyrusServletFilter.doFilter(TyrusServletFilter.java:295)\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)\r\n        at org.ocpsoft.rewrite.servlet.RewriteFilter.doFilter(RewriteFilter.java:205)\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)\r\n        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:316)\r\n        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)\r\n        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)\r\n        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)\r\n        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)\r\n        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)\r\n        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:415)\r\n        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:282)\r\n        at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)\r\n        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)\r\n        at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:201)\r\n        at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:175)\r\n        at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)\r\n        at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)\r\n        at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:284)\r\n        at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:201)\r\n        at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:133)\r\n        at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:112)\r\n        at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)\r\n        at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:561)\r\n        at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)\r\n        at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)\r\n        at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)\r\n        at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)\r\n        at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)\r\n        at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)\r\n        at java.lang.Thread.run(Thread.java:745)\r\nCaused by: org.postgresql.util.PSQLException: ERROR: null value in column \"createdate\" violates not-null constraint\r\n  Detail: Failing row contains (215, DataFile, null, null, 2015-09-17 15:44:48.017, null, 2015-09-17 15:44:48.017, null, null, 207, null).\r\n        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)\r\n        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)\r\n        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)\r\n        at sun.reflect.GeneratedMethodAccessor620.invoke(Unknown Source)\r\n        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n        at java.lang.reflect.Method.invoke(Method.java:606)\r\n        at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:453)\r\n        at com.sun.proxy.$Proxy209.executeUpdate(Unknown Source)\r\n        at com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:125)\r\n        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)\r\n        ... 98 more\r\n]]\r\n"},"comment":{"url":"https://api.github.com/repos/IQSS/dataverse/issues/comments/141292678","html_url":"https://github.com/IQSS/dataverse/issues/2542#issuecomment-141292678","issue_url":"https://api.github.com/repos/IQSS/dataverse/issues/2542","id":141292678,"user":{"login":"landreev","id":737558,"avatar_url":"https://avatars.githubusercontent.com/u/737558?v=3","gravatar_id":"","url":"https://api.github.com/users/landreev","html_url":"https://github.com/landreev","followers_url":"https://api.github.com/users/landreev/followers","following_url":"https://api.github.com/users/landreev/following{/other_user}","gists_url":"https://api.github.com/users/landreev/gists{/gist_id}","starred_url":"https://api.github.com/users/landreev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/landreev/subscriptions","organizations_url":"https://api.github.com/users/landreev/orgs","repos_url":"https://api.github.com/users/landreev/repos","events_url":"https://api.github.com/users/landreev/events{/privacy}","received_events_url":"https://api.github.com/users/landreev/received_events","type":"User","site_admin":false},"created_at":"2015-09-18T00:12:54Z","updated_at":"2015-09-18T00:12:54Z","body":"Please retest."}}