[OFBIZ-7626] Getting error on closing or re-opening the project

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Release Branch 14.12, Release Branch 15.12, Trunk
• Fix Version/s: Trunk
• Component/s: scrum
• Assignee: Aditi Patidar
• Reporter: Aditi Patidar
• Created: 27/Jun/16 13:36
• Updated: 27/Jun/16 13:54
• Resolved: 27/Jun/16 13:54

Description

Steps to regenerate issue:
1. Navigate to 'SCRUM' -> 'Project/Sprint'.
2. Open an existing project or create one.
3. Press 'Close' button.

The Following error occurred:

[java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |GenericDelegator              |E| Failure in create operation for entity [WorkEffortGoodStandard]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][createdTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][fromDate,2016-06-21 12:05:50.574(java.sql.Timestamp)][lastUpdatedStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID'  cannot accept a NULL value.)). Rolling back transaction.
     [java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
     [java] java.lang.Exception: Failure in create operation for entity [WorkEffortGoodStandard]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortGoodStandard][createdStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][createdTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][fromDate,2016-06-21 12:05:50.574(java.sql.Timestamp)][lastUpdatedStamp,2016-06-21 12:05:50.649(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-21 12:05:50.502(java.sql.Timestamp)][statusId,WEGS_CREATED(java.lang.String)][workEffortGoodStdTypeId,SCRUM_PRO_WORKEFF(java.lang.String)][workEffortId,DEMO-PROJECT-1(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_GOOD_STANDARD (WORK_EFFORT_ID, PRODUCT_ID, WORK_EFFORT_GOOD_STD_TYPE_ID, FROM_DATE, THRU_DATE, STATUS_ID, ESTIMATED_QUANTITY, ESTIMATED_COST, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'PRODUCT_ID'  cannot accept a NULL value.)). Rolling back transaction.
     [java] 	at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:360) [ofbiz-entity.jar:?]
     [java] 	at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:301) [ofbiz-entity.jar:?]
     [java] 	at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:925) [ofbiz-entity.jar:?]
     [java] 	at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:770) [ofbiz-entity.jar:?]
     [java] 	at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:305) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.method.conditional.MasterIf.exec(MasterIf.java:81) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:305) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:452) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:269) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.minilang.SimpleMethod.runSimpleEvent(SimpleMethod.java:252) [ofbiz-minilang.jar:?]
     [java] 	at org.ofbiz.webapp.event.SimpleEventHandler.invoke(SimpleEventHandler.java:75) [ofbiz-webapp.jar:?]
     [java] 	at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:757) [ofbiz-webapp.jar:?]
     [java] 	at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:477) [ofbiz-webapp.jar:?]
     [java] 	at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) [ofbiz-webapp.jar:?]
     [java] 	at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:89) [ofbiz-webapp.jar:?]
     [java] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) [servlet-api-3.1.jar:?]
     [java] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api-3.1.jar:?]
     [java] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:326) [ofbiz-webapp.jar:?]
     [java] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) [tomcat-8.0.33-catalina.jar:8.0.33]
     [java] 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
     [java] 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
     [java] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
     [java] 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) [tomcat-8.0.33-tomcat-coyote.jar:8.0.33]
     [java] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60]
     [java] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60]
     [java] 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-8.0.33-tomcat-util.jar:8.0.33]
     [java] 	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60]
     [java] 2016-06-21 12:05:50,649 |http-nio-8443-exec-1 |CreateValue

Issue Links

• duplicates: OFBIZ-7262 Error on closing and re-opening of project