Aditi Patidar created OFBIZ-7626:
------------------------------------
Summary: Getting error on closing or re-opening the project
Key: OFBIZ-7626
URL: https://issues.apache.org/jira/browse/OFBIZ-7626
Project: OFBiz
Issue Type: Bug
Components: specialpurpose/scrum
Affects Versions: Release Branch 15.12, Trunk, Release Branch 14.12
Reporter: Aditi Patidar
Assignee: Aditi Patidar
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:
{code}
[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
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
